Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Project 5 A
Test Description: Working with Functions
Instructions: Answer all questions to get your test result.
1) If you entered =IF(D9/E9,D9,
A
E9
B
Empty
C
D9
D
D9/E9
2) The function = MAX(E3:E15) in cell C17 will display
A
largest value in the cells between E3 and E15
B
first value in the range
C
largest value in the cells between and including E3 and E15
D
last value in the range
3) Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)
A
annuity
B
fixed payment
C
loan payment
D
lump sum
4) If you entered =IF(D9
A
4
B
0
C
12
D
16
5) Which of the following arguments must be expressed as a negative to create a postive payment amount in the PMT function?
A
Rate
B
PV
C
Nper
D
FV
6) What does Nper stand for?
A
Number percent
B
Number of persons
C
Number of periods
D
No percent
7) The If function would NOT be used to determine
A
if goals were met
B
payment for a loan if you borrowed a specific amount
C
student\'s grades
D
employee bonus
8) How many IF functions can be nested in one IF statement?
A
7
B
None
C
5
D
13
9) The FV function calculates the future value of an investment based on fixed payments earning a variable rate of interest across equal time periods.
A
True
B
False
C
Sometimes
10) You would use one of the COUNT functions to sum selected cells within a specific range.
A
True
B
Sometimes
C
False
*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?