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
   101   102   103   104   105   106   107   108   109   110   111