Excel Quiz 2 Question Preview (ID: 3080)
Questions Are About Formulas And Functions.
TEACHERS: click here for quick copy question ID numbers.
A formula cannot contain any spaces.
a) True
b) False
c)
d)
When you use the AutoSum feature, the computer automatically tries to guess what numbers to add.
a) True
b) False
c)
d)
All formulas begin with a(an)
a) colon
b) word
c) parenthesis
d) equal sign
A function used to find the highest number in a range.
a) Sum
b) Maximum
c) Minimum
d) Average
A function that adds a range of numbers and divides by the quantity of numbers in the range.
a) Sum
b) Maximum
c) Minimum
d) Average
A function that is used to add all numbers in a range.
a) Sum
b) Maximum
c) Minimum
d) Average
A function used to find the lowest number in a range.
a) Sum
b) Maximum
c) Minimum
d) Average
In a formula, the symbol to multiply is
a) x
b) /
c) *
d) #
In a formula, the symbol to divide is
a) /
b) %
c) *
d) ^
If you use the sum function, what happens to the totals when you change numbers in a worksheet?
a) Totals stay the same
b) Totals change automatically to reflect the new numbers
c) Totals are erased
d) Totals must be updated with a new formula
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: 3080 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 3080 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register