Microsoft Excel 2007 - Formatting Data in Excel-2007, Formulas in Excel 2007
| Formatting Data in Excel-2007 |
| Change the Font Style, Size and Color |
| You can change the Font, Font Size, and Font Color of the data you enter into Excel. |
| 1. Select cells B2 to E3. |
 |
| 2. Choose the Home tab. 3. Click the down arrow next to the Font box. A list of fonts appears. As you scroll down the list of fonts, Excel provides a preview of the font in the cell you selected. 4. Find and click Times New Roman in the Font box. |
| Note: If Times New Roman is your default font, click another font. Excel changes the font in the selected cells. |
| Change the Font Size |
 |
| 1. Select cell B2. 2. Choose the Home tab. 3. Click the down arrow next to the Font Size box. A list of font sizes appears. As you scroll up or down the list of font sizes, Excel provides a preview of the font size in the cell you selected. 4. Click 26. 5. Excel changes the font size in cell B2 to 26. |
| Change the Font Color |
 |
| 1. Select cells B2 to E3. 2. Choose the Home tab. 3. Click the down arrow next to the Font Color button . 4. Click on the color white. Your font color changes to white. |
| Your worksheet should look like the one shown here. |
 |
| Align Cell Entries |
| You can adjust the cell alignment. You can center, left-align, or right-align any cell entry. Look at cells A1 to D1. Note that they are aligned with the left side of the cell. |
 |
| Center |
| To center cells A1 to D1: |
 |
| 1. Select cells A1 to D1. 2. Choose the Home tab. 3. Click the Center button in the Alignment group. Excel centers each cell's content. |
| Left-Align |
| To left-align cells A1 to D1: |
 |
| 1. Select cells A1 to D1. 2. Choose the Home tab. 3. Click the Align Text Left button in the Alignment group. Excel left-aligns each cell's content. |
| Right-Align |
| To right-align cells A1 to D1: |
 |
| 1. Select cells A1 to D1. Click in cell A1. 2. Choose the Home tab. 3. Click the Align Text Right button. Excel right-aligns the cell's content. 4. Click anywhere on your worksheet to clear the highlighting. |
| Note: You can also change the alignment of cells with numbers in them by using the alignment buttons. |
| Create Borders |
 |
| 1. Select cells B6 to E6. |
 |
| 2. Choose the Home tab. 3. Click the down arrow next to the Borders button . A menu appears. 4. Click Top and Double Bottom Border. Excel adds the border you chose to the selected cells. |
 |
| Add Background Color |
| To make a section of your worksheet stand out, you can add background color to a cell or group of cells. |
 |
| 1. Select cells B2 to E3. |
 |
| 2. Choose the Home tab. 3. Click the down arrow next to the Fill Color button . 4. Click the color dark blue. Excel places a dark blue background in the cells you selected. |
 |
| Add a Comment to a Cell |
| A comment can be added to any cell on your spreadsheet. When you hover your mouse pointer over a cell that contains a comment, you'll see the comment appear in a sort of Sticky- |
| To let users know what to do, we'll add a comment to cell B1. |
| To let people know about this, you can add your comment to the cell. To add a comment to cell B1, do the following: |
| . Click inside cell B1 on your spreadsheet . From the menu bars on the Ribbon at the top of Excel, click on Review . Click on New Comment |
 |
| A greenish textbox will appear to the right of cell B1, as in the image below: |
 |
| The word "user" in the image above is placed there by Excel. This is the name of the user account that was set up in either Windows XP or Vista. Press the backspace on your keyboard to delete this. |
| To add your comment, just start typing. The size of the comment area can be increased or decreased by moving your mouse over the white circles. Hold down the left mouse button and drag. |
 |
| When you have finished typing your comment, click on any other cell. The comment will disappear. Notice that the cell now has a red triangle in the top right. This indicates that it contains a comment: |
 |
| If you move your mouse pointer over cell B1 the comment will appear: |
 |
| To get rid of a comment, right click the cell that contains the comment. Then, from the menu that appears, select Delete Comment. |
| Formulas in Excel 2007 |
| Addition |
| 1. Type Add in cell A1. 2. Press Enter. Excel moves down one cell. 3. Type 1 in cell A2. 4. Press Enter. Excel moves down one cell. 5. Type 1 in cell A3. 6. Press Enter. Excel moves down one cell. 7. Type =A2+A3 in cell A4. 8. Click the check mark on the Formula bar. Excel adds cell A1 to cell A2 and displays the result in cell A4. The formula displays on the Formula bar. |
 |
