InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
To make a cell address absolute, add a # sign before the row andcolumn address of the cell in the formula.beguitable word and finhebe |
|
Answer» 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 |
|