When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?
A) The Paste Options button then lets you paste specific elements of the copied cells.
B) The formula is copied with cell references you must adjust to avoid worksheet errors.
C) The Auto Fill Options button appears.
D) Pointing to the destination cell causes a preview of the cell contents to appear.

Question

Quizplus · Accepted Answer

The Paste Options button allows you to choose which elements of the copied cells to paste, such as values only, formatting, or the formulas themselves. This feature provides flexibility in how the copied information is integrated into the destination area.

When You Paste Formula Cells Using the Paste Button in the Clipboard