An MS Excel Function used to find the total of a row or column of values in a data set.

This function returnes the sum of cells that meet a single condition or criteria.

This MS Excel Function is used to get the number of entries in a number field that is in a range or array of numbers.

This formula joins up values together and returns the result as a text.

The ______ Function runs a logical test and returns one value for a TRUE result, and another for a FALSE result.

This MS Excel Function is used to look up a value in a table.

The _____ function capitalizes each work in a given text string.

A _____ is a range of cells that show how changing one or two variables in your formula affect the result of other formulas.