Excel Ch. 2: Question Preview (ID: 13017)


Below is a preview of the questions contained within the game titled EXCEL CH. 2: Sunrise Christian Academy .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]


Play games to reveal the correct answers. Click here to play a game and get the answers.

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 the data set above, visit ReviewGameZone.com and enter game ID number: 13017 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register