Page 28 - Computer Genius Class 06
P. 28

Absolute References

                  If you wish to maintain the original references as they were, then you should make use of the absolute
                  re erences.    you  ant to ma e the  ormula retain the original re erence  hen it is copied  then you
                  should precede the column re erence and the ro  re erence  ith a  ollar     sym ol.

                  For e ample  i  you  ant to gi e a discount o  1   on each product  then the discount  ill remain the
                  same  or all the products. To calculate the amount to  e paid  you should add the  ollar     sign to
                  the cell that contains the discount percentage.  n this case  the discount percentage is gi en in cell
                    .  ence  the  ormula  ill  e                            .
                   hen you copy the  ormula to the ne t cell  the address o  the cell     ill remain the same as sho n






















                  Mixed References

                    mi ed re erence is a re erence that re ers to a specific ro  or column.  t is  asically a com ination
                  o  relati e and a solute re erences.  n some situations  you may need to ma e the cell re erence as a
                    i ed  re erence so that you can loc  either a column or a ro   y preceding it  ith a  ollar     sym ol.
                  For e ample    1 or   1.

                                                                 Notes

                                   Pressing the F4 key repeatedly over a reference cell name in the
                                    formula allows you to make the reference a relative reference,
                                  a solute re erence or mi ed re erence  y s itching  et een them.


                  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  or sheet.
                  For e ample  to enter a re erence to cell A2 in Sheet2 into cell A1 in Sheet1, follow the given steps:
                   Step 1   Select cell A1 in Sheet1, and type an equal (=) sign.

                   Step 2   Click the Sheet2 ta .
                   Step 3    Click cell A2, and then press the Enter  ey.  hen you press the Enter key, Sheet1 is now
                            acti e.
                   Step 4   Select cell A1, and you will see that it contains the formula = Sheet2!A2.


                       26    Computer Genius-VI
   23   24   25   26   27   28   29   30   31   32   33