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


Formulas And Functions. TEACHERS: click here for quick copy question ID numbers.

What is a formula?
a) Statement that performs a calculation
b) Alphabetical data
c) Numerical data
d) a group of cells

What is a function?
a) Alphabetical data
b) Numerical data
c) Shortcut formula for common calculations
d) The automatic recalculation of cells

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

A spreadsheet function that indicates the lowest value in a range is called?
a) MIN
b) MAX
c) COUNT
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 used to add numbers in a range is called?
a) MIN
b) MAX
c) SUM
d) AVERAGE

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 that counts the number of cells in a range that contains data is called?
a) SUM
b) COUNT
c) AVERAGE
d) MAX

What is the symbol that represents multiplication in a spreadsheet?
a) +
b) /
c) -
d) *

What is the symbol that represents addition in a spreadsheet?
a) +
b) /
c) -
d) *

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 above, visit ReviewGameZone.com and enter game ID number: 16690 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links