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