Page 181 - IT_V1.0_Class10
P. 181

Cell Referencing Using Keyboard

                 Total Sales of individual items must be automatically calculated and stored in Quarter Sales sheet through
                 cell referencing using keyboard.

                 To calculate Total Sales of Pen, i.e., to make the cell reference in cell B2:

                 Step 1:  Type the given formula in the cell B2 =SUM(January.B2;February.B2;March.B2)














                   1







                 Step 2:  Use Autofill to calculate the Quarter sales of rest of items.

                 Cell Referencing Using Mouse
                 Now, let us learn how to create cell referencing using mouse.


                 Step 1:  Type = sign in the Formula Bar.
                 Step 2:  Type the desired mathematical function. Here, SUM function is used, so we type =SUM(



















                            2









                 Step 3:  Select cell B3 from January sheet tab.

                 Step 4:  Type , (comma) after January.B3 in order to take more cells for referencing from different sheets.

                 Step 5:  Select similarly for cell B3 from February sheet tab.



                                                                                         Linking Spreadsheet Data   179
   176   177   178   179   180   181   182   183   184   185   186