Which of the following statement related to Cell Reference is Incorrect?) (Cell Reference is the address of cell.)। (These are used in the formula and functions) (There is only one way to write the cell reference in Excel.) (None of these)
Answers
Answered by
5
The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula.
As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, or vice versa. We can use the function to address the first cell or last cell in a range.
Similar questions