Excel Interview Prep
The most asked Excel questions for analyst, ops, and finance roles — with formulas, examples, and interviewer tips. Free, no sign-up.
What is VLOOKUP and when do you use it?
What is XLOOKUP and how is it better than VLOOKUP?
What is HLOOKUP?
What is INDEX-MATCH and why do analysts prefer it over VLOOKUP?
What happens when VLOOKUP cannot find a value?
What is the IF function?
What are nested IFs and what is a cleaner alternative?
What is IFERROR and when do you use it?
What are AND and OR functions?
What is SUMIF and how does it differ from SUMIFS?
What is COUNTIF and COUNTIFS?
What does CONCATENATE do? What is the modern alternative?
What are LEFT, RIGHT, and MID functions?
What does TRIM do?
What is the LEN function used for?
How do you convert text to upper, lower, or proper case?
What is TODAY() and NOW()?
How do you calculate the number of days between two dates?
What is DATEDIF?
What does ROUND do and how is it different from INT?
What is the difference between AVERAGE, AVERAGEIF, and AVERAGEIFS?
What is a Pivot Table and what is it used for?
What is the difference between a Pivot Table and regular formulas?
What is a slicer in a Pivot Table?
What is "Value Field Settings" in a Pivot Table?
What are the most important Excel keyboard shortcuts?
What is the difference between absolute, relative, and mixed cell references?
What does Ctrl+Shift+Enter do in Excel?
How do you freeze panes and why would you use them?
How do you remove duplicates in Excel?
What is Conditional Formatting?
What is Data Validation in Excel?
What is the difference between Paste and Paste Special?
What are the most common business uses of Excel in analyst and ops roles?
What is an Excel Table (Ctrl+T) and why use it instead of a plain range?
How do you sort data in Excel?
How do you use AutoFilter and what can you do with it?
What is a Named Range and why is it useful?
What features do you combine to build an Excel dashboard?
What is a sparkline in Excel?
How do you create a Pivot Table from scratch?
How do you group dates by month or quarter in a Pivot Table?
What is a Calculated Field in a Pivot Table?
How do you connect one slicer to multiple Pivot Tables?
How do you sort data quickly using keyboard shortcuts?
What does Ctrl+Shift+Arrow do, and why is it useful?
What are the most useful shortcuts for navigating and working with large datasets?