After you have designed your worksheet, you will likely want to make additional adjustments to refine the layout of the data in your worksheet.
Activity 2.11. Formatting Cells with the Percent Style Button
A percentage is part of a whole expressed in hundredths. For example, .75 is the same as 75%. The Percent Style button on the Formatting toolbar formats the selected cell as a percentage rounded to the nearest hundredth.
1. |
Click cell F3 and notice the number 0.245713662. |
2. |
Select the range F3:F8, click the Percent Style button , click Increase Decimal two times, and then click the Center button. |
3. |
Save your workbook. |
Activity 2.12. Inserting Rows in a Worksheet Containing Formulas
If you need to insert additional rows or columns, or move a formula that calculates values used by other formulas, Excel will adjust formulas for you. Additionally, you can edit formulas in the same manner as you edit text. In this activity, you will add a row for golf socks, which is another item carried by the pro shop.
1. |
Double-click cell E9 and confirm that the range finder shows the formula to be the sum of cells E3:E8. Press . |
||||
2. |
Click cell E6, and then from the Insert menu, click Cells. In the Insert dialog box, click the Entire row option button, and then click OK. Alternatively, you can click the row 6 heading and then, from the Insert menu, click Rows. |
||||
3. |
Click cell E10. On the Formula Bar, notice that the range was edited and changed to sum the newly expanded range E3:E9. |
||||
4. |
In cells A6:D6, type the following:
|
||||
5. |
Select the range E5:F5 to select the two formulas above the new row, and then drag the fill handle to fill both formulas down to E6:F6. |
||||
6. |
Click cell E10. Move the pointer to the bottom edge of the cell until the Move pointer displays. Compare your screen with Figure 2.32. Figure 2.32. |
||||
7. |
Drag the pointer downward until cell E11 is outlined, and then release the mouse button. Double-click cell E11. In cell E11 and on the Formula Bar, notice that the range, E3:E9, did not change when you moved the formula. Compare your screen with Figure 2.33. Figure 2.33. If you move the formula to another cell, the cell references do not change. |
||||
8. |
Press and then click Undo to return the formula to cell E10. Save your workbook. |
Activity 2.13. Wrapping Text in a Cell
Title text often becomes the longest entry in a column. You can wrap text to two lines so that columns are not unnecessarily wide.
1. |
In the row heading area, point to the line between rows 2 and 3 to display the two-headed pointer . Drag this boundary downward until row 2 is 50 pixels high. Select columns B:F, and then from the heading area, drag the right border of one of the selected columns to 80 pixels. |
2. |
Select the range B2:F2. Display the Format Cells dialog box, and then click the Alignment tab. Under Text control, select the Wrap text check box. Under Text alignment, click the Horizontal arrow, and then click Center. Compare your screen with Figure 2.34. Figure 2.34. The text in the selected cells will be wrapped onto more than one line when the cell is not wide enough to display the contents. |
3. |
In the Format Cells dialog box, click OK. |
4. |
Click cell A2 and click Center . Click cell E10. Click the Borders button arrow . From the displayed menu, in the second row, click the fourth borderTop and Double Bottom Border. Click another cell to cancel the selection. Compare your screen with Figure 2.35. Figure 2.35. |
5. |
Save the changes you have made to your workbook. |
[Page 730 (continued)] Objective 8 Make Comparisons Using a Pie Chart |
Windows XP
Outlook 2003
Internet Explorer
Computer Concepts
Word 2003
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Excel 2003
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Access 2003
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Powerpoint 2003
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Integrated Projects
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents