Qstnid -C-1-explain The Concept Of Cell Referencing Alongwith Its Various Types. - 11: Ms-excel 2007 - Cbse-ix-foundation Percent 20of%20information%20technology%20.

Home Learn Fast select Course

Show Unit/Chapter Change Unit Change Subject Last Menu

CBSE-IX-Foundation percent 20of%20Information%20Technology%20.

11: MS-Excel 2007

digibest Free NCERT Solutions with no signup needed page 3

Qstn# C-1 Prvs-Qstn Next-Qstn

#1
Explain the concept of cell referencing alongwith its various types.
Ans :
Excel supports three types of cell referencing, which are as follows:

Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a row. As the example illustrated here shows, when the formula is entered (= B4 — C4) in Cell D4 then this formula copied in D5 then it will change into (= B5 — C5) related to cell.

Absolute An absolute cell reference is fixed. Absolute references do not change if you copy a formula from one cell to another. Absolute references have dollar sign ($) like $S$9. As the shows, when the formula =C4*$D$9 is copied from row, the absolute cell reference remains as $D$9. ‘

Mixed A mixed cell reference has either an absolute column and a relative row, or an absolute row and a relative column, e.g. $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes.