Spreadsheet Functions
Authored by S Nelson
Computers
6th - 12th Grade
Used 58+ 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
SUM, AVERAGE and COUNT are all known as spreadsheet:
formula
data
functions
graphs
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A spreadsheet is used for
creating drawings
typing letters and resumes
calculating data
creating tables but not for calculations
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of a range?
D3
D3 and D5
D3:D18
Sum
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Use the spreadsheet you created, see sample in image. Which function calculates the total for score 1?
=Total(B2:B4)
=Sum(B2:B4)
=Sum(C2:C4)
=Total(C2:C4)
5.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
Use the spreadsheet you created, see sample in image. Type the CORRECT function that calculates the average for score 1?
(a)
6.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the answer in cell C7?
(a)
7.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the average for score 2? Rounded to 2 decimal places.
(a)
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
