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:

Verified
Correct Answer:
Verified
Q2: Currency is an example of a number
Q4: To display a tracer arrow to each
Q15: To change the background color of a
Q19: Stuart inserts the formula '=YEAR ('23-Aug-2012)' into
Q185: When you create a calculated item for
Q189: A good practice is to move the
Q192: A _ is text or an image
Q193: Which of the following is a type
Q194: How can you hide the filter buttons
Q202: Which of the following Excel features finds