Excel Functions Quiz for Grade 9

What does the SUM function do in Excel?

• Multiplies numbers in a range of cells

• Subtracts numbers in a range of cells

• Divides numbers in a range of cells

• Adds up all the numbers in a range of cells.

Which option in Excel allows you to change the background color of a cell?

• Text Color option in the 'View' tab
• Border Color option in the 'Format' tab
• Font Color option in the 'Insert' tab
• Fill Color option in the 'Home' tab

What does the COUNT function count in Excel?

• text in cells

• colors in a range

• formulas in a worksheet

• numbers in a range

Explain the AVERAGE function in Excel.

• The AVERAGE function in Excel multiplies a range of numbers.

• The AVERAGE function in Excel finds the highest number in a range.

• The AVERAGE function in Excel calculates the average of a range of numbers.

• The AVERAGE function in Excel calculates the sum of a range of numbers.

When is the ROUND function used in Excel?

• The ROUND function is used in Excel to merge cells.

• The ROUND function is used in Excel to round numbers.

• The ROUND function is used in Excel to sort data.

• The ROUND function is used in Excel to calculate averages.

What does the RANK function do in Excel?

• The RANK function in Excel calculates the average of a range of numbers

• The RANK function in Excel assigns a rank to a specified number within a list of numbers.

• The RANK function in Excel returns the maximum value in a list of numbers

• The RANK function in Excel sorts the numbers in ascending order

Describe the PRODUCT function in Excel.

• The PRODUCT function in Excel divides all the numbers given as arguments.

• The PRODUCT function in Excel multiplies all the numbers given as arguments.

• The PRODUCT function in Excel subtracts all the numbers given as arguments.

• The PRODUCT function in Excel adds all the numbers given as arguments.

What does the MAX function find in Excel?

• largest value in a range of cells

• smallest value in a range of cells

• average value in a range of cells

• sum of values in a range of cells

Explain the MIN function in Excel.

• The MIN function in Excel calculates the average value

• The MIN function in Excel returns the maximum value

• The MIN function in Excel counts the number of cells with values

• The MIN function in Excel returns the minimum value from a set of values.

When is the COUNTA function used in Excel?

• When you want to count all cells with formulas in a range.

• When you want to count only even numbers in a range.

• When you want to count all cells with conditional formatting in a range.

• When you want to count all non-empty cells in a range.