Which of the following is NOT true about working with formulas?

A) 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.
B) Cells that contain formulas can be treated like any other worksheet 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) In Excel, formulas always begin with an equal sign.


C

Computer Science & Information Technology

You might also like to view...

________ are printouts that have a slide on the top half and notes on the bottom half

Fill in the blank(s) with correct word

Computer Science & Information Technology

When importing a Word document into PowerPoint, the document must be in outline format and use ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

A user can sort on more than field within a table

Indicate whether the statement is true or false

Computer Science & Information Technology

When might you not want to skip a tab stop?

A. Calculated field B. AutoNumber field C. Combo Box field D. Any time the field requires no data entry

Computer Science & Information Technology