what is cell address?in how many ways a cell address can be given?

1.	what is cell address?in how many ways a cell address can be given?
Answer» <p>Ans :- The cell ADDRESS function is categorized underLookup and Reference functions. It will provide a cell reference (it’s “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.</p><p>As afinancial analyst, cell ADDRESS can be used to convert a column number to a letter, and vice versa. We can use the function to address the first cell or last cell in a range.</p><p>Formula</p><p>=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])</p><p>The formula uses the following arguments:</p><p>Row_num(required argument) – It is a numeric value specifying the row number to be used in the cell reference.</p><p>Column_num(required argument) – It is a numeric value specifying the column number to be used in the cell reference.</p><p>Abs_num(optional argument) – It is a numeric value specifying the type of reference to return:</p>

Discussion