Page 206 - Trackpad 402_Class-X_Final
P. 206
In FIRST QUARTER SUMMARY sheet, we need to add the total amount received by adding the total pocket
money received in the month of January, February, March and April and stored in the respective sheets.
Step 2: Click on cell C4 and place an “=” sign in FIRST QUARTER SUMMARY sheet.
Step 3: Click on the sheet tab JAN and click cell C4.
Step 4: Again click on the sheet tab FIRST QUARTER SUMMARY. You will see the cell reference as shown below.
Step 5: Type the + sign.
Step 6: Similarly, add sheet references of FEB, MAR, and APR sheets. Now the cell reference in the formula given in
sheet FIRST QUARTER SUMMARY will be:
Step 7: Press the ENTER key to see the TOTAL AMOUNT RECIEVED displayed as a total of all four months i.e. 4000.
As shown below:
206 Trackpad Information Technology-X

