Question

G. Give examples for the following
1 Cell address
2. Mathematical functions
3. Absolute cell address
l Statistical functions
5. Relative cell address​

Answer 1

Answer:

The Excel ADDRESS function returns the address for a cell based on a given row and column number. 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.