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.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register