Exel Formulas
Authored by Joshua Coleman
Computers
6th - 8th Grade
Used 125+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula needs to be inserted into cell B6?
=TOTAL(B1:B5)
=(B1:B5)TOTAL
=SUM(B1:B5)
=(B1:B5)SUM
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula has been entered into cell D10?
=2*£0.25
=D10*C10
=B10*C10
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D6?
=4*£1.00
C6+B6
=D6*B6
=B6*C6
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D2?
=D2*C2
=B2*C2
=10*£0.25
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D11?
SUM(D10 to D2)=
=SUM(D2,D10)
=(D2:D10)SUM
=SUM(D2:10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the cell range for A?
B2 to B6
A4:A5
A4,A5
A4 to A5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the cell range for B?
B2,B6
A4:A5
A8, D8
B2: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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
