Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet
1 Click the Start button on the Windows Vista taskbar to display the Start menu.
You can use a
command-line switch to
start Excel and control
how it starts. First, click
the Start button on the
Windows Vista taskbar,
and then click the Start
Search box. Next, enter
the complete path to
Excel’s application ﬁ le
including the switch (for
Files\Microsoft Ofﬁ ce\
The switch /e starts
Excel without opening a
new workbook; /i starts
Excel with a maximized
window; /p “folder” sets
the active path to folder
and ignores the default
folder; /r “ﬁ lename”
opens ﬁ lename in read-
only mode; and /s starts
Excel in safe mode.
2 Point to All Programs at the bottom of the left pane on the Start menu to display the All
3 Click Microsoft Ofﬁ ce in the All Programs list to display the Microsoft Ofﬁ ce list.
4 Click Microsoft Ofﬁ ce Excel to start Excel and display a blank worksheet in the Excel window.
5 If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.
6 If the worksheet window in Excel is not maximized, click the Maximize button next to the
Close button on its title bar to maximize the worksheet window within Excel.
The ﬁ rst step in creating the worksheet is to enter the titles and numbers into the worksheet.
To Enter the Worksheet Title and Subtitle
The following steps enter the worksheet title and subtitle into cells A1 and A2.
1 If necessary, select cell A1. Type Silver Dollars Stock Club in the cell and then press
the DOWN ARROW key to enter the worksheet title in cell A1.
2 Type Portfolio Summary in cell A2 and then press the DOWN ARROW key to enter the
worksheet subtitle in cell A2 (Figure 2–4 on page EX 89).
To Enter the Column Titles
The column titles in row 3 begin in cell A3 and extend through cell J3. The
column titles in Figure 2–3 include multiple lines of text. To start a new line in a cell,
press ALT + ENTER after each line, except for the last line, which is completed by clicking
the Enter box, pressing the ENTER key, or pressing one of the arrow keys. When you
see ALT + ENTER in a step, press the ENTER key while holding down the ALT key and then
release both keys.
The stock names and the row titles Totals, Average, Highest, and Lowest in the
leftmost column begin in cell A4 and continue down to cell A16. This data is entered
into rows 4 through 12 of the worksheet. The remainder of this section explains the steps
required to enter the column titles, stock data, and row titles as shown in Figure 2–4 on
page EX 89 and then save the workbook.
1 With cell A3 selected, type Stock and then press the RIGHT ARROW key.
2 Type Symbol in cell B3 and then press the RIGHT ARROW key.