Page 104 - Ms Excel Note and Workbook
P. 104

MICROSOFT EXCEL NOTE AND WORKBOOK


               6.  Release  the  mouse.  The  formula  will  be copied to  the  selected  cells  with
                   an absolute reference, and the values will be calculated in each cell.






























               You can double-click the filled cells to check their formulas for accuracy. The absolute reference

               should be the same for each cell, while the other references are relative to the cell's row.








                                                                                                  TIP
                                                                                           Be sure to include the
                                                                                           dollar sign ($) whenever
                                                                                           you're making an absolute
                                                                                           reference across multiple
                                                                                           cells.


























                                                                                               95 | P a g e
   99   100   101   102   103   104   105   106   107   108   109