Try It

Task and Function Matching

Match the task with the correct function.

Task:

  1. Find the largest number in cells A3 through D5.
  2. Find out how many numbers are in the cells A3 through D5.
  3. Find the total of numbers in cells A3 through D5.
  4. Find the smallest number in cells A3 through D5.
  5. Find the average of the numbers in A3 through D5.

Function:

  • =COUNT(A3:D5)
  • =MIN(A3:D5)
  • =MAX(A3:D5)
  • =AVERAGE(A3:D5)
  • =SUM(A3:D5)

Answers:

  1. Find the largest number in cells A3 through D5.

    Answer: =MAX(A3:D5)

  2. Find out how many numbers are in the cells A3 through D5.

    Answer: =COUNT(A3:D5)

  3. Find the total of numbers in cells A3 through D5.

    Answer: =SUM(A3:D5)

  4. Find the smallest number in cells A3 through D5.

    Answer: =MIN(A3:D5)

  5. Find the average of the numbers in A3 through D5.

    Answer: =AVERAGE(A3:D5)

You've completed this review activity!