Cell references in Excel are like addresses that point to specific cells. Three types of Excel cell references are relative, absolute, and mixed, each with unique functions.

Put a cell reference to B4, the monthly payment formula, in cell E3. See these inputs in the screenshot below. Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within ...