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

