Multiple Choice
When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?
A) Excel places them on the Clipboard.
B) Excel changes the cell references in the copied formula to reflect the new location of the formula.
C) Excel bolds the cell references so you can change them.
D) Excel displays a button near the copied cell with options for handling the cell references.
Correct Answer:
Verified
Correct Answer:
Verified
Q5: Use a sunburst chart to track the
Q6: Samira has a workbook containing many worksheets
Q7: Nathan wants a formula to return "Yes"
Q10: How do you change the placeholder text
Q20: Where do you rename a workbook and
Q20: While creating a two-variable data table in
Q35: What is the default number of days
Q43: To show all comments in a worksheet,click
Q117: Rohan can display the current date in
Q237: Your worksheet is too wide to fit