Excel Functions Quiz

Which function is used to add all of its arguments that meet multiple criteria?

• XLOOKUP

• IFERROR

• SUMIFS

• XIRR

What function is used to calculate the payment for a loan based on constant payments and a constant interest rate?

• EOMONTH

• SLOPE

• XIRR

• PMT

Which function finds the last day of the month after you add a specific number of months to a date?

• XLOOKUP

• EOMONTH

• SEQUENCE

• IFERROR

What function is needed to find out the annual growth rate of an investment?

• XLOOKUP

• IFERROR

• SLOPE

• XIRR

Which function combination can look up values in the whole table and is 2 Dimensional?

• INDEX & MATCH

• IFERROR

• XLOOKUP

• SEQUENCE

What function allows you to generate a list of sequential numbers in an array?

• IFERROR

• XLOOKUP

• EOMONTH

• SEQUENCE

Which function calculates the value of an investment/company/project in today's terms?

• XIRR

• SLOPE

• XNPV

• PMTO

What function is used to format financial models by checking for errors and returning a specified value if found?

• SEQUENCE

• EOMONTH

• XLOOKUP

• IFERROR

Which function is good for comparing different investment opportunities based on the annual growth rate?

• PMT

• XIRR

• SLOPE

• SUMIFS