If a Company Is Using a Previous Version of Excel

question 37

Multiple Choice

If a company is using a previous version of Excel without PowerPivot,they can use Conditional Formatting ________ instead to indicate proximity to various KPI goals.

• A)Highlight Cells Rules
• B)Data Bars
• C)Color Scales
• D)Icon Sets

---

Definitions:

Work Sheet

A document used in accounting to gather information from ledger accounts for the preparation of financial statements.

Temporary Accounts

Accounts used to collect revenues, expenses, and dividends information which are then transferred to permanent accounts at the end of the accounting period.

Closed

Refers to an account or period that has been concluded and no longer accepts entries or transactions.

Accrual Basis

An accounting method where revenues and expenses are recorded when they are earned or incurred, regardless of when the cash is exchanged.