Page 42 - Plus_V2.2_C6_Flipbook
P. 42

For example, let's have a look at an example, there are 6 trainers: Lucky, Madhumanti, Deepak,
                  Debojeet, Ujjwal and Rohit. They have different amount of shuttlecocks each in their shop cart. The
                  price per shuttlecok is 2 coins. Help the Badminton trainers to calculate prices for shuttlecock. Follow
                  the steps to do Absolute referencing. The price's reference is B10, we do not want the fill function to
                  change this, so we lock it.
                  The reference is absolutely locked by using the formula $B$10
                  Now,type C2(=) then select B11, after that type ($) before the B and 10 ($B$10), now type (*) and then
                  select B2. Finally hit the enter button to calculate the cost of shuttlecocks.
























                                                        Using Absolute Referencing

                       Mixed References

                  A mixed reference is a reference that refers to a specific row or column. It is basically a combination of
                  relative and absolute references. In some situations, you may need to make the cell reference as ‘Mixed’
                  reference, so that you can lock either a column or a row by preceding it with a Dollar ($) symbol.
                  For example, $A1 or A$1.




















                                                        Using Mixed Referencing


                        REFERENCES TO OTHER WORKSHEETS

                  You can refer to cells in other worksheets within the same workbook just as easily as you refer to cells
                  in the same worksheet.

                  40    Premium Edition-VI
   37   38   39   40   41   42   43   44   45   46   47