First stage – College of Medicine – University of Mosul / Nineveh
Computer Science/
Lecture 4
Assistant Lecturer: Zina Abdul Salam
EXCEL 2013
1
:
s
Using Formulas and Functino
Formulas are used to perform calculation in work sheet.All Formulas
must begin with an equal sign(=). Formulas can consist of the following
elements:
1.Constsnt values(such as 5 or 100)
2.Cell refrences (such as A1 or A1:A3)
3.Operations (such as+ for addition or* for muliplication)
4.Functions(such as SUM or AVERAGE).
Using Operator in Formulas:
Operators are symboles that represent specific mathematical operation
excel formulas support a variety of operations (see table below).
Entering Simple Formulas:
To enter a formula
1. Select the cell in which you want to enter the formula.
2. Type an equal sign (=).
3. Enter the first value or cell reference.
4. Enter the desired operation.
5. Enter the next value or cell reference.
6. Repeat steps 4 and 5 as needed to complete the formula.
7. When finished, press the Enter key. The result of formula
appear in the cell.
First stage – College of Medicine – University of Mosul / Nineveh
Computer Science/
Lecture 4
Assistant Lecturer: Zina Abdul Salam
EXCEL 2013
2
Using the Auto Sum Button:
The Auto Sum button provides quick access to the most commonly used
functions.to sum number using the Auto Sum button:
1. Select a cell next to the number that you want to sum.
2. On Home tab, in the editing group, click the Auto Sum
button (see figure 39)
3. Do one of the following:
a. If the suggested range is correct, press the enter key to display the
result.
b. if the suggested range is incorrect, select the correct range, and
then press Enter key to display the result.
First stage – College of Medicine – University of Mosul / Nineveh
Computer Science/
Lecture 4
Assistant Lecturer: Zina Abdul Salam
EXCEL 2013
3
Insert Function:
To insert a function:
1. Select the cell in which you want to enter the formula.
2. On the Formula tab, in the function library group, click the Insert
Function button
.or click the insert function button on the Formula
bar.
3. In the Insert Function dialog box, search for a function or select a
category, select the desired function, and then click the OK button
.
4. In the function arguments dialog box, enter the functions arguments
and then click OK button to display the result.(see figure)
First stage – College of Medicine – University of Mosul / Nineveh
Computer Science/
Lecture 4
Assistant Lecturer: Zina Abdul Salam
EXCEL 2013
4
s:
k
Protecting Workboo
-
Password
To password-protect a workbook:
1. Open the workbook that you want to protect.
2. Click the File tab, click the protect workbook button, and then click
Encrypt with Password (see figure 48).
First stage – College of Medicine – University of Mosul / Nineveh
Computer Science/
Lecture 4
Assistant Lecturer: Zina Abdul Salam
EXCEL 2013
5
4. In the Encrypt Document dialog box, type a password in password
box, and then click the OK button (see figure49).
NOTE: password are case-sensitive. Lose or forgotten password cannot
be recover.
5.In the Confirm password dialog box, retype the password in the
Reenter password box, and then click the OK button ( see figure 50)
6. Save the workbook.