Excel Formula Practice Question Preview (ID: 13157)
Quiz To Review Writing Formulas.
TEACHERS: click here for quick copy question ID numbers.
Write a formula that ADDS the following cells together: B2, B3, B4, B5, and B6
a) =(B2+B3+B4+B5+B6)
b) Neither formula will work
c) Both formulas will work
d) =SUM(B2:B6)
Write a formula to find the DIFFERENCE between 7 and 2
a) =(7-2)
b) Neither formula will work
c) Both formulas will work
d) 7-2=
Which AutoSum function will tell you the LARGEST number out of the selected cells?
a) MIN
b) AVERAGE
c) SUM
d) MAX
Which AutoSum function will tell you the SMALLEST number out of the selected cells?
a) MIN
b) AVERAGE
c) SUM
d) MAX
Which AutoSum function will ADD all of the selected cells together?
a) MIN
b) AVERAGE
c) SUM
d) MAX
Which AutoSum function will ADD all of the selected cells together and DIVIDE the total by the number to cells selected?
a) MIN
b) AVERAGE
c) SUM
d) MAX
Which formula finds the SMALLEST number out of the range of cells B2:D7?
a) There is no formula that will do this
b) MIN(B2:D7)=
c) =LOWEST(B2:D7)
d) =MIN(B2:D7)
A formula always starts with a(an) _____________
a) Number
b) Parenthesis
c) Capital Letter
d) Equal Sign
Whis symbol is used to MULTIPLY?
a) &
b) *
c) x
d) .
Whis symbol is used to MULTIPLY?
a) $
b) %
c) *
d) /
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 13157 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 13157 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register