آموزش کامل Excel 2007 - EN

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=3]Edit a Cell
After you enter data into a cell, you can edit the data by pressing F2 while

you are in the cell you wish to edit
.

[h=4]
[h=4]

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=4]EXERCISE 5
[h=4]Edit a Cell

Change "John" to "Jones."

1. Move to cell A1.
2. Press F2.
3. Use the Backspace key to delete the "n" and the "h."
4. Type nes.
5. Press Enter.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=4]Alternate Method: Editing a Cell by Using the Formula Bar
You can also edit the cell by using the Formula bar. You change "Jones" to "Joker" in the following exercise.

​

1. Move the cursor to cell A1.
2. Click in the formula area of the Formula bar.

​

1. Use the backspace key to erase the "s," "e," and "n."
2. Type ker.
3. Press Enter.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=4]Alternate Method: Edit a Cell by Double-Clicking in the Cell
You can change "Joker" to "Johnson" as follows:

​

1. Move to cell A1.
2. Double-click in cell A1.
3. Press the End key. Your cursor is now at the end of your text.

​

1. Use the Backspace key to erase "r," "e," and "k."
2. Type hnson.
3. Press Enter.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=4]Change a Cell Entry

Typing in a cell replaces the old cell entry with the new information you type.

1. Move the cursor to cell A1.
2. Type Cathy.
3. Press Enter. The name "Cathy" replaces "Johnson."

​

[h=3]



​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=3]Wrap Text
When you type text that is too long to fit in the cell, the text overlaps the next cell. If

you do not want it to overlap the next cell, you can wrap the text.



​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=4]EXERCISE 6


[h=4]Wrap Text

​

1. Move to cell A2.
2. Type Text too long to fit.
3. Press Enter.

​

1. Return to cell A2.
2. Choose the Home tab.
3. Click the Wrap Text button
   
   . Excel wraps the text in the cell.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=3]Delete a Cell Entry

To delete an entry in a cell or a group of cells, you place the

cursor in the cell or select the group of cells and press Delete.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers
​

[h=4]EXERCISE 7

[h=4]Delete a Cell Entry

1. Select cells A1 to A2.
2. Press the Delete key.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=3]Save a File
This is the end of Lesson1. To save your file:

1. Click the Office button. A menu appears.
2. Click Save. The Save As dialog box appears.
3. Go to the directory in which you want to save your file.
4. Type Lesson1 in the File Name field.
5. Click Save. Excel saves your file.

​

 

[A M I R]

Lesson 1: Entering Text and Numbers

​

[h=3]Close Excel

Close Microsoft Excel.

1. Click the Office button. A menu appears.
2. Click Close. Excel closes.

​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and

how to enter data. A major strength of Excel is that you can perform mathematical calculations and format

your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text

and numerical data. To start this lesson, open Excel.



​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

Set the Enter Key Direction

In Microsoft Excel, you can specify the direction the cursor moves when you press the Enter key. In

the exercises that follow, the cursor must move down one cell when you press Enter. You can use

the Direction box in the Excel Options pane to set the cursor to move up, down, left, right, or not at

all. Perform the steps that follow to set the cursor to move down when you press the Enter key.

​

1. Click the Microsoft Office button. A menu appears.
2. Click Excel Options in the lower-right corner. The Excel Options pane appears.

​

1. Click Advanced.
2. If the check box next to After Pressing Enter Move Selection is not checked, click the box to check it.
3. If Down does not appear in the Direction box, click the down arrow next to the Direction box and then click Down.
4. Click OK. Excel sets the Enter direction to down.

​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=3]Perform Mathematical Calculations
In Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you

enter a number or a formula, you can reference the cell when you perform mathematical calculations

such as addition, subtraction, multiplication, or division. When entering a mathematical formula, precede

the formula with an equal sign. Use the following to indicate the type of calculation you wish to perform:


+ Addition
- Subtraction
* Multiplication
/ Division
^ Exponential



In the following exercises, you practice some of the methods you can use to move around a

worksheet and you learn how to perform mathematical calculations. Refer to Lesson 1 to

learn more about moving around a worksheet.


​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=4]EXERCISE 1


[h=4]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.



​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=4]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.

​

1. Type Subtract.
2. Press Enter. Excel moves down one cell.
3. Type 6 in cell B2.
4. Press Enter. Excel moves down one cell.
5. Type 3 in cell B3.
6. Press Enter. Excel moves down one cell.
7. Type =B2-B3 in cell B4.
8. 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.

​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=4]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.

​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=4]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 reference cells and include numbers. All of the following formulas are valid:


=A2/B2​

=A1+12-B3​

=A2*B2+12​

=24+53

​

​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=3]AutoSum


You can use the AutoSum button

on the Home tab to automatically add a column or row of numbers. When you

press the AutoSum button

, Excel selects the numbers it thinks you want to add. If you then click the check mark

on the Formula bar or press the Enter key, Excel adds the numbers. If Excel's guess as to which numbers you want

to add is wrong, you can select the cells you want.





​

 

[A M I R]

Lesson 2: Entering Excel Formulas and Formatting Data

​

[h=4]EXERCISE 2


[h=4]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. Excel selects cells F1 through F3 and enters a formula in cell F4.

​

1. Press Enter. Excel adds cells F1 through F3 and displays the result in cell F4.

​