Taher Magdy
T.A of Computer Science FIT-Arish
[Link]
@Sinaiunieg info@[Link] [Link]
Faculty of Pharmacy – Al-Arish Branch
Information Technology
(INT 1001)
Introduction to Computer Science
(ITC E01)
Lecture (10) [Microsoft Office Excel
Con’t]
@Sinaiunieg info@[Link] [Link]
@Sinaiunieg info@[Link] [Link]
Formulas
1- Sum the values in cells, columns, or rows
Add the values in a column or row by using a button
1. Click an empty cell below a column of numbers or to the
right of a row of numbers, and then click AutoSum.
2. Excel selects what it determines to be the most likely
range of data.
3. press ENTER to accept or select your own range and then
ENTER
15
@Sinaiunieg info@[Link] [Link]
Formulas
2- Maximum value in cells, columns, or rows
Add the maximum value in a column or row by using a button
1. Click an empty cell below a column of numbers or to the
right of a row of numbers, and then click arrow below
AutoSum, and select MAX.
2. Excel selects what it determines to be the most likely
range of data.
3. press ENTER to accept or select your own range and then
ENTER
15
@Sinaiunieg info@[Link] [Link]
Formulas
3- Minimum value in cells, columns, or rows
Add the minimum value in a column or row by using a button
1. Click an empty cell below a column of numbers or to the
right of a row of numbers, and then click arrow below
AutoSum, and select MIN.
2. Excel selects what it determines to be the most likely
range of data.
3. press ENTER to accept or select your own range and then
ENTER
15
@Sinaiunieg info@[Link] [Link]
Formulas
4- Average value in cells, columns, or rows
Add the average value in a column or row by using a button
1. Click an empty cell below a column of numbers or to the
right of a row of numbers, and then click arrow below
AutoSum, and select Average.
2. Excel selects what it determines to be the most likely
range of data.
3. Press ENTER to accept or select your own range and then
ENTER
15
@Sinaiunieg info@[Link] [Link]
Formulas
5- Conditional Formula
General formal
= if(logical_test, value_if_true, value_if _alse)
1. logical_test The condition that you want to check.
2. value_if_true: The value to return if the condition is True.
3. value_if_false: The value to return if the condition is
False.
15
@Sinaiunieg info@[Link] [Link]
Formulas
5- Conditional Formula
Add conditional formula in a row or column
1. Click an empty cell below a column of numbers or to the
right of a row of numbers, and then click arrow below
Logical, and select IF.
15
@Sinaiunieg info@[Link] [Link]
Formulas
5- Conditional Formula
Add conditional formula in a row or column
2. The following dialog appear, write
3. Logical test
4. Value if true
5. Value if false
6. And click OK
15
@Sinaiunieg info@[Link] [Link]
Charts
The elements of a chart
1. The chart area of the chart.
2. The plot area of the chart.
3. The data points of the data
series that are plotted in the chart.
4. The horizontal (category) and vertical (value) axis along which the
data is plotted in the chart
5. The legend of the chart
6. A chart and axis title that you can use in the chart.
7. A data label that you can use to identify the details of a data point in a
16
data series
@Sinaiunieg info@[Link] [Link]
Create new chart
Charts
1. Select the cells that contain the data that you want to use
for the chart.
2. On the Insert tab, in the Charts group ,click the chart type,
and then click a chart subtype that you want to use.
16
@Sinaiunieg info@[Link] [Link]
Format Chart
Charts
1. Select the chart you want to format.
2. On the Layout tab, in the Labels group ,you can format:
Add title to chart Align legend Show the table
with the chart
Add title to axis Show data on the
columns chart
3. On the design tab, in the group Data, you can switch
16
between row and column
@Sinaiunieg info@[Link] [Link]
Revision
To insert new worksheet quickly you can click on the tab ……..
a) insert b) Home c) insert worksheet d) formula
To write any operation in the cell you must start the operation with……
a) star b) equal c) plus d) slash
To write series of numbers using fill handle you must select …….
a) all columns b) all cells c) 2 cells d) one cell
To block any rows and columns you use freeze panes command from….
a) home tab b) view tab c) review tab
To hide the formula in formula bar you must do two operations ……….
23
a) copy and cut b) copy and past c) hidden and protect d) hidden and format
@Sinaiunieg info@[Link] [Link]