Excel Unit E

If a number is divided by zero, the error value #DIV/0! will display in the cell.

• True

• False

The parts of an IF function are separated by parentheses.

• True

• False

The symbol <> stands for “equal to.”

• True

• False

Data can be consolidated from different workbooks in one worksheet.

• True

• False

Symbols, such as less than (<), greater than (>), and equal to (=), are all examples of comparison operators.

• True

• False

The CONCATENATE function breaks a text string into separate strings.

• True

• False

If a value in a formula is not available, the error value #VALUE! will display in the cell.

• True

• False

A delimiter is a data separator.

• True

• False

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

• True

• False

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather than the formula results.

• True

• False