what is ment by cell reference in excel?
Answers
Answered by
6
Each cell in the worksheet has a unique address formed by the combination of its intersection of row and column. when a cell address is referred to in a formula, it is called cell reference.
Answered by
0
Cell reference refers to a cell or a range of cells on a worksheet of MS Excel. It can be used to copy the formula of one cell to others, find the total of the numbers in all the selected cells, etc.
Examples: A1:D5 - this cell reference means that all the cells between A1 and D5 will be selected. The selected cells will be A1, A2, A3, A4, A5, B1, B2, B3, B4, B5, C1, C2, C3, C4, C5, D1, D2, D3, D4, and D5.
Examples: A1:D5 - this cell reference means that all the cells between A1 and D5 will be selected. The selected cells will be A1, A2, A3, A4, A5, B1, B2, B3, B4, B5, C1, C2, C3, C4, C5, D1, D2, D3, D4, and D5.
kallabalal:
NO..... COMMENTS SECTION IS NOT THIS
Similar questions
English,
6 months ago
Science,
6 months ago
Math,
6 months ago
Biology,
1 year ago
Chemistry,
1 year ago
Environmental Sciences,
1 year ago
Environmental Sciences,
1 year ago