Flash Cards (current)
Games
Teachers

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,

AD9 BE9 CEmpty DD9/E9

2) The function = MAX(E3:E15) in cell C17 will display

Alargest value in the cells between and including E3 and E15 Bfirst value in the range Clast value in the range Dlargest value in the cells between E3 and E15

3) Using the FV function, Excel refers to the fixed payment at equal intervals as a(n)

Aannuity Bfixed payment Cloan payment Dlump sum

4) If you entered =IF(D9

A16 B4 C0 D12

5) Which of the following arguments must be expressed as a negative to create a postive payment amount in the PMT function?

APV BNper CRate DFV

6) What does Nper stand for?

ANumber of periods BNumber percent CNumber of persons DNo percent

7) The If function would NOT be used to determine

Astudent\'s grades Bif goals were met Cemployee bonus Dpayment for a loan if you borrowed a specific amount

8) How many IF functions can be nested in one IF statement?

ANone B7 C5 D13

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.

AFalse BSometimes CTrue

10) You would use one of the COUNT functions to sum selected cells within a specific range.

ASometimes BTrue CFalse

*select an answer for all questions

Play Games with the Questions Above

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?