Excel Functions Quiz 10/5

What is the purpose of an Absolute Cell Reference?

• Finding the average of a cell range

• Fast filling into other cells

• Locking the cell reference constant

• Rounding off decimal places

Which function adds up all the cells that have been selected?

• ROUND

• SUM

• AVERAGE

• COUNT

What does the MAX function do?

• Returns the standard deviation of the inputted cell range

• Outputs the middle number of the cells in the inputted cell range

• Finds the smallest number in the inputted cell range

• Finds the largest number in the inputted cell range

What does the VAR function return?

• Variance of the inputted cell range

• Covariance of the inputted cell range

• Rank of a cell within a specific cell range

• Standard deviation of the inputted cell range

What is the purpose of the COUNTIF function?

• Counts the number of cells based on the logical variable

• Finds the largest number in the inputted cell range

• Finds the average of a cell range

• Returns the standard deviation of the inputted cell range

What does the MEDIAN function do?

• Returns the variance of the inputted cell range

• Outputs the middle number of the cells in the inputted cell range

• Returns the covariance of the inputted cell range

• Finds the smallest number in the inputted cell range

What is the purpose of the STDEV function?

• Outputs the middle number of the cells in the inputted cell range

• Finds the largest number in the inputted cell range

• Finds the average of a cell range

• Returns the standard deviation of the inputted cell range

What does the COVARIANCE function return?

• Variance of the inputted cell range

• Rank of a cell within a specific cell range

• Standard deviation of the inputted cell range

• Covariance of the inputted cell range