Excel Formula Practice: Question Preview (ID: 13157)


Below is a preview of the questions contained within the game titled EXCEL FORMULA PRACTICE: Quiz To Review Writing Formulas .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]


Play games to reveal the correct answers. Click here to play a game and get the answers.

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 the data set above, visit ReviewGameZone.com and enter game ID number: 13157 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register