Excel Ch. 2 Question Preview (ID: 13015)


Sunrise Christian Academy. TEACHERS: click here for quick copy question ID numbers.

formulas always begin with a(n)
a) =
b) )
c) (
d) *

the fx button...
a) inserts functions
b) shows the formula in the selected cell
c) is another name for the autosum button
d) clears formatting

which tab can you not use to insert a function?
a) insert
b)
c) formulas
d) home

which is not an autosum function?
a) pmt
b) count numbers
c) min
d) max

there is more than one way to insert a function
a) true
b)
c)
d) false

this is a valid function.... =average a1:b2)
a) false
b)
c)
d) true

you can simply click on a cell to insert the cell reference into a function
a) true
b)
c)
d) false

the __________ function counts the number of cells that contain words or letters
a) counta
b)
c) countif
d) count

the __________ function counts the number of cells that contain text or numbers that YOU specify
a) countif
b)
c) count
d) counta

a(n) ____________ cell reference will change when you drag down the autofill handle
a) relative
b)
c)
d) absolute

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: 13015 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register