Excel for Business Analysts Interview Questions for Business Analytics
43 Excel for Business Analysts questions with answers for business analytics roles — 14 easy, 26 medium, 3 hard.
About Excel for Business Analysts
Excel is still the daily tool for most business analysts in India. Interviews check lookups, SUMIFS and dynamic arrays, PivotTables, what-if analysis, data cleaning and building simple models and dashboards. Expect live formula questions and scenarios about reconciling files, fixing errors and automating repetitive monthly reports with Power Query and tables.
Which Excel functions do business analysts use daily?
Show answer
XLOOKUP vs VLOOKUP?
Show answer
What is the difference between absolute, relative and mixed cell references in Excel?
Show answer
What are Excel Tables (Ctrl+T) and why should analysts use them?
Show answer
What is conditional formatting and how would you use it in a business report?
Show answer
A lookup formula returns #N/A for some rows even though the values look present. What could be wrong?
Show answer
Write an Excel formula that labels sales as High (100000 or more), Medium (50000 or more) or Low.
Show answer
Write an Excel formula to extract the domain from an email address.
Show answer
Write an Excel formula for working days between two dates excluding weekends and holidays.
Show answer
Write an Excel formula for the weighted average selling price across orders.
Show answer
Users in a shared Excel tracker keep typing region names with different spellings. How do you stop this?
Show answer
Write an Excel formula that lists all North region orders above 50,000 rupees.
Show answer
You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?
Show answer
What is a data table in Excel?
Show answer
How do you build a PivotTable to analyse sales by region and product?
Show answer
How do you compute CAGR in Excel?
Show answer
What is sensitivity analysis?
Show answer
How do you chart a trend with a target line?
Show answer
Build a break-even analysis in Excel.
Show answer
How do you build a forecast in Excel?
Show answer
How would you forecast next quarter's sales in Excel?
Show answer
Which what-if analysis tools does Excel have?
Show answer
What is the use of the IFERROR function?
Show answer
How do you handle large datasets in Excel?
Show answer
How do you calculate the percentage contribution of each category?
Show answer
What is the difference between XLOOKUP and INDEX-MATCH?
Show answer
How do you use Excel's Scenario Manager?
Show answer
How do you protect a worksheet or workbook?
Show answer
How would you build a simple financial model in Excel?
Show answer
When would you use SUMPRODUCT instead of SUMIFS?
Show answer
What are dynamic array functions in Excel and how do they help analysts?
Show answer
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Show answer
Your monthly Excel report takes a full day of manual work. How would you automate it?
Show answer
Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.
Show answer
Write an Excel formula to count the number of unique customers in a column.
Show answer
Write an Excel formula for a two-way lookup that finds sales for a given product and month.
Show answer
Write an Excel formula for month-to-date sales up to today.
Show answer
Tell me about a time you found an error in a spreadsheet just before it went to management.
Show answer
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
Show answer
What is Excel Solver and give a business example of using it.
Show answer
Finance asks you to build a monthly cohort retention table in Excel from raw order data. How do you approach it?
Show answer
How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.
Show answer
Frequently asked questions
How important is Excel for Business Analysts in Business Analytics interviews?
Excel is still the daily tool for most business analysts in India. Interviews check lookups, SUMIFS and dynamic arrays, PivotTables, what-if analysis, data cleaning and building simple models and dashboards. Expect live formula questions and scenarios about reconciling files, fixing errors and automating repetitive monthly reports with Power Query and tables.
How should I use the Excel for Business Analysts sheet?
Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.