Page 400 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Method 3: Mixed references
A Mixed cell reference is a mixture of both relative and absolute cell reference. In mixed cell reference,
dollar signs are attached to either the row letter or the column number.

• $A2 – Denote the column does not changed when copied
• A$2 – Denote the row does not changed when copied.

Step 1: Input the formula in the selected cell (E3) to compute the desired value. In this instance, the formula
will be = ($C3*$D3)($F$3), with $F$3 being specified as an absolute reference and $C3 and $D3 is the mixed
reference.

385
CITS : IT & ITES - Computer Software Application - Exercise 66 CITS : IT & ITES - Computer Software Application - Exercise 66