Setting Up a Workbook

Core Training for Microsoft Office Excel 2003

Making Workbooks Easier to Work With

1	To begin making the workbook easier to read, and to cut and move cells, drag from cell C1 to cell D3, and then on the Standard toolbar, click the Cut button.
2	To begin relocating the cut cells, drag from cell B5 to cell C7, click the Insert menu, and then click Cut Cells.
3	To shift cells B5 through C7 to the right, and insert the cut cells, in the Insert Paste dialog box, click OK.
4	To begin deleting extra cells in a column, drag from cell D5 to cell D7, click the Edit menu, and then click Delete.
5	To relocate cells E5 to E7 to the left, in the Delete dialog box, click OK.
6	To begin renaming a worksheet, in the lower-left corner of the workbook window, double-click the Sheet2 tab.
7	To enter the name of the worksheet, for the purposes of this exercise, press SPACEBAR, wait as the sheet name January is typed for you on the sheet tab, and then press ENTER.
8	To change the order of a worksheet, click the January tab until a file icon appears at the cursor, and then drag the file icon to the left of the Sheet1 tab.
9	To begin selecting several columns, click column heading A, and then click to the right of the scroll box on the horizontal scroll bar.
10	To select columns from A to M, hold down the SHIFT key, and then click column heading M.
11	To begin to change the width of selected columns simultaneously, position the cursor over the right edge of column heading M, until it changes to a double-headed arrow.
12	To change the width of all the selected columns simultaneously, drag the arrow to the right until the indicated Name Box reads Width: 10.00 (75 pixels).
13	To begin selecting several rows, click row heading 3, and then click below the scroll box on the vertical scroll bar.
14	To select rows 3 to 35, hold down the SHIFT key, click row head 35, and then release the SHIFT key.
15	To increase the height of multiple rows simultaneously, position the cursor over the lower-edge of row heading 35, until a double-headed arrow appears, and then drag it down until the Name Box reads Height: 25.50 (34 pixels).
16	To go to the upper-left corner of the worksheet, hold down the CTRL key, and then press HOME.
17	To merge and center cells, drag from cell E2 to cell G2, and then on the Formatting toolbar, click the indicated Merge and Center button.
18	To insert a new row, click cell A3, click the Insert menu, and then click Rows.
19	To insert a new column, click the Insert menu, and then click Columns.
20	To scroll down and view row 14, click below the scroll box on the vertical scroll bar.
21	To hide rows, drag from row heading 14 to row heading 20, click the Format menu, point to Row, and then click Hide.
22	To unhide the rows, click the Format menu, point to Row, and then click Unhide.
23	To begin changing the default value for the number of sheets in a new workbook, click the Tools menu, click Options, and then click the General tab.
24	To select the value for number of worksheets, double-click the value in the Sheets in new workbook box.
25	To enter a new value for number of worksheets, press the SPACEBAR, wait as the value 12 is typed in the Sheets in new workbook box, and then click OK.

Making Data Easier to Read

1	To begin making the data easier to read, click the Format menu, and then click Cells.
2	To begin changing the display of content in a cell, in the Format Cells dialog box, click the Alignment tab.
3	To wrap text in a cell, in the Text control section, click the Wrap text check box, and then click OK.
4	To view the data labels at the top of the worksheet, on the vertical scroll bar, click above the scroll box.
5	To select several cells, drag from cell B1 to cell E1.
6	To align the content to the center of the cell, on the Formatting toolbar, click the Center button, as indicated.
7	To freeze a pane, click cell A2, click the Window menu, and then click Freeze Panes.
8	To verify the functioning of the Freeze Panes option, on the vertical scroll bar, click the scroll down arrow twice.
9	Notice that the cell above the frozen cell remains at the top of the worksheet. To unfreeze the pane, click the Window menu, and then click Unfreeze Panes.

Adding a Graphic to a Worksheet

1	To begin inserting a graphic in a workbook, click the Insert menu, point to Picture, and then click From File.
2	To locate a graphic, in the Insert Picture dialog box, click the Up One Level button, and then double-click the GardenCompany folder.
3	To begin inserting the graphic, click the Artwork folder, click Open, and then click TGC_Logo.gif, and click Insert.
4	To begin resizing a graphic, double-click the graphic.
5	To verify whether the Lock aspect ratio is selected, in the Format Picture dialog box, click the Size tab.
6	Notice that the Lock aspect ratio check box is selected. To begin changing the value of the graphic's height, in the Scale section, double-click the Height box.
7	To reduce the height of the graphic to 50% of its original size, for the purposes of this exercise, press the SPACEBAR and 50 will be entered for you in the Height box.
8	To begin changing the rotation value for a graphic, in the Size and rotate section, double-click the Rotation box.
9	To begin rotating the graphic by 180 degrees, please press SPACEBAR, and wait as the rotation angle 180 is typed in the Rotation box, and then click OK.
10	To relocate a graphic to the top and center of the worksheet as a logo, drag the graphic to the indicated area.
11	To begin formatting the graphic, click the Format menu, and then click Picture.
12	To begin changing the value of the brightness of the graphic, in the Format Picture dialog box, in the Image control section, double-click the Brightness box.
13	To reduce the brightness of the graphic, please press the SPACEBAR, and wait as 40 is typed for you in the Brightness box.
14	To begin selecting the contrast value, in the Image control section, double-click the Contrast box.
15	To specify a new value for contrast, please press SPACEBAR, and wait as the text 40 is typed for you in the Contrast box.
16	To begin cropping the graphic, in the Crop from section, double-click the Top box.
17	To specify the inches to be cropped from the graphic, press SPACEBAR, and wait as .5 is typed for you in the Top box, and then press OK.
18	To begin setting a graphic as a background image, click the Format menu, point to Sheet, and then click Background.
19	To set a graphic as a background image, in the Sheet Background dialog box, click the file TGC_Logo, and then click Insert.

Managing Comments

1	To begin inserting a comment, click the Insert menu, and then click Comment.
2	To enter text in the comment box, for purposes of this exercise, please press SPACEBAR, and wait as Remember to figure in our two new lines is entered in the comment box.
3	To view the comment indicator for cell D3, click cell F5.
4	To view a comment box, position the pointer over cell D3.
5	To insert a comment in cell F5, click the Insert menu, and then click Comment.
6	To begin locating all cells with comments, click cell G7, click the Edit menu, and then click Go To.
7	To select cells with comments, in the Go To dialog box, click Special, and then click OK.
8	To clear the selection of the comments, click cell D8.
9	To begin editing an existing comment, click cell F5, click the Insert menu, and then click Edit Comment.
10	To select part of the comment text, hold down the SHIFT key, and click to the left of 2006.
11	To edit part of the comment, press SPACEBAR, and wait as 2005 is entered for you in the comments box, and then click cell D5.
12	To delete a comment, click cell D3, click the Edit menu, point to Clear, and then click Comments.

Naming Groups of Data

1	To begin naming cell ranges, drag from cell C3 to cell C18.
2	To begin naming the selected cell range, click the Insert menu, point to Name, and then click Create.
3	To assign the name in the top row as the name of the cell range, in the Create Names dialog box, click OK.
4	To verify the name assigned to the cell range, drag from cell C4 to cell C18.
5	Notice the indicated Name Box contains the range name Price. To begin assigning a name to a defined group of data, on the tab bar, click the Supplies worksheet tab.
6	To select a group of cells, on the Supplies worksheet, click cell C4, click below the scroll box on the vertical scroll bar, hold down the SHIFT key, and then click cell C29.
7	To begin naming the selected group of cells by using the Define Name dialog box, click the Insert menu, point to Name, and then click Define.
8	To assign a name to the selected cells, for the purposes of this exercise, press SPACEBAR, and wait as SuppliesPrice is typed for you in the Names in workbook box, and then click OK.
9	To begin creating a cell range on the Furniture sheet, on the tab bar, click the Furniture sheet tab.
10	To select a cell range, drag from cell C4 to cell C18.
11	To begin naming a cell range by using the Name Box, click the Name Box.
12	To assign a name to the selected cell range, press SPACEBAR, and wait as FurniturePrice is typed for you, and then press ENTER.
13	To begin assigning another name to a previously named cell range, click the Insert menu, point to Name, and then click Define.
14	To begin editing the name of the Price cell range, in the Define Name dialog box, click Price, and then double-click the Names in workbook box.
15	To assign a new name to the cell range, press SPACEBAR, and wait as ToolsPrice is typed for you, and then click OK.
16	To view all named cell ranges, click the Name Box arrow.
17	To go to a particular cell range, in the Name Box drop down list, click SuppliesPrice.