Question

To make a cell address absolute, add a # sign before the row and
column address of the cell in the formula.
beguitable word and finhebe​

Answer 1

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