Excel Unit B

An absolute cell reference changes the cell references when the formula is copied to a new location.

• True

• False

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

• True

• False

An Excel complex formula uses more than one arithmetic operator.

• True

• False

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

• True

• False

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).

• True

• False

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

• True

• False

=D8+E8*0.5 is a complex formula.

• True

• False

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

• True

• False

The COUNT function in Excel returns the number of all cells in a range that contain any type of data.

• True

• False

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

• True

• False