Page 407 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Step 2: Write the Formula
In cell R3C3, enter the following formula using R1C1 notation:

This formula instructs Excel to sum the value in the cell two columns to the
left (column A ie, C[-2]) from the current cell(R3C3) and the value in the
cell one column to the left (column Bie, C[-1])).

R3C3= RC[-2]+RC[-1]
Step 3: Press Enter
Press Enter to execute the formula. Excel will calculate the sum and
display the result in cell R3C3.

Step 4:
Drag down from R3C3:R7C3 to obtain the result.
Result:

392
CITS : IT & ITES - Computer Software Application - Exercise 67