Deck 17: Specialized Functions: Hands On Exercise Videos

Question 1

Entering an IF in the Value_if_true box or in the Value_if_false box,creates a(n)________ function.

A)embedded
B)complex
C)compound
D)nested

Answer 1

D

Question 2

Which of the following is NOT a database function?

A)DAVERAGE
B)DMAX
C)DCOUNT
D)DEFREQUENCY

Answer 2

D

Question 3

Which of the following functions would NOT be used to construct an amortization table?

A)PPMT
B)IPMT
C)PV
D)CUMPRINC

Answer 3

C

Question 4

You would use the ________ function to return the position of a value in a list.

A)AND
B)IF
C)MATCH
D)INDEX

Question 5

Knowing the interest rate,number of payments,and the monthly payments,you would use the ________ function to determine the amount of a loan.

A)FV
B)PV
C)IPMT
D)PPMT

Question 6

IF and AND are examples of ________ functions.

A)logical
B)database
C)financial
D)statistical

Question 7

MATCH and INDEX are logical functions.

Question 8

A loan amortization table is a schedule that shows the interest,principal repayment,and remaining balance.

Question 9

When a loan is repaid,the total principal matches the ________ for the final payment.

A)future value
B)present value
C)total interest
D)cumulative principal

Question 10

DMIN is a database function.

Question 11

When constructing an advanced filter,the ________ range is a range of cells containing the filter conditions.

A)specification
B)criteria
C)output
D)input

Question 12

=IF(AND(D7="manager",F7

Question 13

CUMIPMT and CUMPRINC are lookup functions.

Question 14

The criteria range is a range of cells that specifies the conditions used to filter a table.

Question 15

Which of the following is NOT a financial function?

A)DSUM
B)CUMIPMT
C)PV
D)IPMT

Question 16

The ________ function results in a TRUE value only if all conditions are true.

A)OR
B)AND
C)NOT
D)NOR