When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
A) A button appears near the selected cells with options for pasting formulas and values.
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 displays a preview of the cell contents.
Correct Answer:
Verified
Q40: Your worksheet contains confidential information in column
Q42: To move a worksheet,you can drag its
Q55: When you insert a worksheet row,a row
Q70: To select nonadjacent cells or ranges on
Q79: When you click a cell to insert
Q85: Which of the following is true about
Q86: Myra does not want a worksheet of
Q87: When you _ a formula, Excel retrieves
Q88: When you copy a formula from cell
Q596: Which of the following is not a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents