PPMT should be used to calculate the specific interest paid on one installment of a loan.

What is the advantage of using Solver over Goal Seek? What three optimization goals can Solver calculate?

Which of the following is NOT part of XML?

What what-if analysis tool would you use to compare the impact of different interest rates on a car payment?

A relative cell reference:

To create a table from an existing range of data:

What are the advantages of using a PivotTable instead of a subtotal? Describe the four areas of a PivotTable.

Which of the following is a file type that cannot be imported into Excel?

What happens when you copy a formula containing a relative cell reference one column to the right? Why would you use an absolute reference in a formula?

What is the maximum number of IF statements in a formula?