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

