Speadsheet Formulas/Functions Review
Authored by Bo Riddick
Computers
6th - 8th Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
DROPDOWN QUESTION
1 min • 2 pts
What is the formula for multiplying two cells?
=A1*B1
A1*B1
=A1+B1
=A1/B1
=A1-B1
2.
MATCH QUESTION
1 min • 1 pt
Match the following formulas with the correct definition
=A1/B1
Add
=A1-B1
Multiply
=A1*B1
Subtract
=A1+B1
Divide
3.
MATCH QUESTION
1 min • 5 pts
Match the following functions with the correct definition
The sum of all the numbers in a set
Mean
The middle number in a set of numbers
Sum
The average of a set of numbers
Median
The difference between the largest and smallest number in a set
Mode
The number that appears most frequently in a set
Range
4.
MATCH QUESTION
1 min • 5 pts
Match the following functions with the correct formulas
=A2-A5
sum
=sum(A1:A5)
Mean
=mode(A1:A5)
Mode
=med(A1:A5)
Range
=avg(A1:A5)
Median
5.
DROPDOWN QUESTION
1 min • 2 pts
What are two spreadsheet programs? (a) (b)
Microsoft Excel
Google Sheets
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?
