GRADE 10-SPREADSHEET FUNCTIONS
Authored by S Nelson
Other
5th - 12th Grade
Used 23+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT a spreadsheet function?
MIN
MAX
COUNT
TOTAL
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which FUNCTION is used to find the largest number in a column?
MIN
MAX
GREATER THAN
SUM
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to know how many items you bought you will need to use this FUNCTION
AVERAGE
MAX
COUNT
SUM
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Refer to your practice spreadsheet. Same one as in this image. What is the correct FUNCTION used to arrive at the answer in B5
=AVERAGE(B2:B4)
=SUM(B2:B9)
=TOTAL(B2:B4)
=SUM(B2:B4)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in C8?
=MIN(B2:C4)
=MIN(D2:C4)
=MIN(C2:C4)
=MAX(B2:B4)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in B9?
=MAX(B2:C4)
=MIN(B2:C4)
=AVERAGE(C2:C4)
=SUM(B2:B4)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Refer to your practice spreadsheet. Same one as in this image. How many items are shown/used for the spreadsheet?
5
3
6
1
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
