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
derivatives
B
inputs
C
values
D
arguments
2) to make a cell reference absolute,click on the cell reference IN THE FORMULA BAR and press the ______________ button
A
f3
B
shift
C
f4
D
f5
3) in order to name a group of cells, select the range, click in the ____________ and type the name
A
insert tab
B
name box
C
cell range
D
formula bar
4) when naming a group of cells, you are not allowed to have a space between words
A
false
B
true
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
HLOOKUP
B
VLOOKUP
C
IF
D
PMT
7) the nper argument in a pmt function refers to
A
the number of persons involved in the loan
B
the value of the loan
C
the percentage rate of interest
D
the number of payments
8) the table array argument is part of which function?
A
COUNTIF
B
IF
C
VLOOKUP
D
PMT
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
multiplied by 12
B
divided by 12
C
0
D
10
*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?