Page 180 - IT_V1.0_Class10
P. 180

Creating Cell Reference to other Sheets

              To create a reference for a cell or range of cells to another sheet in the same spreadsheet, write the name of
              sheet followed by a dot mark (.) before the cell address.
              In other words, for creating cell reference to another sheet, following format can be used:

              Reference to an Individual Cell
              Syntax: $Sheet_name.Cell_address
              Example: To refer to cell A1 in Sheet2, type $Sheet2.A1

              Reference to a Range of Cells

              Syntax: $Sheet_name.First_cell:Last_cell
              Example: To refer to cells A1:A10 in Sheet2, type $Sheet2.A1:A10
              For example, the sheet function named AVERAGE calculates the average value for the range B1:B10 created
              on the sheet named Marketing in the same spreadsheet.

                                                                   1         2


                                                  =AVERAGE($Marketing.B1:B10)
                                                                         3
              Here,
              1. Sheet name is Marketing

              2.  Range of cells between B1 to B10, inclusive of ends.
              3.  Dot(.) Separates the sheet reference from the cell range reference.
                         Notes


                        If the sheet name includes spaces or non-alphabetical characters, it must be enclosed in single quotation
                        marks. For example, a cell reference to cell A1 in a sheet named January Sales should be written in this
                        format: $’January Sales’.A1


              Ways to Create Cell Referencing to Other Sheets
              There are two ways to create cell reference to other sheets:
                By entering the formula directly using the keyboard
                By using the mouse

              Details about Sales of Stationery Items for the months of January, February and March are maintained in
              different sheets.
              Sales in January Month        Sales in February Month     Sales in March Month












              A new sheet is inserted and renamed as Quarter Sales to store the Total Sales of each item.






                178     Information Technology Play (Ver 1.0)-X
   175   176   177   178   179   180   181   182   183   184   185