Have an account?
Skip to Content
Build your own quiz
20 questions
Show Answers
See Preview
- 1. Multiple Choice
Define the following operator: +
Addition
Subtraction
Multiplication
Division
- 2. Multiple Choice
Define the following operator: -
Addition
Subtraction
Multiplication
Division
- 3. Multiple Choice
Define the following operator: /
Addition
Subtraction
Multiplication
Division
- 4. Multiple Choice
Define the following operator: *
Addition
Subtraction
Multiplication
Division
- 5. Multiple Choice
A symbol used to tell the formula what type of calculation should be done is a(n)
operand
operator
function
formula
- 6. Multiple Choice
The values or data used in the formula are called
operators
operands
functions
formulas
- 7. Multiple Choice
Which of the following formulas is a complex formula?
=3*2*5
=20*(2*5)
=10*6-2
=C4/C5
- 8. Multiple Choice
This is a way to point to a cell location on the spreadsheet
simple formula
complex formula
cell reference
format painter
- 9. Multiple Choice
Which of the following is a valid formula?
=F15
=C3-C4
(D5*F5)
F2/F3
- 10. Multiple Choice
Which of the following is a simple formula?
=G11/20+2
=D3+40-F3
=10+B1*C1
=50-(C3-D13)
- 11. Multiple Choice
Using the correct order of operations, what does this formula equal? =10/(10-5)*6
.3333
12
-24
.83
- 12. Multiple Choice
In this formula, which calculation would be performed first? =4*5-(10+54)
4 * 5
10 + 54
5-(10+54)
It is unknown
- 13. Multiple Choice
What is the best formula for finding the total value for cells F17 through F22?
=F17+F18+F19+F20+F21+F22
=SUM(F17:F22)
=(F17:F22)
SUM(F17:F22)
- 14. Multiple Choice
Which one is the Formula Bar?
A
B
C
D
- 15. Multiple Choice
Which formula contains a cell reference?
=567+89
=H34
=D5/2
=65-34
- 16. Multiple Choice
What is the argument in this formula? =AVERAGE(C13:F11)
AVERAGE
(C13:F11)
C13
F11
- 17. Multiple Choice
Which formula would you enter to return the number 45.1?
=MAX(A2:B5)
=SUM(A2:B5)
=MIN(A2:B5)
=AVERAGE(A2:B5)
- 18. Multiple Choice
Clicking on a cell will show its contents in the Formula Bar.
True
False
- 19. Multiple Choice
When using a cell reference, you no longer have to update a formula when the value in a cell changes.
True
False
- 20. Multiple Choice
Cell A1 contains the formula "=10+D2". If you copied A1 to B3, what would be the formula in B3?
=10+E4
=10+E3
=10+B4
=10+B3
- Answer choicesTagsAnswer choicesTags