Creating dashboards – Excel MCQs
1 What is the main purpose of creating a dashboard in Excel?
a) To store large amounts of data
b) To visualize and summarize key metrics and data trends
c) To perform complex calculations
d) To format cells and ranges
Answer: b) To visualize and summarize key metrics and data trends
2 Which Excel feature is commonly used to create interactive elements in dashboards, such as drop-down lists?
a) Data Validation
b) Conditional Formatting
c) PivotTables
d) Chart Tools
Answer: a) Data Validation
3 What is a common method for integrating multiple data sources into a dashboard?
a) Using PivotTables and PivotCharts
b) Applying conditional formatting
c) Creating static charts
d) Using cell references
Answer: a) Using PivotTables and PivotCharts
4 Which feature allows you to create a dynamic chart that updates based on user-selected criteria?
a) Slicers
b) Data Bars
c) Icon Sets
d) Color Scales
Answer: a) Slicers
5 How can you display performance metrics and KPIs on a dashboard in Excel?
a) By using charts and graphical representations
b) By applying cell formatting
c) By inserting large amounts of raw data
d) By using only text descriptions
Answer: a) By using charts and graphical representations
6 What tool in Excel can be used to create a summary of data and metrics for a dashboard?
a) PivotTable
b) Text Box
c) Shape Tool
d) Conditional Formatting
Answer: a) PivotTable
7 Which feature in Excel can be used to display different views or breakdowns of data in a dashboard?
a) Pivot Charts
b) Data Bars
c) Formulas
d) Page Layout
Answer: a) Pivot Charts
8 To ensure that a dashboard updates automatically with new data, what should you use?
a) Dynamic ranges and named ranges
b) Static cell references
c) Manual data entry
d) Data Validation
Answer: a) Dynamic ranges and named ranges
9 Which of the following is NOT a key element of an Excel dashboard?
a) Interactive charts and graphs
b) Slicers and filters
c) Large tables of raw data
d) Summary metrics and KPIs
Answer: c) Large tables of raw data
10 How can you improve the visual appeal and usability of a dashboard in Excel?
a) By using consistent colors and clear labels
b) By using complex formulas
c) By adding excessive text
d) By including multiple unrelated charts
Answer: a) By using consistent colors and clear label