ICT2-Vocab-Lesson6-Excel

Fill in the Blank

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

Fill in the Blank

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

Fill in the Blank

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

Fill in the Blank

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

Fill in the Blank

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

Fill in the Blank

A predefined formula that performs a calculation.

Fill in the Blank

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

Fill in the Blank

Two or more cells combined into a single cell.

Fill in the Blank

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

Fill in the Blank

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