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

Hour 6. Understanding Excel 2003 Workboo... > Understanding Worksheets and Workboo...

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 a spreadsheet or just sheet). A worksheet is a collection of rows and columns that holds text and numbers, as you see in Figure 6.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.

Any time 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 3, “Formatting with Word 2003.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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