Spreadsheet Functions
Authored by Natasha Ramsaroop
Computers
3rd - 5th Grade
Used 174+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
All functions and formulas begin with which symbol?
#
/
:
=
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which are the three essential elements to enter a function?
Equal sign, function name and cell reference.
Equal sign, cell reference and formula.
Function name, data and cell reference.
Function name and cell reference.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"
Count
Count A
If
Sum
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of
=C4 + C5
32
12
17
15
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What two operations does the AVERAGE function perform?
Addition and Multiplication
Multiplication and Division
Addition and Subtraction
Addition and Division
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
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?
