Excel 5 & 6 Vocab

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.

• AutoSum

• COUNT function

• COUNTA function

• COUNTBLANK function

A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the AVERAGE function in its formula.

• AVERAGE function

• COUNT function

• COUNTBLANK function

• function

A function that determines how many cells in a range contain a number.

• COUNT function

• COUNTA function

• function

• COUNTBLANK function

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

• COUNTA function

• COUNTBLANK function

• MAX function

• merged cells

A function that counts the number of blank cells in a range.

• COUNTBLANK function

• function

• MAX function

• merged cells

A function that returns the largest value in a set of values.

• MAX function

• function

• merged cells

• SUM function

A predefined formula that performs a calculation.

• function

• merged cells

• MIN function

• COUNTBLANK function

Two or more cells combined into a single cell.

• merged cells

• MIN function

• SUM function

• COUNTBLANK function

A function that determines the minimum value in a range of cells.

• MIN function

• SUM function

• MAX function

• merged cells

A function that totals all of the cells in a range.

• SUM function

• MIN function

• merged cells

• MAX function