Row and column fields in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the row number of cell A5.

Excel

=ROW([1])

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

AA1

BA5

C5

DB5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number instead of a cell reference inside ROW.

Leaving the parentheses empty.

The ROW function returns the row number of the given cell reference. Using A5 returns 5.

2fill in blank

medium

Complete the formula to get the column number of cell C3.

Excel

=COLUMN([1])

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

AC3

B3

CB3

DC1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number instead of a cell reference.

Using a cell from a different column.

The COLUMN function returns the column number of the given cell reference. C3 is in column 3.

3fill in blank

hard

Fix the error in the formula to get the row number of cell B10.

Excel

=ROW([1])

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

A10

B10B

CB10

DB

Attempts:

3 left

💡 Hint

Common Mistakes

Using only the row number without column letter.

Using invalid cell references like '10B'.

The ROW function requires a valid cell reference like B10. Just the number or column letter alone is invalid.

4fill in blank

hard

Fill both blanks to create a formula that returns the column number of cell in row 4 and column B.

Excel

=COLUMN([1][2])

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

AB

B4

CC

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of column letter and row number.

Using wrong column letters or row numbers.

Combining column letter B and row number 4 creates the cell reference B4. The COLUMN function then returns 2.

5fill in blank

hard

Fill both blanks to create a formula that returns the row number of the cell in column D and row 7.

Excel

=ROW([1][2])

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

AD

B7

DE

Attempts:

3 left

💡 Hint

Common Mistakes

Adding extra characters between column and row.

Using wrong column letters or row numbers.

The cell reference is formed by column letter D, no extra character (empty string), and row number 7, making D7. The ROW function returns 7.