Asked by Quitta Moore on May 07, 2024
Verified
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.
AutoFill Options Button
An interface button that, when activated, provides options to automatically complete filling data in fields based on patterns, preferences, or previously entered information.
Paste Options Button
A feature in software applications that allows users to choose how copied content will be inserted into a document.
- Employ the formula and function capabilities of Excel to facilitate automated calculations in spreadsheets.
- Learn about the changes in relative and absolute references in formulas during the process of copying or moving them.
Verified Answer
AL
Alasdair Lindsay-WaltersMay 14, 2024
Final Answer :
B
Explanation :
The AutoFill Options button lets you fill cells with specific elements of the copied cell. This allows you to choose whether you want to copy the formula, values, formatting, or a combination of these elements. Option A is incorrect because the Paste Options button allows you to choose how you want to paste a selection, not specific elements of the copied selection. Option C is incorrect because the formula is copied to the clipboard, not placed on the Office clipboard. Option D is incorrect because the fill handle automatically adjusts cell references for you.
Learning Objectives
- Employ the formula and function capabilities of Excel to facilitate automated calculations in spreadsheets.
- Learn about the changes in relative and absolute references in formulas during the process of copying or moving them.