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.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register