Page 91 - Ms Excel Note and Workbook
P. 91

MICROSOFT EXCEL NOTE AND WORKBOOK


               To create a formula:



               In our example below, we'll use a simple formula and cell references to calculate a budget.

               1.  Select the cell that will contain the formula. In our example, we'll select cell D12.
























               2.  Type the equals sign (=). Notice how it appears in both the cell and the formula bar.







                                                                                      TIP
                                                                              All formulas in Excel must
                                                                              begin with an equals sign
                                                                              (=)..













               3.  Type the cell address of the cell you want to reference first in the formula: cell D10 in
                   our example. A blue border will appear around the referenced cell.



















                                                                                               82 | P a g e
   86   87   88   89   90   91   92   93   94   95   96