Page 202 - CA 165 ver 1.0 Class 9
P. 202
Lab Assignment ‘n Activity Experiential Learning
Complete the following activities and tick on the circle.
ª Consider the given worksheet:
What will be the value displayed in cell B5 after evaluation?
If the formula of the cell B5 is copied to C5, then what will be the resultant formula?
ª Apply Absolute cell referencing to calculate the Total price of books in the worksheet:
Include 8% GST on the total price.
Mixed Referencing
This type of cell referencing is the combination of absolute and relative referencing. While applying
mixed referencing, either the row number or the column name of the cell address in the formula is
fixed. The cell references such as $F5 or F$5 are examples of mixed referencing. $F5 means that the
column F is absolute and row 5 is relative while F$5 means that the column F is relative and row 5 is
absolute.
Consider the given worksheet:
Assume that the formula of cell G6 is =F6/$F$3*100 and hence when copied to G7, it changes to
=F7/$F$3*100. As it is mixed cell referencing, only the relative part of it gets updated and the rest
remains absolute. To apply mixed reference,
l Type the formula in G6 cell and put $ sign before column name of the address.
200 Touchpad Computer Applications-IX

