A cell reference refers to the name or address of a specific cell or range of cells within the spreadsheet which is a combination of a column letter and a row number.
Each worksheet in Excel consists of several cells. Each cell has a specific cell reference which helps the users to find easily address the desired cell (s) within the functions. The address of a cell is defined by the letter (A to XFD) of the column and each number (1 to 1048576) represents a row in excel spreadsheet.
For example, A1 refers to the cell at the intersection of column A and row 1; B2 here B refers to the second cell in column And 1 refer to the first row.
A cell reference refers to a cell or a range of cells on a worksheet and can be used in MS Excel Function so that Microsoft Office Excel can find the values or data that you want.
What are the 3 types of cell references in Excel?
Now there are three kinds of cell references in excel that you can use in MS Excel:
1 Relative Cell References.
2 Absolute Cell References.
3 Mixed Cell References.
1 Relative Cell Reference
Relative cell references are useful when you have to create a formula for a range of cells and the formula needs to refer to a relative cell reference.
Now I want 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 you have to type B2* C2 (as shown below)
After it drag all item as shown below
