35 questions · 45 minutes · Excel
advance excel interview quiz 1 practice quiz
35 practical MCQs for Excel interview preparation — covering Conditional Formatting, Data Validation, Logical & Lookup Functions, PivotTables, PivotCharts, and KPI dashboards.
Before you start
Answer all 35 questions. 1 mark each. No negative marking.
You can take this without an account and you will still get the full marked review. Only signed-in attempts are saved — sign in first if you want this one kept in your history.
- Questions
- 35
- Time
- 45 minutes
- Marks
- 35
- Subject
- Excel
- Marking
- Server-side
What it asks
The first few questions
- In an Excel interview, you are asked to highlight sales above 10,000 automatically. Which tool would you use?
- Which type of Conditional Formatting helps to show progress visually inside a cell?
- An interviewer asks how to highlight every alternate row. What formula can be used in Conditional Formatting?
- During a task, your manager asks to color the top 5 performers in green. Which rule should you apply?
31 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.