Search Header Logo

Functions, Sort & Filter

Authored by Marie Vaux

Information Technology (IT)

6th Grade

Used 2+ times

Functions, Sort & Filter
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function helps you find the largest value in the cell range

MAX

MIN

SUM

AVERAGE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function helps you find the middle value in the cell range

MAX

MIN

SUM

AVERAGE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function helps you find the total value in the cell range

MAX

MIN

SUM

AVERAGE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function helps you find the smallest value in the cell range

MAX

MIN

SUM

AVERAGE

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This functions allows you to organise the data in ascending or descending order.

Sort

Spreadsheeet

Worksheet

filter

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This functions allows you to hide and refine results to display data that matches criteria.

Sort

Spreadsheeet

Worksheet

Filter

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?