Excel Lesson 7 Quiz

A method of identifying cells in a spreadsheet formula based on their locations, rather than the location of the formula.

A function that calculates the average value of a group of numbers based on a given criteria.

A function that counts the number of cells within a specified range that meet a given criteria.

A function that evaluates a condition as TRUE or FALSE, then returns a unique result for each outcome.

A method of identifying cells in a spreadsheet formula based on the location of the formula, rather than the location of the cells.

A function that adds together all of the values in a group of numbers based on a given criteria.