• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 7. Excel 2002 Workbooks > Understanding Worksheets and Workbooks

Understanding Worksheets and Workbooks

Excel enables you to create and edit worksheets that you store in workbooks. Typically, people work with a single worksheet, (sometimes called spreadsheets or just sheets). A worksheet is a collection of rows and columns that holds text and numbers as you see in Figure 7.1. Typically, Excel helps users prepare financial information, but you can manage other kinds of data in Excel, such as a project timeline. If your project requires multiple closely-linked worksheets, you can store the worksheets in one large workbook file. A workbook is a collection of one or more worksheets stored in the same file. A company with several divisions might create a workbook with annual sales for each division, and each division might be represented with its own tabbed worksheet inside the workbook.

Anytime you create, open, or save an Excel file, you are working with a workbook. Often that workbook contains only one worksheet. When that's the case, the terms worksheet and workbook are basically synonymous. To open a new Excel worksheet (in a new workbook), select File, New to display the New Document Task Pane, which is virtually identical to Word's New Document Task Pane that you learned about in Hour 4, "Formatting with Word 2002."


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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