Excel Chapter 2 Review

A ____ is a prewritten formula that is built into Excel.

• function

• feature

• calculation

• task

To start a new line in a cell, press the ____ keys.

• CTRL+ENTER

• TAB+ENTER

• ALT+ENTER

• SHIFT+ENTER

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

• contiguous

• indexed

• direct

• indirect

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

• placement

• operations

• positioning

• selections

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

• 40

• 26

• 48

• 13

Which of the following happens when you enter the formula =G15 into a cell?

• Excel recalculates all formulas in the worksheet

• Excel assigns the sum of the values in the previous 15 cells to the active cell

• Excel assigns the value in cell G15 to the active cell

• Nothing; =G15 is an invalid formula

Point mode allows you to ____,

• select cells for use in a formula using the keyboard

• select a function from the Sum button list

• select cells for use in a formula using the mouse pointer

• edit cell contents directly in the cell

The adjusted cell references in a copied and pasted formula are called ____ cell references.

• related

• relative

• pasted

• alternative

You can click the ____ button to undo an automatic correction.

• Auto Fill Options

• Auto Correct Options

• Paste Options

• Trace Error

Which of the following Option buttons gives options for filling cells following a fill operation?

• Auto Fill Options

• Auto Correct Options

• Insert Options

• Paste Options