Page 398 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Method 2: Absolute references
Excel Absolute Reference refers to a’ locked’ reference so that the address of its corresponding row and column
does not change when copied.

• $A$2 –Denote the column and the row do not changed when copied
In the example below, we’re going to use cell E3 (which contains the Interest rate at 12%) to calculate the interest
for each item.

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.

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