Excel Ch. 2 Question Preview (ID: 13017)


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

once you click to insert a function, a dialog box will pop up where you input the function ___________
a) arguments
b) inputs
c) values
d) derivatives

to make a cell reference absolute,click on the cell reference IN THE FORMULA BAR and press the ______________ button
a) f4
b) f3
c) f5
d) shift

in order to name a group of cells, select the range, click in the ____________ and type the name
a) name box
b) formula bar
c) insert tab
d) cell range

when naming a group of cells, you are not allowed to have a space between words
a) true
b) false
c)
d)

it is possible to input values from one worksheet into another worksheet
a) true
b) false
c)
d)

this logical function returns one value if a condition is true and another value if the condition is false
a) IF
b) PMT
c) VLOOKUP
d) HLOOKUP

the nper argument in a pmt function refers to
a) the number of payments
b) the percentage rate of interest
c) the value of the loan
d) the number of persons involved in the loan

the table array argument is part of which function?
a) VLOOKUP
b) PMT
c) IF
d) COUNTIF

you do not have to use the fx button or formula tab to insert a function
a) true
b) false
c)
d)

the fv argument in the pmt function will always (for our purposes) be ___
a) 0
b) 10
c) divided by 12
d) multiplied by 12

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

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links