DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
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?
|
|
Click the AutoFill Options button and then click Fill Without formatting.
|
|
|
Click the AutoFill Options button and then click fill formatting Only.
|
|
|
Click the Paste Options button and then click Undo.
|
|
|
Click the Quick Analysis button and then click Fill Without Formatting
|
Explanation:
Detailed explanation-1: -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? Click the AutoFill Options button and then click Fill Without Formatting.
Detailed explanation-2: -The copy/paste shortcuts copy the formula and formatting. To copy the formula without formatting, choose an appropriate Paste option on the ribbon or in the right-click menu, as demonstrated in Copying an Excel formula without formatting.
There is 1 question to complete.