40 questions · 50 minutes · Excel
advance excel essentials quiz 1 practice quiz
40 simple MCQs covering Conditional Formatting, Data Validation, Logical & Lookup Functions, PivotTables, PivotCharts, and KPI basics.
Before you start
Answer all 40 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
- 40
- Time
- 50 minutes
- Marks
- 40
- Subject
- Excel
- Marking
- Server-side
What it asks
The first few questions
- What is Conditional Formatting used for in Excel?
- Where is Conditional Formatting found?
- Which Conditional Formatting option shows color gradients?
- Which rule type shows arrows, stars or flags?
36 more once you begin. Options are withheld until the attempt starts — the answer key never reaches the browser before you have been marked.