Solved

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions