Page 203 - CA 165 ver 1.0 Class 9
P. 203
Cell Address->F3
When absolute->$F$3
Drag the AutoFill
Tool over the
consecutive cells.
Formula in the cells will be
=F7/$F$3*100
=F8/$F$3*100
=F9/$F$3*100
=F10/$F$3*100
Relative Absolute
Reference Reference
The values will be displayed accordingly in respective cells.
Lab Assignment ‘n Activity Experiential Learning
Complete the following activities and tick on the circle.
ª What will be the value displayed in cell E2
after evaluation?
ª If the formula of the cell E2 is copied to E3
and E4, what will be the resultant formula
in both the cells?
OPERATOR
An operator is a symbol that performs certain mathematical or logical operations. In a cell, the
calculation takes place in the order of precedence of operators (in a similar way as BODMAS in
mathematics).
The table given in the next page shows the operators, their meaning and their order of execution.
When two operators share the same ranking or precedence, calculation is done in the order from left
to right.
Data Analysis 201

