how is the cell referred
Answers
Answer:
A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. In the following example, a highlighted cell is shown in a Microsoft Excel spreadsheet. D8 (column D, row 8) is the highlighted cell. Any modifications made while this cell is highlighted will be limited to this item in the spreadsheet.
Here, D8 is the active cell. In the formula bar, you can see that the cell content is =SUM(D2:D5). This formula evaluates to the result of $162.00 by calculating the sum of the values stored in cells D2 through D5.
Each cell in a spreadsheet can contain any value that can be called using a relative cell reference or called upon using a formula. See our spreadsheet definition for further information on using spreadsheets.