Multiple Choice
When you insert a column in a worksheet, what happens to formulas you already entered?
A) Excel updates their cell references to reflect the new layout.
B) The formulas remain in the same cells.
C) The cells with formulas display an error so you can correct them.
D) The formulas need to be updated manually.
Correct Answer:
Verified
Correct Answer:
Verified
Q16: To print a worksheet,you begin by going
Q27: Your worksheet contains a price in cell
Q457: Which of the following is not true
Q458: When you freeze the top row of
Q459: The VLOOKUP function returns the position of
Q460: Edie has a worksheet listing lectures scheduled
Q461: A(n) Summary function calculates summary statistics including
Q463: Isabel has a PivotTable listing revenue from
Q465: Miley can copy a worksheet instead of
Q466: Which of the following is the default