Page 399 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Step 2: Press Enter on your keyboard. The formula will calculate, and the result will display in the cell.

Step 3: Click and drag the fill handle across the cells where you intend to replicate the formula. Once you release
the mouse, the formula will be copied to the designated cells, retaining the absolute reference, and the values will
be automatically calculated in each corresponding cell.

Double-click the filled cells to check their formulas for accuracy. The absolute reference should be the same for
each cell, while the other references are relative to the cell’s row.

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