Page 252 - IT_Play_V1.0 Class9
P. 252
For example, a formula in cell D2 contains the formula =A2*B2-$C$2. Here, $C$2 is an absolute reference
to the discount rate. This means that when you copy the formula from one cell to another, the reference
to $C$2 remains constant, ensuring that all calculations use the same discount rate. When copying the
formula from D2 to D3, the formula will update to =A3 * B3 - $C$2. The row numbers change from A2 to
A3 and from B2 to B3, while $C$2 remains fixed.
MIXED REFERENCING
Mixed referencing is a type of cell referencing where either the row or the column is fixed, but not both. This
allows you to control one part of the reference while letting the other part change when the formula is copied
to other cells.
For example, a formula in cell D2 contains the formula =$A2*$B2-$C$2.The column ($A and $B) is
absolute which means that as you copy the formula across columns, the reference to columns A and B
will not change. When copying the formula from D2 to D3, the formula will update to =$A3 * $B3 - $C$2,
reflecting the change in row number while keeping the column references fixed.
Recap Zone
Relative referencing is the default type in LibreOffice Calc, meaning that when a formula is copied
from one cell to another, the cell references adjust according to their relative position.
Absolute referencing keeps a specific cell reference fixed, regardless of where the formula is copied,
by using a dollar sign ($) before both the column letter and the row number, such as in the cell
address $A$1.
Mixed referencing is a type of cell referencing where either the row or the column is fixed, allowing
one part of the reference to remain constant while the other changes when the formula is copied.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. Which of these formulas uses mixed referencing?
i. =$A2*B$2 ii. =A1*B1 iii. =$C$1*$D$2 iv. =$A$1*$B$2
250 Information Technology Play (Ver 1.0)-IX

