Formatting the Worksheet q You format a worksheet

Formatting the Worksheet q. You format a worksheet to emphasize certain entries. q. The font type is a good way to do this. q. The font size and color are good ways to do this. q. Changing the cell styles are good ways to do this.

Changing a Cell Style q Click cell A 1 to make it active. q Click the Cell Styles button on the Ribbon. q Point to the Title cell style in the Titles and Headings area of the Cell Styles gallery to see a live preview of the cell style in cell A 1. q Click the Title cell style

Sample Worksheet Title cell style

Changing the Font Type q. Click cell A 2 to make it active. q. Click the font box arrow on the Ribbon to display the Font gallery. q. Point to Cambria in the Theme font area. q. Click Cambria to change the font type from Calibri to Cambria.

Sample Worksheet (2) Font gallery

To Bold a Cell Click cell A 2 to make it active. • Click the bold button on the Ribbon to change the font style.

To Increase the Font Size of a Cell q. Click on cell A 2 to activate it. q. Click the Font Size box arrow on the Ribbon to display the Font Size List. q. Point to 14 in the Font Size list to preview it. q. Click 14 to change the font in A 2 from 11 to 14.

Sample (3) Font Size list

To change the Font Color of a Cell Entry q Click on cell A 2 to activate it. q Click the Font Color button arrow on the Ribbon to display the Font Color palette. q Point to Dark Blue in row 1, column 4. q Click on Dark Blue on the Font Color palette to change the font from black to dark blue.

Sample (4) Font color button arrow

To Center Cell Entries by Merging Cells q. Merging cells involves creating a single cell by combining two or more selected cells.

Merging Cells q. Select cell A 1 and then drag to cell G 1 to highlight the range A 1: G 1. q. Click the Merge and Center button on the Ribbon to merge cells A 1 through G 1 and center the contents of cell A 1 across columns A through G.

Sample (5) Merge and Center Button

Merging cells continued (2) q. Repeat these steps to merge and center the worksheet subtitle across cells A 2 through G 2.

To Format Column Titles and the Total Row q. Click cell A 3 and then drag the mouse pointer to cell G 3. q. Point to the Cell Styles button to display the Cell Styles gallery. q. Point and click the Heading 3 cell style to apply the cell style to the ranger A 3: G 3.

Sample (6) Heading 3

Formatting the Row Total q Click cell A 9 and then drag the mouse pointer to cell G 9. q Point to the Cell Styles button on the Ribbon. q Click the Cell Styles button on the Ribbon to display the cell styles gallery. q Click the Total cell style in the Titles and Headings area to apply the Total cell style to cells A 9: G 9.

Sample (7) Total cell style

To Format Numbers in the Worksheet q. Select cell B 4 and drag the mouse pointer to cell G 4 to select the range B 4: G 4. q. Point to the Accounting Number Format button on the Ribbon to display the Enhanced Screen Tip. q. Click the Accounting Number Format button on the Ribbon to apply this format to the range B 4: G 4.

Sample (8) Accounting Number Format Accounting Button Format Button

Formatting Numbers using Comma Style q. Select the range B 5: G 8 q. Click on the Comma Style button on the Ribbon to apply the Comma Style to the range B 5: G 8.

Sample (9)

Formatting Numbers q. Select the range B 9: G 9. q. Click the Accounting Number Format button on the Ribbon to apply the Accounting Number format to the cells in the range B 9: G 9. q. Then Select A 11.

Sample (10) Accounting Number format applied to range B 9: G 9

Adding a Chart q. A good way to model our numbered data is with a chart. q. A chart uses different colored columns to represent sales for different product types. q. Each region uses the same color scheme for identifying product types.

Adding a 3 -D chart q Click cell A 3 and then drag the mouse pointer to the cell F 8 to select the range A 3: F 8. q Click the Insert tab to make the Insert Tab the active tab. q Click the Column button on the Ribbon to display the Column gallery. q Point to the 3 -D Clustered Column chart type in the 3 -D area

Sample (11) Insert Tab Column Button 3 -D Clustered Column Chart

Adding a Chart q. Click the 3 -D Clustered Column chart type in the 3 -D Column area to add the chart. q. Click the top-right edge of the selection rectangle but do not release the mouse to grab the chart and change the mouse pointer to a crosshair with four arrowheads.

Sample (12) Mouse pointer changes to crosshair. Selection rectangle

Moving the Chart q Continue holding down the mouse button while dragging the chart over the upper-left corner of cell A 11. Release the mouse button. q Click the middle sizing handle on the right edge of the chart and do not release the mouse button. q While holding down the mouse button, press the alt key and drag the right edge of the chart to the right edge of Column G q Release the mouse button.

Sample (13) Middle Sizing Handle

Moving the Chart (3) q. Point to the middle sizing handle on the bottom edge of the selection rectangle and do not release the mouse button. q. While holding down the mouse button, press the alt key and drag the bottom edge of the chart up to the bottom edge of row 22 and release the mouse button.

Sample (14) Bottom edge of Row 22 Right edge of column G

Using the More Styles button q. Click the More button in the Chart Styles gallery to expand the gallery and point to Style 2 in the gallery.

Changing Document Properties q. Excel helps you organize and identify your files by using document properties, which are the details about a file. q. Document properties, also known as metadata, can include such information as the project author, title or subject.

To Change Document Properties q. Click the Office Button to display the office Button menu. q. Point to Prepare on the Office Button menu to display the Prepare submenu. q. Click Properties on the Prepare submenu to display the Document Information Panel.

Sample (15) Clicking Properties will open Document Info Panel.

To Change Document Properties(2) q. Click the Author text box and then type in your name q. Click the Subject text box and then type in Excel q. Click the Keywords text box and then type in First Quarter Rock-It MP 3 Sales.

Student Name Sample (16)

Using Auto Calculate q. You can easily obtain a total, an average, or other information about the numbers in a range by using the Auto Calculate area on the statues bar. q. Select the range B 6: F 6 and then right-click the Auto Calculate area on the status bar to display the Status Bar Configuration shortcut menu. q. Click maximum on the shortcut menu to display the Maximum value in the range B 6: F 6.

Sample (17) Maximum Command Right-Click

Undoing and Re-doing Cell Entries q. Excel remembers the last 100 actions you have completed. q. Thus you can undo up to 100 previous actions by clicking the undo button arrow to display the undo list and then clicking the action to be undone. q. The Redo button, next to the Undo button allows you to repeat previous actions.

Sample (18) Undo button

Excel Help q. Using Excel Help, you can search for information based on phrases such as save a workbook, format a chart, or key terms such as copy and save. q. Click the Microsoft Office Excel Help button near the upper-right corner of the Excel window to open the Excel Help window.

Excel Help(2) q. Type format a chart in the Type words to search for a text box at the top of the Excel window. q. Press the Enter key to display the search results. q. Click the Maximum button on the Excel Help window title bar to maximize the Help window. q. Click the Format chart elements link to display information regarding formatting chart elements.

Sample (19) Type words

Sample (20)

Save and Exit q. Click on the Save button q. Click on the close button on the right side of the Excel title bar

Save button Final Sample Close button.

The End