T
TKT-Tang
Re – Excel INDEX WorkSheet Function
1. Enter the following text strings into the Range A1:A5 of an Excel
spreadsheet respectively :-
2. A1 = "A"
3. A2 = "AB"
4. A3 = "ABC"
5. A4 = "ABCD"
6. A5 = "ABCDE"
7. Enter into the cell B1 a formula, =Index(A$1:A$5,0) ; it shows "A".
8. Enter into the cell B2 a formula, =Index(A$1:A$5,1) ; it shows "A"
as well.
9. Please explain the validity of the formula entered into cell B1,
=Index(A$1:A$5,0) ; it shows "A".
10. Regards.
1. Enter the following text strings into the Range A1:A5 of an Excel
spreadsheet respectively :-
2. A1 = "A"
3. A2 = "AB"
4. A3 = "ABC"
5. A4 = "ABCD"
6. A5 = "ABCDE"
7. Enter into the cell B1 a formula, =Index(A$1:A$5,0) ; it shows "A".
8. Enter into the cell B2 a formula, =Index(A$1:A$5,1) ; it shows "A"
as well.
9. Please explain the validity of the formula entered into cell B1,
=Index(A$1:A$5,0) ; it shows "A".
10. Regards.