Question

Give the cell address or range reference in the following situations.

1. Cell at 10^th column and 6^th row. 

2. Cell at 27^th column and 15^th row. 

3. Range starting from 5^th column, 9^th row and spread till 12^th column and 15^th row

Answer 1

1. Cell at 10^th column and 6^th row = J6. 

2. Cell at 27^th column and 15^th row = AA15. 

3. Range starting from 5^th column, 9^th row and spread till 12^th column and 15^th row = E9: L15.