|
Use the PMT function to calculate the payment for a car loan or home mortgage; use the FV function to determine the future value of a retirement account. Explain how the Goal Seek command can facilitate the decision-making process in conjunction with the PMT and/or FV functions. Define a mixed reference; use mixed references to vary two parameters within the FV or PMT functions. Use the AVERAGE, MAX, MIN, and COUNT functions in a worksheet. Use the IF and VLOOKUP functions to implement decision-making in a worksheet. Freeze and unfreeze, hide and unhide, the rows and columns in a worksheet; explain how these commands facilitate working with large worksheets. Describe the various options within the Page Setup command that are used in conjunction with printing large spreadsheets.
|