Functions, Sort & Filter
Authored by Marie Vaux
Information Technology (IT)
6th Grade
Used 2+ times
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
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
