Excel Formulas

What does the Lower formula do in Excel?

• Finds the three lowest numbers and adds them together.

• Returns the lowest number in a string.

• Converts all letters in a text string to lowercase letters.

• Changes the lowest number to a formula.

What does the Average formula return?

• Returns the lowest argument.

• Returns the middle argument.

• Returns the three highest arguments.

• Returns the mean of all its arguments.

What does the Sumif formula return?

• adds the cells specified by a given condition or criteria.

• adds up all numbers (arguments) in a row you specify.

• allows you to pick individual numbers you want to add up by manually click on each number.

• Counts the number of items in a set of values that meet your criteria.

What does the Max formula do?

• Returns the highest three values in a set of values and ignores text.

• Returns the largest value in a set of values and ignores text.

• Returns the text that you are searching for.

• Returns the smallest value in a set of values and ignores text.

What does the Min formula return?

• Returns the smallest three numbers form a set and ignores text.

• Returns the smallest value in a set of values and ignores text.

• Returns the largest three numbers form a set and ignores text.

• Returns the largest value in a set of values and ignores text.

What does the Countif formula return?

• Counts the number of cells within a range that meets the given condition.

• Counts the number of words within a range that meets the given condition.

• Counts the number of columns within a range that meets the given condition.

• Counts the number of letters within a range that meets the given condition.

What does the Counta formula return?

• Counts the number of cells within a range that meets the given condition.

• Counts the number of cells in a range that are not empty.

• Counts the number of columns within a range that meets the given condition.

• Counts the number of columns in a range that are not empty.