Page 181 - IT 402 v2.0 class 10
P. 181

Cell Referencing Using Mouse

            Now  let us learn how to create cell referencing using mouse.

            Step 1:  Select the cell      in the current worksheet  i.e.    uarter Sales .
            Step 2:   ype     sign in the Formula  ar.
            Step 3:  Select the desired mathematical function from the Formula  ar.  ere  S M is selected.






                                                                                       2






                                              3


















            Step 4:   lick on the   anuary  worksheet tab  then select the cell     .
            Step 5:   ype     after   anuary.    in order to take more cells for referencing from different worksheets.

            Step 6:  Now  click on the  February  worksheet tab  then select the cell     .

            Step 7:   Repeat for 'March' worksheet.






                  Accept Button



























                                                                       Advanced Features of Spreadsheet        179
   176   177   178   179   180   181   182   183   184   185   186