Page 207 - Trackpad 402_Class-X_Final
P. 207
Adding a Cell Reference Using a Keyboard
Now let us do the same concept using a keyboard. Whenever we are using a keyboard to give cell reference then there
is no need to switch between the sheet tab. Just place your cursor in the required cell and type the formula containing
the cell reference.
Let us take the example of the above worksheet where we are calculating the pocket money saved and spent in the
first quarter. We already calculated the TOTAL AMOUNT RECEIVED using the mouse. Now we will calculate the TOTAL
AMOUNT SPEND using the keyboard by following the given steps:
Step 1: Go to sheet FIRST QUARTER SUMMARY. Click on cell C5.
Step 2: Type the following formula =JAN.C5+FEB.C5+MAR.C5+APR.C5
Step 3: Press the Enter key to see the TOTAL AMOUNT SPEND displayed as a total of all four months i.e. 3000. as shown
below:
Electronic Spreadsheet (Advanced) 207

