Page 217 - CA_165_V2.0_C9_Flipbook
P. 217
Cell Address->B1
When absolute->$B$1
Drag the AutoFill
Tool over the
consecutive cells.
Formula in the =H4/$B$1*100
cells will be
=H5/$B$1*100
=H6/$B$1*100
=H7/$B$1*100
Relative Absolute
Reference Reference
The values will be displayed accordingly in respective cells.
Lab Assignment ‘n Activity Century #Technology Literacy
21 st
Skills
Complete the following activities and tick on the circle:
ª Apply Absolute cell referencing to calculate the Total price of books in the worksheet:
Include 8% GST on the total price.
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 215

