Which of the following is NOT true about working with formulas?
A) In Excel, formulas always begin with an equal sign.
B) When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell.
C) To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.
D) Cells that contain formulas can be treated like any other worksheet cell.

Question

Quizplus · Accepted Answer

To copy a formula and not change relative references, you can use the shortcut Ctrl + C to copy the formula, select the destination cell and press Ctrl + Alt + V to open the Paste Special dialog box. From here, you can select 'Formulas' and choose 'Transpose' if necessary. Option A is true, as formulas in Excel must always begin with an equal sign. Option B is true, as when you copy a formula with cell references to another cell, the cell reference will adjust based on its relationship to the new cell. Option D is true, as Excel treats all cells equally, regardless of whether they contain formulas or other types of data.

Which of the Following Is NOT True About Working with Formulas