Page 216 - CA_165_V2.0_C9_Flipbook
P. 216
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
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?
Complete the following activities and tick on the circle:
ª What will be the value displayed in cell H2 after evaluation?
ª If the formula of the cell H2 is copied to H3 to H6, what will be the resultant
formula in all cells?
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 I3 is =H3/$B$1*100 and hence when copied to I4, it changes to
=H4/$B$1*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 I3 cell and put $ sign before column name of the address.
214 Touchpad Computer Applications (Ver. 2.0)-IX

