INDEX function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the value from the 2nd row and 3rd column of the range A1:D5.

Excel

=INDEX(A1:D5, [1], 3)

Drag options to blanks, or click blank then click option'

A3

B2

C1

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using the column number instead of the row number in the second argument.

Confusing row and column positions.

The INDEX function returns the value at the intersection of the specified row and column. Here, the row is 2 and the column is 3.

2fill in blank

medium

Complete the formula to get the value from the 4th row and 1st column of the range B2:E6.

Excel

=INDEX(B2:E6, [1], 1)

Drag options to blanks, or click blank then click option'

A3

B2

C4

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using the absolute row number from the sheet instead of relative to the range.

Mixing up row and column numbers.

The INDEX function uses the row number as the second argument. Here, 4 means the 4th row in the range.

3fill in blank

hard

Fix the error in the formula to correctly return the value from the 3rd row and 2nd column of range C1:F4.

Excel

=INDEX(C1:F4, [1], 2)

Drag options to blanks, or click blank then click option'

A4

B1

C2

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using a row number outside the range's size.

Confusing row and column arguments.

The row argument should be 3 to get the 3rd row in the range. Using 4 or 2 would give wrong or error results.

4fill in blank

hard

Fill both blanks to get the value from the 1st row and 4th column of the range D3:G7.

Excel

=INDEX(D3:G7, [1], [2])

Drag options to blanks, or click blank then click option'

A1

B2

C4

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using sheet row or column numbers instead of relative to the range.

Swapping row and column numbers.

The first blank is the row number (1), and the second blank is the column number (4) within the range.

5fill in blank

hard

Fill all three blanks to get the value from the 2nd row and 3rd column of the range A2:D6 using INDEX with the optional area_num argument set to 1.

Excel

=INDEX((A2:D6, E2:H6), [1], [2], [3])

Drag options to blanks, or click blank then click option'

A2

B3

C1

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to specify the area number when using multiple ranges.

Mixing up row and column numbers.

The first blank is the row number (2), the second is the column number (3), and the third is the area number (1) to select the first range.