Page 215 - CA_165_V2.0_C9_Flipbook
P. 215

In the given worksheet; the maximum marks of each subject i.e., English, Hindi, Maths, Science, Computer,
                 and Social Science is 100 as entered in the cells C3, D3, E3, F3, G3, H3, respectively. To find total of max.
                 marks, let’s apply the formula =$C$2+$D$2+$E$2+$F$2+$G$2+$H$2 in the cell F6; whose computed
                 value will be 600.






























                 To apply absolute reference to other cells i.e., I5 to I8: Drag the AutoFill Handle tool over the cells I5
                 to I8 where the formula is to be applied.





























                                                            Formula in the
                                                             cells will be   =$C$2+$D$2+$E$2+$F$2+$G$2+$H$2

                 When the formula is copied to other cells i.e., I5 to I8, the absolute reference  i.e., the formula with
                 address of the cell will not change and value will remain as 600 which will be automatically displayed
                 in respective cells.








                                                                                                Data Analysis    213
   210   211   212   213   214   215   216   217   218   219   220