Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Quiz 2
Test Description: Questions are about formulas and functions.
Instructions: Answer all questions to get your test result.
1) A formula cannot contain any spaces.
A
False
B
True
2) When you use the AutoSum feature, the computer automatically tries to guess what numbers to add.
A
True
B
False
3) All formulas begin with a(an)
A
word
B
parenthesis
C
colon
D
equal sign
4) A function used to find the highest number in a range.
A
Sum
B
Maximum
C
Minimum
D
Average
5) A function that adds a range of numbers and divides by the quantity of numbers in the range.
A
Minimum
B
Sum
C
Maximum
D
Average
6) A function that is used to add all numbers in a range.
A
Average
B
Maximum
C
Sum
D
Minimum
7) A function used to find the lowest number in a range.
A
Minimum
B
Maximum
C
Sum
D
Average
8) In a formula, the symbol to multiply is
A
x
B
#
C
/
D
*
9) In a formula, the symbol to divide is
A
%
B
^
C
/
D
*
10) If you use the sum function, what happens to the totals when you change numbers in a worksheet?
A
Totals change automatically to reflect the new numbers
B
Totals are erased
C
Totals must be updated with a new formula
D
Totals stay the same
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?