Creating Dashboards in Excel MCQs

1. What is the primary purpose of a dashboard in Excel?
(A) To store large amounts of raw data
(B) To provide a visual summary of key metrics and trends
(C) To create only pivot tables
(D) To replace all charts in Excel

2. Which Excel feature is most commonly used to create interactive dashboards?
(A) PivotTables and PivotCharts
(B) Page Layout
(C) Mail Merge
(D) Spelling and Grammar

3. What is the role of slicers in an Excel dashboard?
(A) To format text automatically
(B) To filter and interactively control data in PivotTables and PivotCharts
(C) To delete duplicate rows
(D) To merge cells in reports

4. Which chart type is best suited for showing trends over time in a dashboard?
(A) Scatter Plot
(B) Pie Chart
(C) Line Chart
(D) Doughnut Chart

5. What does conditional formatting help with in dashboards?
(A) Automatically creating PivotTables
(B) Adding page breaks
(C) Saving Excel files as PDF
(D) Highlighting important data patterns or thresholds

6. Which Excel tool allows summarizing large datasets for dashboards?
(A) PivotTable
(B) Data Validation
(C) Goal Seek
(D) Text to Columns

7. Why are KPIs (Key Performance Indicators) important in dashboards?
(A) They help measure progress against business goals
(B) They reduce file size
(C) They are used only for formatting
(D) They replace pivot tables

8. Which Excel feature allows combining data from multiple sources into one dashboard?
(A) Power Query / Get & Transform
(B) Spell Checker
(C) Data Validation
(D) Macros Recorder

9. What is the main advantage of using a dashboard instead of raw tables?
(A) Dashboards increase file printing speed
(B) Dashboards automatically repair broken formulas
(C) Dashboards make complex data easy to understand visually
(D) Dashboards convert files into Word documents

10. Which design principle is most important when creating an Excel dashboard?
(A) Keep it simple, clear, and focused on key insights
(B) Use as many colors and charts as possible
(C) Add long text descriptions for each value
(D) Hide all slicers and filters from users