Here are some problems that our users have asked and received explanations on
Insert the PMT function in cell J5 to calculate the first client's monthly payment, using appropriate relative and using excel absolute value function. Copy the formula down the column.
Solved by I. E. in 16 mins
Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Solved by M. A. in 26 mins
Enter a function in cell G12, based on the payment and loan details, that calculates excel cumulative sum of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Solved by B. J. in 13 mins
Use the VLOOKUP function in cell G11 to determine the insurance cost. Use the “Value” in cell E11 to lookup the appropriate cost on the "Insurance Cost" reference table (range K11:L18). Make sure to use relative and absolute references appropriately
Solved by I. D. in 27 mins
In B5 of the Currency Exchange worksheet, use a VLOOKUP function to look up the Country traveling to, and return the country's Currency name from the table on the Currency Table worksheet. Copy this function to cell D5.
Hint: Be sure to use appropriate relative and absolute cell references.