Question

What will cell address of 5th row and 9th column

Answer 1

The Cell Address of the Cell formed by the Intersection of the fifth column and the Eight Row is E8...

Hope it's Helpful for you....☺☺☺☺☺

Answer 2

i5

first column is written by counting 9th position ABC I.e I. and last writing the number of row 9 in a cell address

Cell Value With the INDEX Function

We can get the value of a cell (its content) by using the INDEX Function.

The INDEX Function looks up a cell contained within a specified range and returns its value.

Cell Value With the INDIRECT Function

Another option for getting the value of a cell by its address is to use the INDIRECT Function.

Using Text Reference Within the INDIRECT Function

The INDIRECT Function changes a specified text string to a cell reference and returns its value.

Cell Value by Using INDIRECT and ADDRESS

The second way to get the value of a cell using the INDIRECT Function is to combine it with the ADDRESS Function.

#SPJ2

Click here to know more

https://brainly.in/question/4810906

https://brainly.in/question/18281512