CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Advanced Excel mock test: free online practice

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.

Choose your experience

Free with a CoreHRx Jobs account: you will be asked to sign in or create one first.

What does the Advanced Excel mock test cover?

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.

  • 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

Sample Advanced Excel mock test questions

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.

  1. FresherPivot Tables

    Gaurav builds a pivot table from A1:E7 with City in Rows and Sum of Amount in Values. What does it show for Delhi?

       A      B        C        D      E
    1  Rep    City     Product  Units  Amount
    2  Asha   Pune     Laptop   3      165000
    3  Ravi   Delhi    Printer  5      62500
    4  Meena  Pune     Printer  2      25000
    5  Imran  Chennai  Laptop   1      55000
    6  Kavya  Delhi    Laptop   4      220000
    7  Arjun  Pune     Monitor  6      54000
    Pivot table: Rows = City, Values = Sum of Amount
    • 2
    • 244000
    • 282500
    • 141250
    Show the answer

    Answer: 282500. The pivot groups the rows by City and, with Sum, adds the Amount of every Delhi row: Ravi's 62500 plus Kavya's 220000 gives 282500. SUMIFS for Delhi gives the same total, but the pivot needs no formula.

  2. Intermediate (1-5 years)Logical Functions

    B2 came from a form export and holds the text yes followed by one space. What does C2 return?

       A     B
    1  Name  Consent
    2  Asha  "yes "
    
    C2: =IF(B2="Yes",1,0)
    • 1
    • 0
    • #VALUE!
    • TRUE
    Show the answer

    Answer: 0. Text comparison ignores case, so yes and Yes would match, but every other character counts, and the trailing space makes "yes " different from "Yes". C2 shows 0. Wrapping B2 in TRIM fixes it.

  3. Experienced (5+ years)Text Functions

    B2 adds a non-breaking space, as text copied from a web page often has. What do C2 and C3 return?

       A
    1  Name
    2  Asha
    
    B2: =A2&CHAR(160)
    C2: =LEN(TRIM(B2))
    C3: =LEN(TRIM(SUBSTITUTE(B2,CHAR(160)," ")))
    • C2: 5, C3: 5
    • C2: 4, C3: 5
    • C2: 5, C3: 4
    • C2: 4, C3: 4
    Show the answer

    Answer: C2: 5, C3: 4. TRIM removes only the normal space, character 32, so the non-breaking space, CHAR(160) in Excel for Windows, survives and LEN is 5. Turning it into a normal space with SUBSTITUTE first lets TRIM remove it: 4.

Take the full Advanced Excel mock test: 15 to 30 questions and 15 to 30 minutes, by level.

How is the Advanced Excel mock test scored?

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.

  • 75% or more in a topica strength
  • 50% to 74%worth a revision
  • Under 50%a topic to work on

Advanced Excel mock test: questions people ask

Is the Advanced Excel mock test free?

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.

How many questions are in the Advanced Excel mock test?

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.

Which Advanced Excel topics does the test cover?

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.

Which level should I choose?

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.

Can employers see my Advanced Excel score?

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.

Can I take the Advanced Excel mock test again?

Yes, up to 10 tests a day. Each attempt picks questions you have not seen recently first.

All mock tests