Question

Use referencing and show it's types ( relative,mixed,absolute ) in a worksheet representing particular data.

Answer 1

Answer:

Explanation:A worksheet in Excel is made up of cells. These cells can be referenced by specifying the row value and the column value.

For example, A1 would refer to the first row (specified as 1) and the first column (specified as A). Similarly, B3 would be the third row and second column.

The power of Excel lies in the fact that you can use these cell references in other cells when creating formulas.

Now there are three kinds of cell references that you can use in Excel:

Relative Cell References

Absolute Cell References

Mixed Cell References