Data Analyst Excel practice questions
10 free questions with answers and explanations. Try each one, then tap “Show answer”.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
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 TelegramMore Data Analyst practice
About the Data Analyst on Mock Night · Original practice questions; not affiliated with the exam board.