When Valerie Used AutoFill to Copy a Formula, Excel Copied

question 190

Multiple Choice

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

• A) Click the AutoFill Options button and then click Fill Without Formatting.
• B) Click the AutoFill Options button and then click Fill Formatting Only.
• C) Click the Paste Options button and then click Undo.
• D) Click the Quick Analysis button and then click Fill Without Formatting.

---

Definitions:

Retention Program

A set of activities or strategies designed by a business to increase the likelihood of a customer continuing to use their service or purchase their products.

Affordable Method

A budgeting technique where the cost of an action or project is determined based on what is financially feasible.

Principal Accounting Method

The main system a business uses to maintain its financial records and prepare financial statements, such as accrual or cash basis accounting.

Budgeting Method

A systematic approach to managing income and expenses, ensuring that financial resources are allocated efficiently.