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]

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

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