Question

What do you mean by cell address? Give two examples. *


​

Answer 1

Answer:

Cell address is the specification of a cell. For example:If row 3 is intersected by a column F, then the cell formed is referred as F3.

Explanation:

Answer 2

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

For example, =ADDRESS(1,1) returns $A$1. ADDRESS can return an address in relative or absolute format, and can be used to construct a cell reference inside a formula. A cell address in the current or given worksheet. row_num - The row number to use in the cell address.