Question -3 What are various types of graphs available in MS-Excel? Explain the steps for creating a graph in a worksheet? Differentiate between mixed cell referencing and absolute cell referencing by giving suitable examples.
Answers
Answered by
0
Answer:
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
Explanation:
Similar questions