A shadow data dashboard in an Excel spreadsheet can be created using
A)AutoFilter and PivotCharts
B)Conditional Formatting and Subtotal
C)PivotTables and PivotCharts
D)PivotTables and Conditional Formatting

Question

Quizplus · Accepted Answer

A shadow data dashboard typically involves analyzing data through summarization, visualization, and exploration. PivotTables and PivotCharts are the most appropriate Excel tools for building a shadow data dashboard since they allow for the efficient organization and summarization of large datasets, as well as the creation of interactive charts and graphs. Conditional formatting and Subtotal are helpful for highlighting specific values or aggregations but do not provide the same level of flexibility as PivotTables and PivotCharts. AutoFilter is also useful for sorting and filtering data but is not suitable for building a comprehensive dashboard.

A Shadow Data Dashboard in an Excel Spreadsheet Can Be