Spreadsheet Formulas/Functions
Authored by Bo Riddick
Computers
6th - 8th Grade
Used 9+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
LABELLING QUESTION
1 min • 1 pt
What is the formula you would use in cell D2 to find the total cost per item?
=B1+C1
=B1/C1
=B1*C1
=B1-C1
2.
LABELLING QUESTION
1 min • 1 pt
What is the formula or function you would use to get the subtotal?
=D2+D10
=D2+D3+D4+D5+D6+D7+D8+D9+D10
=sum(D2:D10)
=(D2:D10)
3.
LABELLING QUESTION
1 min • 1 pt
How would you calculate the tax in cell D13 ($55.50)
=D12-.06
=D12/.06
=D12*.06
=D12+.06
4.
LABELLING QUESTION
1 min • 1 pt
How would you find the total cell D14?
=D12-D13
=D12/D13
=D12*D13
=D12+D13
5.
LABELLING QUESTION
1 min • 1 pt
How would you find the remaining balance from your budget of $1,000?
=D12-1000
=D13-1000
=D14-1000
6.
LABELLING QUESTION
1 min • 1 pt
What formula would you use the get the total cost (D4)?
=B4-C4
=B4*C4
=B4+C4
Copy the formula from cell D2 down
7.
LABELLING QUESTION
1 min • 1 pt
What label is in cell B1
Item
Quanity
Total Cost
Price per item
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?
