• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

This hour extended your knowledge of worksheets by giving you more editing tools with which to insert and delete columns, rows, and cells. After you name important worksheet ranges, you won't have to track specific references in your worksheet; the name is easier to remember, and Excel changes the range if you insert data in or delete it from the range.

One of the most powerful aspects of worksheets is their recalculation capability. If you change data or a formula, Excel recalculates the entire worksheet as soon as you make the change. You are always looking at the computed worksheet with up-to-date information, no matter what kind of data changes you make. When you use formulas, you not only improve your worksheet accuracy, but also you finish your worksheets faster.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint