Mastering Spreadsheet Functions Quiz

• 11

• 16

• 13

• 10

Which function would you use to find the average of a range of cells in a spreadsheet?

• SUM

• AVERAGE

• MEDIAN

• MODE

How would you apply conditional formatting to highlight cells greater than 100 in a spreadsheet?

• Use the conditional formatting rule "Cell Value > 100"

What is the purpose of the SUM function in spreadsheets?

• To find the average of numbers

• To add up a range of numbers

• To count the number of cells

• To find the maximum value

Which of the following is a basic formula to subtract 10 from 25 in a spreadsheet?

• Finds the minimum value in the range A1 to A10

• Finds the maximum value in the range A1 to A10

• Adds all the values in the range A1 to A10

• Counts the number of cells in the range A1 to A10

How can you format a cell to display numbers as currency in a spreadsheet?

• Apply the currency format from the formatting menu

• Type the currency symbol manually

Which function would you use to count the number of cells that contain numbers in a range?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

• 8

• 5

• 6

• 7

Which function would you use to find the smallest number in a range of cells?

• MAX

• MIN

• SMALL

• LEAST