SpreadSheet
Authored by Inspiros Online
Computers
10th Grade
Used 11+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
50 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is a formula that will multiply cells A1 and A2?
A1*A2
=A1:A2
=A1*A2
=Multiply(A1:A2)
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is a formula that will divide cell D10 by 2?
=D10/A2
10/2
=D10*2
=D10/2
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is a formula that will subtract cell B4 from cell B3?
=3-4
=B3-B4
=B3*B4
B3-B4
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is a correct example using the AUTOSUM function?
sum(D14:D19)
=D14:d19
=sum(D14:D19)
=D14+D15+D16+D17+D18+D19
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is a correct example using the AUTOSUM function?
=Sum(A1-A10)
=Sum(A1:A10)
=A1+A2+A3+...+A10
=Sum(A1+A2+A3+...+A10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the picture, why is D2 through D5 placed in paranthesis?
So Excel knows to total the cells before performing the next operation.
So the total of the cells can be multiplied rather than added.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If the parenthesis is removed, what will 9.5% be multiplied by?
D2 +D3+D4+D5
D5
D2
None
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?
