Skip to content

Function Quiz – Select the Right Function

One of the best ways to familiarize yourself with the functions of a spreadsheet is to use them.

Therefore, this article will show you ten different spreadsheet scenarios and allow you to pick the best function for the job.

Give it your best try and see what happens! You just might learn something new.

Scenario 1

Take a look at the data below.

Which function would you use to calculate the total for all the transactions?

  1. PLUS
  2. SUM
  3. ADD
  4. COMBINE

The Answer

If you selected the SUM function, you are correct.

The SUM function adds together the numbers within referenced cells or ranges. It is the perfect function to use in this scenario.

Scenario 2

Take a look at the data below.

Which function would you use to calculate the arithmetic mean for all the transaction amounts?

  1. MEAN
  2. MEDIAN
  3. AVERAGE
  4. MODE

The Answer

If you selected the AVERAGE function, you are correct.

The AVERAGE function calculates the arithmetic mean of numbers in a spreadsheet.

The arithmetic mean is most often what is meant by the word “average.” However, the word “average” could mean up to three different metrics. Average could potentially refer to the arithmetic mean, the mode, or the median.

Scenario 3

Take a look at the data below.

Which function would you use to count how many categories there are?

  1. COUNTA
  2. COUNT
  3. COUNTIF
  4. ADD

The Answer

If you selected the COUNTA function, you are correct.

The COUNTA function counts the total number of cells within the referenced range that are not empty.

The COUNT function cannot be used in this case because the COUNT function will only count numerical values. The COUNTA function is used instead becuase you are counting cells that contain any value.

Scenario 4

Take a look at the data below.

Which function would you use to count how many times the letter C appears in the list of letters?

  1. COUNT
  2. COUNTA
  3. COUNTIF
  4. COUNTC

The Answer

If you selected the COUNTIF function, you are correct.

The COUNTIF function counts the number of cells that meet a certain condition. In this case, the COUNTIF function is used to count the number of cells containing the letter C.

Scenario 5

Which function would you use to calculate the current date?

  1. NOW
  2. TODAY
  3. CURRENTDATE
  4. CDATE

The Answer

If you selected the TODAY function, you are correct. This function will always return the current date.

Scenario 6

Which function would you use to calculate a random whole number between two pre-determined numbers?

For example, which function would you use to calculate a random number between 1 and 100?

  1. RANDOMIZE
  2. GENERATE
  3. RANDBETWEEN
  4. RANDOMNUM

The Answer

If you selected the RANDBETWEEN function, you are correct. This function will always return a random number between two pre-selected numbers.

Scenario 7

Take a look at the data below.

Which function would you use to look up the price of a banana?

  1. FIND
  2. VLOOKUP
  3. GETVALUE
  4. INDEX

The Answer

If you selected the VLOOKUP function, you are correct.

The VLOOKUP function is used to look up a specific value that relates to another value. In this case, it is used to find the price of a banana based on the data above.

Scenario 8

Which function would you use to round a number to two decimal places?

  1. ROUND
  2. ROUNDIT
  3. TRUNC
  4. SQUARE

The Answer

If you selected the ROUND function, you are correct.

The ROUND function is used to round any number to a specified number of decimal places.

Scenario 9

Provided the year, month (1-12), and day (1-31), which function would you use to calculate and show the date in a cell?

  1. YMDATE
  2. DATE
  3. CALCDATE
  4. YMD

The Answer

If you selected the DATE function, you are correct.

The DATE function calculates the date when provided the year, month, and day value for that date.

Scenario 10

Take a look at the data below.

Which function would you use to return the relative position of the color Green?

  1. FIND
  2. POSITION
  3. PLACE
  4. MATCH

The Answer

If you selected the MATCH function, you are correct.

The MATCH function calculates the relative position of a value within a set of values. In this case, “Green” is the third color in the list. Therefore, the MATCH function returns a value of 3.

And that brings the function quiz to a close! We hope you had fun and learned something new while working through the function quiz.

This Post Has 7 Comments

  1. 10/10 Baby!!!! Let’s go!!

    Question 10 almost stumped me, but I’ve been keeping up with my Spreadsheet Life blog post reading, so I got it in the bag!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top