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...

    Content View

    Student View

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

Already have an account?