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
   240   241   242   243   244   245   246   247   248   249   250