Page 28 - Viva ICSE Computer Studies 8 : E-book

Mixed Reference

Mixed reference is a combination of relative
reference and absolute reference. In this type,
either the row or column has to remain fixed.
$B4 is an example of mixed reference.

Step 2
Follow these steps to use mixed reference.
1. Enter the data as shown.
2. Click on the cell D2 and type = $B2 C$2. Step 1
*
Press the Enter key.

3. Now copy by dragging the mouse pointer
to the remaining cells.

Step 3

Circular Reference

When a formula in a cell refers to its own cell value, it is called circular reference.

Follow these steps to use circular reference.
1. Enter the data as shown in cell ‘A1’.

2. In ‘cell A2’, type the formula = A1 + A2 5. You
*
are typing the formula to refer to its own cell
value. Step 1
3. A warning is shown in the dialog box. As you
Step 2
click on the OK button of the dialog box, ‘0’
will be returned in the cell containing the
formula. In this case, it is ‘A2’.

Step 3

Step 3

16