Page 106 - CalcBus_Flipbook
P. 106
11-12 Credit with MS Excel CH 11]
3. Move your mouse cursor to cell D13, Regular Payment. The equation in this cell is
=D4*D11. In the label Cell you will read D13. Here you will type Regular_Payment.
Typing in the label cell does not change the arithmetic in the cell, it only gives it a label.
This label has an underscore line connecting Regular and Payment. Then change the
width of Column I to 2.
Highlight Column I and change its width to 2. Refer to Page 11-4 Step 7 on how to
change column widths.
4. At this point, you will add cell labels and widen cells to handle the values of a Loan
Payment Schedule. Begin at cell C20 and type Loan Payment Schedule. Bold this entry
and underline it by selecting the Bold in the task bar and the Underline.
Readers are Leaders, Leaders are Readers and
Non-readers follow!
Copyrighted Material