USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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: -You can also use Auto Fill to simply copy and paste a value to other cells. Select the cell that contains the data you want to copy. Position the mouse over the bottom-right corner of the cell. Before clicking and dragging, make sure you see a black plus symbol.
There is 1 question to complete.