Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Ch. 2
Test Description: Sunrise christian academy
Instructions: Answer all questions to get your test result.
1) once you click to insert a function, a dialog box will pop up where you input the function ___________
A
values
B
inputs
C
arguments
D
derivatives
2) to make a cell reference absolute,click on the cell reference IN THE FORMULA BAR and press the ______________ button
A
f3
B
f5
C
shift
D
f4
3) in order to name a group of cells, select the range, click in the ____________ and type the name
A
formula bar
B
insert tab
C
cell range
D
name box
4) when naming a group of cells, you are not allowed to have a space between words
A
true
B
false
5) it is possible to input values from one worksheet into another worksheet
A
true
B
false
6) this logical function returns one value if a condition is true and another value if the condition is false
A
PMT
B
HLOOKUP
C
IF
D
VLOOKUP
7) the nper argument in a pmt function refers to
A
the percentage rate of interest
B
the number of persons involved in the loan
C
the number of payments
D
the value of the loan
8) the table array argument is part of which function?
A
IF
B
COUNTIF
C
PMT
D
VLOOKUP
9) you do not have to use the fx button or formula tab to insert a function
A
true
B
false
10) the fv argument in the pmt function will always (for our purposes) be ___
A
0
B
10
C
multiplied by 12
D
divided by 12
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?