Question 1

The DCOUNTA function returns an error if it encounters a blank record.

Accepted Answer

The DCOUNTA function counts non-blank cells based on the given criteria and ignores empty cells. It does not return an error if it encounters a blank record.

Question 2

The RATE function returns the periodic rate for an investment or loan.

Accepted Answer

The RATE function in Excel indeed returns the periodic rate for an investment or loan.

Question 3

A loan amortization table is a schedule that calculates the interest per payment period, principal repayment for each payment, and remaining balance after each payment is made.

Accepted Answer

A loan amortization table is designed to break down each payment period, typically monthly, and calculate the amount of interest and principal included in each payment. It also shows how much of the loan's balance remains after each payment is made. This helps borrowers understand how much of their payment is going towards interest and how much is actually reducing the balance of the loan.

Question 4

NPER calculates the periodic interest rate of an investment or loan.

Accepted Answer

NPER calculates the number of payment periods for an investment or loan, not the periodic interest rate.

Question 5

Database functions do not require a Criteria Range.

Accepted Answer

Database functions in Excel, such as DSUM, DAVERAGE, etc., often require a Criteria Range to specify the conditions that control which data in the database should be included in the calculation.

Question 6

This is a correct example of the structure of an IPMT function.=IPMT(rate,per,nper,pv,[fv],[type])

Accepted Answer

The given structure is correct for the IPMT function.

Question 7

The PPMT function calculates the monthly principal and interest payment of a loan or investment.

Accepted Answer

The PPMT function calculates the principal part of a loan payment for a given period, not the interest part or the total monthly payment.

Question 8

The NPV function is used mostly to calculate return rates for IRAs.

Accepted Answer

The NPV function is a financial function used to calculate the net present value of a series of cash flows. While it can be used in various financial calculations, it is not specific to IRAs or any particular type of investment.

Question 9

DSTDEV calculates the standard deviation of a sample population in a database range.

Accepted Answer

DSTDEV is a function in Excel that calculates the standard deviation of a sample population within a given range. It is specifically designed to be used with a sample population, not an entire population.

Question 10

The database argument of a database function must include the entire range of the database.

Accepted Answer

The database argument in a database function must include the entire range of the database to ensure that all relevant data is considered for the function's operation.

Question 11

Match between columns
                        Premises: Amortization Table
CUMPRINC
CUMIPMT
IPMT
PPMT

Accepted Answer

The Answer of Periodic interest at a point in time is...

Question 12

Match between columns
                        Premises: NPER
FV
RATE
NPV
PV

Accepted Answer

The Answer of Calculates the periodic rate for an investment is...

Question 13

Match between columns
                        Premises: Lookup value
Position
Column_num
Row_num
Array

Accepted Answer

The Answer of The first argument in the match function, is...

Question 14

Match between columns
                        Premises: in D4 =IF(OR(B4="Blue",B4="Red"),A4,"else")
in D2 =IF(OR(B2="Blue",B2="Red"),A2,"else")
in D3 =IF(AND(B2="Blue",(NOT(B3="Green"),A2,"else")
in D4=IF(NOT(B4="Blue"),A3,A4
in D3=IF(AND(B3="Blue",B3="Red"),A3,A4)

Accepted Answer

The Answer of Flower and Else and An error and is...

Question 15

Match between columns
                        Premises: AND
Nested Function
IF
NOT
OR

Accepted Answer

The Answer of At least one condition must be met is...

Question 16

Match between columns
                        Premises: DAY
YEARFRAC
DAYS
YEAR
MONTH

Accepted Answer

The Answer of Returns the day of the month for is...

Question 17

Match between columns Premises: > >= <> < <=

Accepted Answer

The Answer of Greater than and Less than and Not is...

Question 18

Match between columns
                        Premises: OR
MATCH
INDEX
RATE
IF

Accepted Answer

The Answer of Returns the interest rate of a loan is...

Question 19

Match between columns
                        Premises: IF
INDEX
DCOUNT
IPMT
YEARFRAC

Accepted Answer

The Answer of Logical and Database and Financial and Date is...

Question 20

Match between columns
                        Premises: DSTDEV
DMIN
DSUM
DAVERAGE
DMAX

Accepted Answer

The Answer of Calculates the difference from the median and is...

Quiz 7: Specialized Functions

The DCOUNTA function returns an error if it encounters a blank record.

The RATE function returns the periodic rate for an investment or loan.

A loan amortization table is a schedule that calculates the interest per payment period, principal repayment for each payment, and remaining balance after each payment is made.

NPER calculates the periodic interest rate of an investment or loan.

Database functions do not require a Criteria Range.

This is a correct example of the structure of an IPMT function.=IPMT(rate,per,nper,pv,[fv],[type])

The PPMT function calculates the monthly principal and interest payment of a loan or investment.

The NPV function is used mostly to calculate return rates for IRAs.

DSTDEV calculates the standard deviation of a sample population in a database range.

The database argument of a database function must include the entire range of the database.

Match each of the following terms to its best description of its function in a loan:

Match each of the following functions to its best description:

Match each of the following terms to its best description:

Match each of the following terms with its best conceptual description:

Match each of the following functions to its return:

Match each of the following terms to its description:

Associate the following functions with its corresponding purpose:

Match the following functions with their categories of function:

Match each of the following functions its best description of mathematical operation: