Project 1A. Tableware

1.

On the Windows taskbar, click the Start button .

The Start menu displays. Organizations and individuals store computer programs in a variety of ways. The Excel program might be installed under All Programs or Microsoft Office or some other arrangement. An example is shown in Figure 1.2.

2.

Point to All Programs , determine where the Excel program is located, point to Microsoft Office Excel 2003 , and then click once to start the program. Compare your screen with Figure 1.3.

3.

In the upper right corner of the Getting Started task pane, click the Close button to close the task pane.

When not in use, close the task pane in this manner to allow the maximum amount of screen space for your worksheet.

4.

Take a moment to study Figures 1.4 and 1.5 and the table in Figure 1.6 to become familiar with the parts of the Excel window.

Figure 1.6. Parts of the Excel Window

5.

On the menu bar, click File to display the File menu, click Save As , and then compare your screen with Figure 1.7.

6.

In the displayed Save As dialog box, click the Save in arrow to view a list of the drives available to you, and then navigate to the drive on which you will be storing your projects for this chapterfor example, a USB flash drive such as the one shown in Figure 1.8.

7.

In the upper right corner of the Save As dialog box, click the Create New Folder button . In the displayed New Folder dialog box, in the Name box, type Excel Chapter 1 and then compare your screen with Figure 1.9.

8.

In the New Folder dialog box, click OK .

Windows creates the Excel Chapter 1 folder and makes it the active folder in the Save As dialog box. At the bottom of the Save As dialog box, in the File name box, Book1 displays as the default file name.

9.

In the File name box, using your own first and last name, replace Book1 , which is highlighted in blue, by typing 1A_Tableware_Firstname_Lastname being sure to include the underscore ( ) instead of spaces between words. Compare your screen with Figure 1.10.

Windows recognizes file names that use spaces between words. However, some electronic file transfer programs do not. In this text, you will use underscores instead of spaces between words for your file names .

Text highlighted in blue in a Windows dialog box will be replaced by your new typing. Alternatively, use the key to delete text in a box, and then type.

10.

In the lower right corner of the Save As dialog box, click Save .

The file is saved in the new folder with the new name. The workbook redisplays, and the new name displays in the title bar.

1.

On the menu bar, click File .

The File menu displays in either the full format, as shown in Figure 1.11, or in a short format, as shown in Figure 1.12. Excel's commands are organized in menus lists of commands within a category. A short menu will display fully after a few seconds, or you can click the double arrows at the bottom to display the full menu.

NoteDisplaying Full Menus

Many Excel users prefer the automatic full menu display. To set a system to always display full menus, display the Tools menu, click Customize, and then click the Options tab. Under Personalized Menus and Toolbars, select the Always show full menus check box. Click the Reset menu and toolbar usage data button, click Yes, and then click Close.

2.

If the full menu is not displayed, pause your mouse pointer over the Expand arrow to expand the File menu. Compare your screen with Figure 1.13.

3.

Look at the full File menu on your screen.

Following or to the right of some menu commands, you will see various symbols, characters , or formatting, which are standard across all Microsoft products. The table in Figure 1.14 lists these characteristics and describes what will happen when you select the command.

Figure 1.14. Microsoft Menu Characteristics

4.

On the menu bar, click File again to close the menu.

If you decide not to select a command from a displayed menu, close the menu either by clicking its name, by clicking outside the menu, or by pressing .

5.

On the menu bar, click View , and then point to Toolbars .

A list of available toolbars displays. A check mark indicates that the toolbar is displayed. Toolbar buttons provide a one-click method to perform common commands, instead of performing the command from the menus using multiple clicks.

6.

On the displayed list of toolbars, be sure that Standard and Formatting are both checked. Clear any other checked toolbar on the list by clicking its check mark to clear it, and then, if the list is still displayed, click outside the menu to close it.

7.

Below the menu bar, be sure two rows of toolbars display, as shown in Figure 1.15. If, instead, your toolbars are sharing one row, as shown in Figure 1.16, at the end of the toolbar click the Toolbar Options button , and then click Show Buttons on Two Rows .

8.

On the Standard toolbar, locate and pause your mouse pointer over the New button . Compare your screen with Figure 1.17.

9.

Pause your pointer over several buttons on both the Standard and Formatting toolbars to become familiar with the commands available to you. Recall that a toolbar button is a one-click method to activate frequently used commands that are also available from the menus. The ScreenTip describes the command that will be activated when you click the toolbar button.

1.

Take a moment to study Figures 1.18 and 1.19 and the table in Figure 1.20 to become familiar with the Excel workbook window.

Figure 1.20. Excel Workbook Elements

2.

In the horizontal scroll bar, point to and then click the right scroll arrow . Compare your screen with Figure 1.21.

3.

In the horizontal scroll bar, click the right scroll arrow and hold the mouse button down until the columns begin to scroll rapidly to the right; release when you begin to see pairs of letters as the column headings.

The workbook window moves rapidly. This technique also works for the left scroll arrow and for the two vertical scroll arrows.

4.

In the horizontal scroll bar, click the left scroll arrow to shift one column.

5.

In the horizontal scroll bar, point to the horizontal scroll box , hold down the left mouse button, drag the box to the left to display column A , and then release the mouse button.

The action of dragging includes releasing the mouse button at the desired time or location. Use the scroll boxes in this manner to bring various parts of the worksheet into view. Scroll boxes change in size to indicate how the visible portion of the worksheet compares to the total amount of the worksheet in use.

6.

Use the techniques you just practiced to scroll the worksheet to position column Z near the center of your screen, and then compare your screen with Figure 1.22.

7.

Near the bottom left of the screen, point to and then click the Sheet2 tab .

The second worksheet in the workbook displays and becomes the active worksheet. Column A displays at the left.

8.

Click the Sheet1 tab .

The first worksheet in the workbook becomes the active worksheet. A workbook consists of one or more worksheets. By default, new workbooks contain three worksheets. When you save a workbook, the worksheets are contained within it and do not have separate file names.

9.

In the vertical scroll bar, point to and then click the down scroll arrow one time.

Row 1 moves out of view. The number of times you click the arrows on the vertical scroll bar determines the number of rows shifted either up or down. You can drag the vertical scroll box to scroll downward in a manner similar to the technique used in the horizontal scroll bar.

10.

In the vertical scroll bar, point to and then click the up scroll arrow .

Row 1 comes back into view. The maximum number of rows on a single Excel worksheet is 65,536.

11.

Use the skills you just practiced to scroll horizontally to display column A .