| Note: Clicking the check mark on the Formula bar is similar to pressing Enter. Excel records your entry but does not move to the next cell. |
| Subtraction |
 |
| 1. Press F5. The Go To dialog box appears. 2. Type B1 in the Reference field. 3. Press Enter. Excel moves to cell B1. |
 |
| 4. Type Subtract. 5. Press Enter. Excel moves down one cell. 6. Type 6 in cell B2. 7. Press Enter. Excel moves down one cell. 8. Type 3 in cell B3. 9. Press Enter. Excel moves down one cell. 10. Type =B2-B3 in cell B4. |
| 11. Click the check mark on the Formula bar. Excel subtracts cell B3 from cell B2 and the result displays in cell B4. The formula displays on the Formula bar. |
| Multiplication |
| 1. Hold down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog box appears. 2. Type C1 in the Reference field. 3. Press Enter. Excel moves to cell C1 4. Type Multiply. 5. Press Enter. Excel moves down one cell. 6. Type 2 in cell C2. 7. Press Enter. Excel moves down one cell. 8. Type 3 in cell C3. 9. Press Enter. Excel moves down one cell. 10. Type =C2*C3 in cell C4. 11. Click the check mark on the Formula bar. Excel multiplies C1 by cell C2 and displays the result in cell C3. The formula displays on the Formula bar. |
| Division |
| 1. Press F5. 2. Type D1 in the Reference field. 3. Press Enter. Excel moves to cell D1. 4. Type Divide. 5. Press Enter. Excel moves down one cell. 6. Type 6 in cell D2. 7. Press Enter. Excel moves down one cell. 8. Type 3 in cell D3. 9. Press Enter. Excel moves down one cell. 10. Type =D2/D3 in cell D4. 11. Click the check mark on the Formula bar. Excel divides cell D2 by cell D3 and displays the result in cell D4. The formula displays on the Formula bar. |
| When creating formulas, you can mention cells and include numbers. All of the following formulas are valid: |
=A2/B2 =A1+12-B3 =A2*B2+12 =24+53 |
| AutoSum |
| The following illustrates AutoSum: |
 |
1. Go to cell F1. 2. Type 3. 3. Press Enter. Excel moves down one cell. 4. Type 3. 5. Press Enter. Excel moves down one cell. 6. Type 3. 7. Press Enter. Excel moves down one cell to cell F4. 8. Choose the Home tab. 9. Click the AutoSum button in the Editing group. |
 |
| 10. Press Enter. Excel adds cells F1 through F3 and displays the result in cell F4. |
| Combining the Arithmetic Operators |
| The basic operators you've just known can be combined to make more complex calculations. For example, you can add two cells together, and multiply by a third one. Like this: |
= A1 + A2 * A3 Or this: = A1 + A2 - A3 And even this: =SUM(A1:A9) * B1 |
| In the above formula, we're asking Excel 2007 to add up the numbers in the cells A1 to A9, and then multiply the answer by B1. You'll get some practice with combining the operators shortly. But there's something you need to be aware of called Operator Precedence. |
| Operator Precedence |
| Some of the operators you have just met are calculated before others. This is known as Operator Precedence. As an example, try this: |
| . Open a new Excel 2007 spreadsheet . In cell A1 enter 25 . In cell A2 enter 50 . In cell A3 enter 2 |
| Now click in cell A5 and enter the following formula: |
| =(A1 + A2) * A3 |
| Hit the enter key on your keyboard, and you'll see an answer of 150. |
| The thing to pay attention to here is the brackets. When you place brackets around cell references, you section these cells off. Excel 2007 will then work out the answer to your formula inside of the brackets, A1 + A2 in our formula. Once it has the answer to whatever is inside of your round brackets, it will move on and calculate the rest of your formula. For us, this was multiply by 3. So Excel is doing this: |
| . Add up the A1 and A2 in between the round brackets . Multiply that answer by A3 |
| Now try this: |
| . Click inside A5 where your formula is . Now click into the formula bar at the top . Delete the two round brackets . Hit the enter key on your keyboard |
| What answer did you get? The images below show the answers with brackets and without: |
Post a Comment