Core Training for Microsoft Office Excel 2003

Changing Document Appearance

Changing the Appearance of Data

1To begin changing the appearance of data, click cell E2, on the Formatting toolbar, click the Font Size arrow, and then click 14.
2To emphasize the cell content, on the Formatting toolbar, click the Bold button.
3To begin adding a border to the cell, on the Formatting toolbar, click the Borders button arrow, as indicated, and then, click Draw Borders.
4To add a border, position the pointer on the middle of the left edge of cell E2, and drag to the indicated position.
5To close the Borders toolbar, on the Borders toolbar, click the Close button.
6To add color to a cell, on the Formatting toolbar, click the Fill Color arrow, and then, in the Fill Color palette, click the Yellow square, as indicated.
7To center align the data labels of a sheet, click the row 5 heading, and then on the Formatting toolbar, click the Center button.

Applying Styles and Formats to Data

1To begin formatting a new style, click the Format menu, and then click Style.
2To create a new style, in the Style dialog box, press Delete, then for the purposes of this exercise, press SPACEBAR, and in the Style name box, Emphasis will be typed for you.
3To begin formatting the new style, click Modify.
4To specify a font style, in the Format Cells dialog box, click the Font tab, and then, in the Font style list, click Bold Italic.
5To begin setting the alignment for the new style, in the Format Cells dialog box, click the Alignment tab.
6To choose an alignment type, in the Format Cells dialog box, in the Text alignment section, click the Horizontal box arrow, and then click Center.
7To apply the selected format to the new style, in the Format Cells dialog box, click OK.
8To apply the new style to a cell, in the Style dialog box, click OK.
9To format another cell using the new style, click cell B5, then, on the Format menu, click Style, and then in the Style dialog box, click the Style name arrow, click Emphasis, and then click OK.
10To begin selecting a group of cells to format by using an Excel predefined AutoFormat style, click cell A3, and then click below the scroll box on the vertical scroll bar.
11To select the cells, click to the right of the scroll box on the horizontal scroll bar, hold the SHIFT key, and then click cell P38.
12To choose an AutoFormat style, click the Format menu, and then click AutoFormat.
13To select an AutoFormat style, in the AutoFormat dialog box, drag the scroll bar to the position indicated, click List 3, and then click OK.

Making Numbers Easier to Read

1To begin formatting cells that hold numbers, click the Format menu, and then click Cells.
2To assign a date format to a cell, in the Format Cells dialog box, on the Number tab, in the Category box, click Date, and in the Type list, click 3/14/01, and then click OK.
3To apply the selected date format to a range of cells, on the Standard toolbar, click the Format Painter button, and drag from cell B5 to cell B23.
4To begin assigning a phone-number format to a cell, click to the right of the scroll box on the horizontal scroll bar, click cell J4, click the Format menu, and then click Cells.
5To select a phone-number format, in the Format Cells dialog box, on the Number tab, in the Category box, click Special, in the Type box, click Phone Number, and then click OK.
6To apply the selected phone-number format to a range of cells, on the Standard toolbar, click the Format Painter button, and drag from cell J5 to cell J23.
7To begin creating a custom format, click cell K4.
8To select a predefined custom format, in the Format Cells dialog box, on the Number tab, in the Category box, click Custom, and then, in the Type list, click #,##0.00.
9To begin modifying a predefined custom format, in the Format Cells dialog box, in the Type box, click to the left of #,##0.00, hold down the SHIFT key, press $, and then release the SHIFT key.
10To create a new format, in the Type box, click to the right of $#,##0.00, and for the purposes of this exercise, press SPACEBAR, wait as "total" is typed for you, and then click OK.
11To apply the new custom format to a range of cells, on the Standard toolbar, click the Format Painter button, and then drag from cell K5 to cell K23.
12To begin adding data to the formatted cells, click to the left of the scroll box on the horizontal scroll bar, and then click cell B4.
13To add a date to the formatted cell, for the purposes of this exercise, press SPACEBAR, and January 25, 2004 will be typed for you.
14To add data to the other formatted cells, click cell C4, and then, for the purposes of this exercise, press SPACEBAR, and C100001 will be typed for you.
15To view formatting changes that Excel makes to the entered data, click cell K5.

Making Printed Worksheets Easier to Read

1To create a custom header and footer, click the View menu, and then click Header and Footer.
2To begin adding a footer to a worksheet, in the Page Setup dialog box, on the Header/Footer tab, click Custom Footer.
3To begin adding an image to the footer, in the Footer dialog box, click the Center section box, and then click the Insert Picture button, as indicated.
4To finish adding a picture, in the Insert Picture dialog box, click the Up One Level button, double-click the Garden Company folder, double-click Artwork, and then double-click TGC_Logo.
5To begin formatting a selected picture, in the Footer dialog box, click the Format Picture button, as indicated.
6To reduce the picture’s height to half its original size, in the Format Picture dialog box, on the Size tab, in the Scale section, in the Height box, double-click 100.
7To specify a new height, for the purpose of this exercise, press SPACEBAR, wait as 50 is typed for you, and then click OK.
8To finish formatting the footer, in the Footer dialog box, click OK.
9To add a header to a worksheet, in the Page Setup dialog box, click Custom Header.
10To include a date in the header, in the Header dialog box, click the Date button, as indicated.
11To add a page number to the header, in the Header dialog box, click the Right section box, and click the Page Number button, as indicated.
12To finish formatting the header, in the Header dialog box, click OK.
13To preview how a worksheet would look on a printed page, in the Page Setup dialog box, click Print Preview.

Positioning Data on a Printed Page

1To begin aligning data on a worksheet, on the Standard toolbar, click the Print Preview button, as indicated.
2To set the alignment of the printer margins so that the company logo fits entirely in the footer area and does not overlap onto the worksheet data, in the Print Preview window, click Margins.
3To change the bottom margin, position the pointer over the indicated horizontal margin, and when the pointer changes to a double-headed arrow, drag it up to the indicated location.
4To begin aligning data for the printed page, in the Print Preview window, click Setup.
5To ensure that all data fits on a single printed page, in the Page Setup dialog box, in the Orientation section, click the Landscape option, and then, in the Scaling section, click the Fit to option.
6To center data on a printed page, in the Page Setup dialog box, click the Margins tab, in the Center on page section, click the Horizontally check box, and then click the Vertically check box.
7To accept the formatting changes, click OK, and then, in the Print Preview window, click Close.