# 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.

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

Log In | Sign Up / Register