. Cell reference for all cells in rows 3 through 6 is represented a
Answers
Explanation:
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
Understanding these different types of cell references will help you work with formulas and save time (especially when copy-pasting formulas).
This Tutorial Covers:
What are Relative Cell References in Excel?
When to Use Relative Cell References in Excel?
What are Absolute Cell References in Excel?
What does the Dollar ($) sign do?
When to Use Absolute Cell References in Excel?
What are Mixed Cell References in Excel?
How to Change the Reference from Relative to Absolute (or Mixed)?
What are Relative Cell References in Excel?
Let me take a simple example to explain the concept of relative cell references in Excel.
Suppose I have a data set shown below:
Relative Cell References in Excel Spreadsheets - Data
To calculate the total for each item, we need to multiply the price of each item with the quantity of that item.
For the first item, the formula in cell D2 would be B2* C2 (as shown below):