Spreadsheet Formulas and Functions
Authored by Jonathan Canton
Computers
9th - 12th Grade
Used 39+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
sum
=SUM(B2:B12)
=A2*A3
add all the numbers in a range of cells
=SUM(B8:B20)*SUM(C28:C40)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
average
=AVERAGE(A2:Q2)
=B8-N9
=MIN(B1:G10)
return the average of its arguments
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
max
=MIN(B1:G10)
=SUM(C1:W1)
=SUM(B8:B20)*SUM(C28:C40)
return the largest value in a set of values
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
min
=MAX(B1:B31)
=B2/SUM(B10:B21)
return the largest value in a set of values
return the smallest value in a set of values
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
count
=SUM(C1:W1)
=B8-N9
=A6*SUM(C1:G10)/A2
count the number of cells in a range that contains numbers
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
vlookup
add all the numbers in a range of cells
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
=SUM(A1:C10)-B8
=B8-N9
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Formula: Add a range of numbers in cells B2:B12
=SUM(C1:W1)
=B8-N9
return the smallest value in a set of values
=SUM(B2:B12)
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?
