12,900+ practice questions · 144 exams · new questions added every week

Data Analyst Excel practice questions

10 free questions with answers and explanations. Try each one, then tap “Show answer”.

  1. Functions

    1. What does =ROUND(16.43,1) return?

    • A. 16.4
    • B. 16.5
    • C. 16.43
    • D. 16
    Show answer

    Answer: A. 16.4

    Rounding 16.43 to 1 decimal place gives 16.4.

  2. Logic

    2. A: Name · B: Region · C: Sales Row 2: Dayo · East · 27 Row 3: Hana · East · 21 Row 4: Eve · South · 6 Row 5: Ben · South · 18 Row 6: Femi · East · 25 Row 3 contains =IF(C3>=20,"High","Low"). What does it show?

    • A. TRUE
    • B. High
    • C. Low
    • D. #VALUE!
    Show answer

    Answer: B. High

    C3 is 21, which is at least 20.

  3. Logic

    3. A: Name · B: Region · C: Sales Row 2: Femi · South · 28 Row 3: Dayo · South · 8 Row 4: Cara · South · 30 Row 5: Ben · North · 6 Row 6: Grace · North · 27 Row 2 contains =IF(C2>=10,"High","Low"). What does it show?

    • A. #VALUE!
    • B. High
    • C. TRUE
    • D. Low
    Show answer

    Answer: B. High

    C2 is 28, which is at least 10.

  4. Lookups

    4. One advantage of XLOOKUP over VLOOKUP is that XLOOKUP

    • A. can return values from columns to the left of the lookup column
    • B. only works on numbers
    • C. requires sorted data
    • D. can't do exact matches
    Show answer

    Answer: A. can return values from columns to the left of the lookup column

    It also defaults to an exact match.

  5. Analysis

    5. Which tool imports, cleans and reshapes data with repeatable steps?

    • A. Sparklines
    • B. Goal Seek
    • C. Power Query
    • D. Scenario Manager
    Show answer

    Answer: C. Power Query

    Each step is recorded and can be refreshed.

  6. Functions

    6. A: Name · B: Region · C: Sales Row 2: Dayo · East · 4 Row 3: Eve · East · 25 Row 4: Ada · North · 10 Row 5: Cara · South · 20 Row 6: Ben · East · 6 What does =MAX(C2:C6) return?

    • A. 65
    • B. 4
    • C. 25
    • D. 28
    Show answer

    Answer: C. 25

    The largest value in C2:C6 is 25.

  7. Logic

    7. A: Name · B: Region · C: Sales Row 2: Femi · North · 30 Row 3: Ben · East · 20 Row 4: Dayo · South · 7 Row 5: Ada · East · 21 Row 6: Cara · North · 26 Row 4 contains =IF(C4>=15,"High","Low"). What does it show?

    • A. Low
    • B. High
    • C. #VALUE!
    • D. TRUE
    Show answer

    Answer: A. Low

    C4 is 7, which is below 15.

  8. Functions

    8. A: Name · B: Region · C: Sales Row 2: Hana · North · 25 Row 3: Ada · East · 7 Row 4: Cara · East · 13 Row 5: Eve · South · 17 Row 6: Ben · North · 5 What does =COUNTIF(C2:C6,">20") return?

    • A. 1
    • B. 2
    • C. 0
    • D. 5
    Show answer

    Answer: A. 1

    1 values are greater than 20.

  9. Lookups

    9. In VLOOKUP, the last argument FALSE means

    • A. return blank
    • B. approximate match
    • C. case-sensitive match
    • D. exact match
    Show answer

    Answer: D. exact match

    TRUE (approximate) needs sorted data.

  10. Lookups

    10. A: Name · B: Region · C: Sales Row 2: Eve · North · 3 Row 3: Grace · North · 20 Row 4: Femi · North · 21 Row 5: Ben · South · 10 Row 6: Cara · East · 19 What does =XLOOKUP("Ben",A2:A6,C2:C6) return?

    • A. 10
    • B. 20
    • C. 21
    • D. 3
    Show answer

    Answer: A. 10

    XLOOKUP finds "Ben" in A and returns the matching value in C: 10.

Want more Data Analyst Excel questions?

Get fresh questions every day, focused on your weak topics, plus timed mock tests. Free to start.

Practise free in the web app Practise on Telegram

More Data Analyst practice

About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.