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
D9/E9
B
E9
C
Empty
D
D9
2) The function = MAX(E3:E15) in cell C17 will display
A
largest value in the cells between E3 and E15
B
last value in the range
C
first value in the range
D
largest value in the cells between and including E3 and E15
3) Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)
A
loan payment
B
fixed payment
C
annuity
D
lump sum
4) If you entered =IF(D9
A
16
B
12
C
0
D
4
5) Which of the following arguments must be expressed as a negative to create a postive payment amount in the PMT function?
A
PV
B
Nper
C
Rate
D
FV
6) What does Nper stand for?
A
Number of persons
B
No percent
C
Number percent
D
Number of periods
7) The If function would NOT be used to determine
A
payment for a loan if you borrowed a specific amount
B
if goals were met
C
student\'s grades
D
employee bonus
8) How many IF functions can be nested in one IF statement?
A
7
B
None
C
13
D
5
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
False
B
True
C
Sometimes
10) You would use one of the COUNT functions to sum selected cells within a specific range.
A
False
B
Sometimes
C
True
*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?