Advanced Excel Question Sheets
Topic-wise Advanced Excel question sheets — 200 questions across 8 topics. Open each sheet online and tick questions as you solve them.
Excel Fundamentals and Formatting Interview Questions
The base every Excel job tests: cell references, Tables, number formats, conditional formatting, data validation, protection and the shortcuts that…
Logical, Text and Date Functions Interview Questions
Formulas that power everyday reports: IF, IFS, AND, OR, SUMIFS, COUNTIFS, text cleaning with TRIM and TEXTBEFORE, date logic with EOMONTH and…
Lookup and Dynamic Array Functions Interview Questions
VLOOKUP, INDEX/MATCH and XLOOKUP for fetching data across sheets, along with FILTER, SORT, UNIQUE and other dynamic array functions. Interviews test…
Pivot Tables and Data Summaries Interview Questions
Pivot tables summarise thousands of rows in seconds. This topic covers the four areas, grouping, Show Values As, calculated fields, slicers, distinct…
Charts and Dashboards Interview Questions
Choosing the right chart and building interactive dashboards that managers actually use. Covers combo charts, waterfall, Pareto, sparklines, dynamic…
Power Query and Data Cleaning Interview Questions
Power Query imports, cleans and reshapes data with recorded steps that rerun on refresh. Learn folder imports, append and merge, join kinds, unpivot,…
Power Pivot, Data Model and DAX Interview Questions
The Data Model lets Excel handle millions of rows across related tables. This topic covers star schema, relationships, calculated columns versus…
Macros and VBA Automation Interview Questions
VBA automates repetitive Excel work: formatting, consolidating files, exporting PDFs and sending emails. Learn the macro recorder and its limits,…
Frequently asked questions
What are question sheets?
Topic-wise lists of Advanced Excel interview questions with answers — 200 questions across 8 topics. Tick questions as you solve them; progress is saved in your browser.
Which sheet should I start with?
Start with Excel Fundamentals and Formatting, then Logical, Text and Date Functions. Use the role-wise pages to see which topics matter most for the job you want.