Google Sheets Min and Max Functions Quiz

What is the purpose of using the MIN function in Google Sheets?

• To find the average value in a range

• To find the maximum value in a range

• To find the minimum value in a range

• To find the sum of values in a range

In the first example, what was the minimum profit value found?

• £1,368

• £2,500

• £10,465

• £5,000

How do you find the maximum value in a column using Google Sheets?

• Type =MIN and select the range

• Type =SUM and select the range

• Type =AVERAGE and select the range

• Type =MAX and select the range

What was the maximum test score found in the second example?

• 75%

• 21%

• 50%

• 97.61%

What should you do after finding the minimum or maximum value in a range?

• Click on the cell

• Press the spacebar

• Type a new formula

• Close the bracket and press Enter