Exam 12: Excel: Relational Databases and Queries

A relative cell ________ indicates a cell's relative location.

For a basic mathematical expression it is best to use

The AVERAGE function

The IF function only evaluates a condition if the condition is true.

A formula in Excel must begin with

The ________ returns one value if a condition is true and another value if a condition is false.

A Range name can contain up to 1000 characters but it must begin with a number.

The MIN function

The PMT function calculates The breakpoint of the lowest value for a specific category.

The PMT function

The COUNTBLANK function

The COUNTA function

A ________ name is a word or string of characters that represent one or more cells.

Semi-selection is often called ________ because you use the mouse to select cells as you build the formula.

The NPER

The MAX function identifies the highest value in a range.

A relative cell reference

The MAX function

A function is a predefined formula that performs a calculation.

The ________ value is a reference to a cell containing a value to look up for a function.