Have an account?
Skip to Content
Build your own quiz
.png)
24 questions
Show Answers
See Preview
- 1. Multiple Choice
Which of the following is the proper format for a range?
A1-D10
A1:D10
A1thruD10
A1&D10
- 2. Multiple Choice
Which of the following is the selection pointer?
- 3. Multiple Choice
Which of the following is the fill handle?
- 4. Multiple Choice
Which of the following is the move handle?
- 5. Multiple Choice
Use the fill handle to create a natural series, such as the months of the year.
TRUE
FALSE
- 6. Multiple Choice
The formula bar is found at the bottom of the Excel window.
TRUE
FALSE
- 7. Multiple Choice
Which of the following is not an arithmetic operator?
+
-
*
]
- 8. Multiple Choice
Per the order of operations, what is the answer to this formula: =2*(2+2)?
6
8
4
2
- 9. Multiple Choice
Per the order of operations, what is the answer to this formula: =2*2+2?
6
8
4
2
- 10. Multiple Choice
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
TRUE
FALSE
- 11. Multiple Choice
It is always best to use the exact value instead of the cell reference when using formulas.
TRUE
FALSE
- 12. Multiple Choice
The order of operations determines which parts of a formula are calculated before other parts of the formula.
TRUE
FALSE
- 13. Multiple Choice
The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).
TRUE
FALSE
- 14. Multiple Choice
Which function calculates the TOTAL (adds all the cells in the range together)?
SUM
AVERAGE
MAX
MIN
- 15. Multiple Choice
Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?
MIN
AVERAGE
COUNT
MAX
- 16. Multiple Choice
Which function returns the highest value in a range?
SUM
AVERAGE
MAX
MIN
- 17. Multiple Choice
Which function returns the lowest value in a range?
SUM
AVERAGE
MAX
MIN
- 18. Multiple Choice
Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?
=SUM(B1:B7)
=COUNT(B1:B7)
=AVERAGE(B1:B7)
=MAX(B1:B7)
- 19. Multiple Choice
Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?
=SUM(B1:B4)/4
=COUNT(B1:B4)/4
=AVERAGE(B1:B4)/4
=MAX(B1:B4)/4
- 20. Multiple Choice
Which function was used in E2?
=COUNT(B1:B9)
=COUNTA(B1:B9)
=COUNTBLANK(B1:B9)
- 21. Multiple Choice
Which function was used in E4?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
- 22. Multiple Choice
Which function was used in E5?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
- 23. Multiple Choice
Which function was used in E6?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
- 24. Multiple Choice
Which function was used in E7?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
- Answer choicesTagsAnswer choicesTags