Page 245 - TP_IT_V1.0_C10_flipbpookl
P. 245
Step 6: Similarly, add sheet references of Feb and Mar sheets. Now the cell reference in the formula given in Quarterly
Sales sheet will be:
Step 7: Press the Enter key to see the total quarterly sales i.e. 37, as shown below:
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 sheet where we are calculating the quarterly sales or products. We already
calculated the total quarterly sales of the laptop using mouse. Now, we will calculate the total quarterly sales of the
Monitor using keyboard by following the given steps:
Step 1: Click on cell B4 in the Quarterly Sales sheet in the Sheet tab.
Step 2: Type the following formula =$JAN.B4+$FEB.B4+$MAR.B4.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 243

