Which of the following is true when you copy and paste formulas using the fill handle?
A) The Paste Options button lets you paste only specific elements of the copied selection.
B) The AutoFill Options button lets you fill cells with specific elements of the copied cell.
C) The formula is placed on the Office clipboard.
D) You need to change the cell references to reflect the new formula location.

Question

Quizplus · Accepted Answer

When you copy and paste formulas using the fill handle, you can use the AutoFill Options button that appears at the bottom right corner of the pasted selection. This allows you to choose specific elements of the copied cell to fill the other cells with. The Paste Options button that appears is for pasting formats, not specific elements of the copied selection. The formula is not placed on the Office clipboard and the cell references automatically adjust to reflect the new formula location.

Which of the Following Is True When You Copy and Paste