15 to 30 random questions in 15 to 30 minutes, by the level you choose: lookups, sumifs, dynamic arrays, pivots, power query, what-if, charts. After you submit you get your score, your strong and weak topics, and the right answer with an explanation for every question.
Want to revise first? Read the Advanced Excel interview questions and answers.
The test covers 13 topics across three levels. Each attempt picks 15 to 30 questions at random, by the level you choose, so every attempt is different.
One question from each level, the way they appear in the test. A new set comes on the 1st of every month. Try it, then open the answer.
Answer: Refresh the pivot table, for example right-click it and choose Refresh. A pivot table reads a stored copy of the data, the pivot cache, so it changes only when refreshed: right-click > Refresh, or Data > Refresh All. F9 recalculates formulas but does not refresh pivot tables.
A B
1 Month Units
2 Apr 120
3 May 145
4 Jun 160
5 Jul 175
D2 holds 4.
E2: =INDIRECT("B"&D2)Answer: 160. "B"&D2 builds the text B4, and INDIRECT turns that text into a real reference, so E2 shows the value in B4, 160. INDIRECT is volatile and does not adjust when rows move, so use it only when the address must be built.
Answer: It can return a wrong row with no error, as approximate match assumes ascending order. Approximate match uses a binary search that relies on ascending order. On unsorted data it stops at a wrong place and still returns a value, which is worse than an error. For IDs always use FALSE or XLOOKUP's default.
Take the full Advanced Excel mock test: 15 to 30 questions and 15 to 30 minutes, by level.
A question counts as right only when you pick exactly the right option, or all the right options where it says so; a question left blank counts as wrong. Your score is the share of the test's questions you got right (15 to 30, by level). The result also scores every topic, so you know what to revise before the interview.
Yes. The Advanced Excel mock test is free. You need a free CoreHRx Jobs account to start it, so your score and the topics to work on are saved.
It depends on the level: Fresher has 15 questions in 15 minutes, Intermediate has 20 questions in 20 minutes, Experienced has 30 questions in 30 minutes. They are multiple-choice questions picked at random from a larger bank of Advanced Excel questions at your level, so every attempt is different.
The questions cover SUMIFS, COUNTIFS and Math, Lookup Functions, Date and Time Functions, Formulas and Cell References, Logical Functions, Pivot Tables, Text Functions, Dynamic Arrays, What-If Analysis, Charts, Data Cleaning and Power Query, Data Validation and Conditional Formatting, Shortcuts and Productivity. Your result shows how you did in each topic.
Fresher if you are a student or have less than a year of experience, Intermediate for 1 to 5 years at work, and Experienced for 5 years or more.
Only your best Advanced Excel score, and only when it is 60% or more. It shows on the job applications you send on CoreHRx. Lower scores stay private.
Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.