# Spreadsheets - Formulas And Functions: Question Preview (ID: 16690)

### Below is a preview of the questions contained within the game titled SPREADSHEETS - FORMULAS AND FUNCTIONS: Formulas And Functions .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.**

What is the symbol that represents addition in a spreadsheet? |
||||

a) + | b) / | c) - | d) * | |

What is the symbol that represents multiplication in a spreadsheet? |
||||

a) + | b) / | c) - | d) * | |

A spreadsheet function that counts the number of cells in a range that contains data is called? |
||||

a) SUM | b) COUNT | c) AVERAGE | d) MAX | |

A spreadsheet function that indicates the average of a group of numbers in a range is called? |
||||

a) MIN | b) MAX | c) SUM | d) AVERAGE | |

A spreadsheet function used to add numbers in a range is called? |
||||

a) MIN | b) MAX | c) SUM | d) AVERAGE | |

A spreadsheet function that indicates the highest value in a range is called? |
||||

a) MIN | b) MAX | c) COUNT | d) SUM | |

A spreadsheet function that indicates the lowest value in a range is called? |
||||

a) MIN | b) MAX | c) COUNT | d) AVERAGE | |

When keying a formula, what must you key to inform the program that you are entering a formula instead of text? |
||||

a) divison operator | b) subtraction operator | c) Equal sign | d) Addition operator | |

What is a function? |
||||

a) Alphabetical data | b) Numerical data | c) Shortcut formula for common calculations | d) The automatic recalculation of cells | |

What is a formula? |
||||

a) Statement that performs a calculation | b) Alphabetical data | c) Numerical data | d) a group of cells | |

What is the symbol that represents division in a spreadsheet? |
||||

a) + | b) / | c) - | d) * | |

What is the symbol that represents subtraction in a spreadsheet? |
||||

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: 16690 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: 16690 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