Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Formula Practice
Test Description: Quiz to review writing formulas
Instructions: Answer all questions to get your test result.
1) Write a formula that ADDS the following cells together: B2, B3, B4, B5, and B6
A
=SUM(B2:B6)
B
Both formulas will work
C
Neither formula will work
D
=(B2+B3+B4+B5+B6)
2) Write a formula to find the DIFFERENCE between 7 and 2
A
Both formulas will work
B
7-2=
C
=(7-2)
D
Neither formula will work
3) Which AutoSum function will tell you the LARGEST number out of the selected cells?
A
MAX
B
SUM
C
AVERAGE
D
MIN
4) Which AutoSum function will tell you the SMALLEST number out of the selected cells?
A
AVERAGE
B
MIN
C
MAX
D
SUM
5) Which AutoSum function will ADD all of the selected cells together?
A
AVERAGE
B
SUM
C
MIN
D
MAX
6) Which AutoSum function will ADD all of the selected cells together and DIVIDE the total by the number to cells selected?
A
AVERAGE
B
SUM
C
MIN
D
MAX
7) Which formula finds the SMALLEST number out of the range of cells B2:D7?
A
=MIN(B2:D7)
B
MIN(B2:D7)=
C
There is no formula that will do this
D
=LOWEST(B2:D7)
8) A formula always starts with a(an) _____________
A
Parenthesis
B
Number
C
Capital Letter
D
Equal Sign
9) Whis symbol is used to MULTIPLY?
A
x
B
*
C
.
D
&
10) Whis symbol is used to MULTIPLY?
A
$
B
/
C
*
D
%
*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?