Getting to Know Excel

Core Training for Microsoft Office XP

Introducing Excel

1	To open Excel, click the Start menu, point to All Programs, and click Microsoft Excel.
2	To open an existing workbook using Excel's new Task pane, click the View menu and click Task Pane.
3	In the Task pane, under Open a Workbook, click Workbooks....
4	In the Open dialog box, double-click the GardenCompany folder, click the Products file, and click Open.
5	To find out how to add a new worksheet to this workbook, click in the Ask A Question box in the upper-right corner, type add a worksheet, and press ENTER.
6	In the list that appears, click Insert a new worksheet.
7	To close Excel Help, click the Close button in the upper-right corner of the Help window.
8	To add two new worksheets, hold down the SHIFT key, click the Supplies sheet tab, and release the SHIFT key.
9	Notice that two sheet tabs are now selected. Click the Insert menu, and click Worksheet.
10	To rename a new worksheet, click the Format menu, point to Sheet, and click Rename.
11	Type Passiflora, and then press ENTER.
12	To rename Sheet2, double-click the Sheet2 tab.
13	Type Summary, and then press ENTER.

Saving Changes to an Existing Data List

1	To open the existing Products workbook, on the Standard toolbar, click the Open button.
2	In the Open dialog box, double-click the GardenCompany folder, click Products, and click Open.
3	To change a price on this worksheet, click cell C16 and type 15.95.
4	To save your changes, on the Standard toolbar, click the Save button.
5	To save a new copy of your data so that it can be viewed as a Lotus file, click the File menu and click Save As.
6	In the Save As dialog box, in the File name box, click just to the right of the word Products and type 1.
7	Click the Save as type down arrow to expand the list, and in the list scroll bar, click twice beneath the scroll box.
8	Click WK4 (1 2-3),and click the Save button.
9	In the dialog box indicating that some features might be lost, click Yes.

Zeroing In on Data in a List

1	To select a new active cell, click cell A3.
2	To select a range of cells, point to A3 again, hold down the left mouse button, move (drag) the mouse pointer to cell C6, and release the mouse button.
3	To copy the contents of cells A3 through C6 from the Tools worksheet to the Clipboard, on the Standard toolbar, click the Copy button.
4	To paste the copied cells to a different worksheet, in the lower-left corner of the Excel window, click the extreme right sheet tab arrow to view the sheet tabs to the right, and then click the Summary sheet tab.
5	On the Summary sheet, click cell A3, and then, on the Standard toolbar, click the Paste button.
6	To return to the Tools sheet, click the extreme left sheet tab arrow and then click the Tools sheet tab.
7	To remove the dotted marquee outline from the copied cells, press the ENTER key on your keyboard.
8	To move to cell B9 (Long-Handled Loppers), click in the Name box, type B9, and press the ENTER key on your keyboard.
9	To move back to the Summary worksheet, click the extreme right sheet tab arrow and then click the Summary sheet tab.
10	To move columns A, B, and C one column to the right, point to the column heading for column A, hold down the left mouse button, drag the pointer to the column heading for column C, and release the mouse button.
11	On the Standard toolbar, click the Cut button.
12	Click the column heading for column B, keep the left mouse button held down, drag the pointer to the column heading for column D, and release the mouse button.
13	Click the Edit menu, and click Paste.
14	To save your changes, on the Standard toolbar, click the Save button.
15	To close this workbook (without closing Excel), in the upper-right corner of Excel, click the lower of the two Close buttons.

Creating a Workbook and Entering a Series

1	To create a new blank workbook, on the Standard toolbar, click the New button.
2	To save your new workbook, on the Standard toolbar, click the Save button.
3	In the Save As dialog box, in the File name box, type SalesTrack and press the ENTER key on your keyboard.
4	To begin filling in some labels, click cell B6 and type Day.
5	Click cell C5, and type Time.
6	Click cell B8, and type Wed.
7	To have Excel fill in a series of days for you, move the mouse pointer over the lower-right corner of cell B8,and when the mouse pointer changes to a black plus sign, hold down the left mouse button, drag to cell B10, and release the mouse button.
8	To see a list of options, click the Auto Fill Options button at the lower-right corner of the selected cells.
9	Click the Copy Cells option.
10	Click the Auto Fill Options button again, and click Fill Series.
11	To insert a series of times in 15-minute increments across Row 6, click cell C6, type 3:00, press the TAB key on your keyboard, and type 3:15.
12	Click cell C6, hold down the SHIFT key, click cell D6, and release the SHIFT key.
13	Move the mouse pointer over the lower-right corner of cell D6, and when the pointer changes to a black plus sign, hold down the left mouse button, drag to cell J6, and release the mouse button.
14	To move to a new worksheet, click the Sheet2 tab near the lower-left corner of the worksheet.
15	Click cell C8, and type Bamboo S (but do not press ENTER).
16	To accept the suggested value for this cell and move to cell C9, press the ENTER key.
17	Type Bird (but do not press ENTER).
18	To delete the suggested text and simply enter the word Bird into cell C9, press the DELETE key on your keyboard and then press ENTER.
19	To replace the text (Bird) in C9 with different text, click cell C9 and type bamboo t.
20	To accept the suggested value (Bamboo Trellis), press the ENTER key on your keyboard.
21	To choose a value from a list of all entries in this column, on the shortcut menu, click Pick from List.
22	On the list below C10, click Bird Netting.
23	To return to Sheet 1, click the Sheet1 sheet tab.
24	To enter a single value into all of the cells within the range C8 through J10, move the mouse pointer to C8, hold down the left mouse button, drag to cell J10, and release the mouse button.
25	Type 0, and then hold down the CONTROL key while pressing the ENTER key on your keyboard.

Checking and Correcting Data

1	To find all instances of the word Comfy on this worksheet, click the Edit menu and click Find.
2	In the Find and Replace dialog box, on the Find tab, in the Find what box, type Comfy and then click Find Next.
3	Click Find Next again.
4	To see a list of all instances of the word Comfy, click Find All.
5	To see the worksheet location of a specific item in the list at the bottom of the Find and Replace dialog box, in the Value column, click Foot Stool (matches Comfy Chair).
6	To replace all instances of the word Comfy with the word Cushy, in the Find and Replace dialog box, click the Replace tab.
7	In the Replace with box, type Cushy, and click Replace All.
8	In the dialog box that indicates how many replacements were made, click OK.
9	To perform a new search, click the Find tab again.
10	Double-click in the Find what box, and press the DELETE key on your keyboard.
11	To expand the options on the Find tab, click the Options button.
12	To have Excel find all text that appears in italics, click the Format button.
13	In the Find Format dialog box, click the Font tab.
14	In the Font style list, click Italic and then click OK.
15	In the Find and Replace dialog box, click Find All.
16	To better view the result of your search, click Close to close the dialog box.
17	To change the formatting of the highlighted cell (C12), on the Formatting toolbar, click the Italic button.
18	To update the price in this cell, type 47.95 and press ENTER.
19	To undo the change you just made, on the Standard toolbar, click the Undo button.
20	To reformat this entry in italics, click the Undo button again.
21	To remove the italics again, click the Redo button.
22	To change the price to $47.95 again, click the Redo button once more.
23	To check the spelling on this worksheet, click the Tools menu and click Spelling.
24	In the Spelling dialog box, the first misspelled word Excel detects is Arbo, and the first suggested replacement for this spelling (in the Suggestions list) is Arbor.To change Arbo to Arbor, click Change.
25	In the dialog box that asks if you want to continue checking at the beginning of the sheet, click Yes.
26	In the dialog box indicating that no more misspellings were found, click OK.