Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet EX 87
You can use a
command-line switch to
start Excel and control
how it starts. First, click
the Start button on the
Windows taskbar, and
then click Run. Next,
enter the complete path
to Excel’s application ﬁ le
including the switch (for
Files\Microsoft Ofﬁ ce\
/e). 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
readonly mode; and /s starts
Excel in safe mode.
The following steps, which assume Windows is running, start Excel based on a
typical installation of Microsoft Ofﬁ ce on your computer. You may need to ask your
instructor how to start Excel for your computer.
1 Click the Start button on the Windows taskbar to display the Start menu.
2 Point to All Programs on the Start menu and then point to Microsoft Ofﬁ ce 2007 in the All
3 Click Microsoft Ofﬁ ce Excel 2007 on the Microsoft Ofﬁ ce 2007 submenu.
4 If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.
5 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.
Entering the Titles and Numbers into the
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 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 90).
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 90 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.
3/6/07 3:28:05 PM
3/6/07 3:28:05 PM