A Shadow Data Dashboard in an Excel Spreadsheet Can Be

question 27

Multiple Choice

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

---

Definitions:

Loan

An amount of money lent that must be repaid along with interest.

Compounded Daily

Interest calculation method where the interest is calculated and added to the principal amount daily, leading to increased earnings or payments over time.

Daily Payments

Payments made on a daily basis, often used in the context of loans or labor wages.

Loan

Money that is borrowed and should be returned with added interest.