untitled

What is the syntax of the PMT function in MS Excel?

• =PMT(rate, pv, nper, [fv], [type])

• =PMT(rate, nper, [fv], [type], pv)

• =PMT(rate, nper, pv, [fv])

• =PMT(rate, nper, [fv], [type])

What are the arguments of the PMT function and how are they used?

• rate, period, and value

• rate, nper, and pv

• interest, time, and present

• annual rate, number of periods, and future value

How does the PMT function help in comparing different loan options?

• It calculates the monthly payment for each loan option

• It determines the interest rate for each loan option

• It calculates the total loan amount for each option

• It provides the credit score required for each loan option

What cell reference represents the rate in the following PMT function?
=PMT(B7, B8, B6)

• B7

• B8

• B6

To count how many cells have text in them, use the function:

• COUNT

• COUNTIF

• COUNTA

• SUMIF

Cell A2 contains the following e-mail address: [e-mail]

Cell B2 contains the following formula: =MID(A2,FIND(“@”,A2)+1,LEN(A2)-FIND(“@”,A2)+1)

What is the result of the formula in cell B2?

• @

• excel-skills.com

• support

• #VALUE

The function =___________(.2,10,-200) displays the current value of ten payments of $200 at a 20% interest rate.

• PV

• FV

• PMT

When might you use the Index-Match combination instead of VLOOKUP?

• When you need to perform calculations on the result

• When you want to search in a single column

• When you need to retrieve data from another worksheet

• When working with text data only

What are the main advantages of using the INDEX and MATCH functions in Excel?

• They can perform complex calculations

• They can handle multiple criteria

• They are faster than VLOOKUP

• They create dynamic charts

What is the primary advantage of using XLOOKUP over VLOOKUP?

• XLOOKUP is faster

• XLOOKUP can handle approximate matches

• XLOOKUP can handle multiple criteria

• XLOOKUP is an older function