Search Header Logo
Google Sheets Min and Max Functions Quiz

Google Sheets Min and Max Functions Quiz

Assessment

Interactive Video

Computers

6th - 8th Grade

Practice Problem

Hard

Created by

Jennifer Brown

FREE Resource

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

£1,368

£2,500

£10,465

£5,000

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

75%

21%

50%

97.61%

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Similar Resources on Wayground