Selecting cells, rows, and columns in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to select cell B2 in Google Sheets.

Google Sheets

=INDIRECT("[1]")

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

AC3

BA1

CD4

DB2

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put the cell reference in quotes.

Using a wrong cell reference like A1 instead of B2.

The INDIRECT function takes a cell reference as text. To select cell B2, you write "B2" inside the quotes.

2fill in blank

medium

Complete the formula to select the entire row 3 in Google Sheets.

Google Sheets

=INDIRECT("[1]")

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

A3:3

BA3

C3

DA:A

Attempts:

3 left

💡 Hint

Common Mistakes

Using a single number without colon.

Using a cell reference like A3 instead of a row range.

To select an entire row, use the format "row:row" inside quotes. For row 3, it is "3:3".

3fill in blank

hard

Fix the error in the formula to select column D in Google Sheets.

Google Sheets

=INDIRECT("[1]")

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

A4:4

BD

CD:D

DD4

Attempts:

3 left

💡 Hint

Common Mistakes

Using just "D" without colon.

Using a row range like "4:4" instead of a column range.

To select an entire column, use the format "column:column" inside quotes. For column D, it is "D:D".

4fill in blank

hard

Fill both blanks to select cells from B2 to D4 in Google Sheets.

Google Sheets

=INDIRECT("[1]:[2]")

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

AB2

BD4

CA1

DC3

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the start and end cells.

Using cells outside the intended range.

To select a range of cells, write the start cell and end cell separated by a colon inside quotes. Here, from B2 to D4 is "B2:D4".

5fill in blank

hard

Fill both blanks to select cells from column A, rows 1 to 5 in Google Sheets.

Google Sheets

=INDIRECT("[1]:[2]")

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

AA1

BA5

CB1

DB5

Attempts:

3 left

💡 Hint

Common Mistakes

Using cells from different columns.

Swapping the start and end cells.

To select cells in column A from row 1 to 5, write "A1:A5" inside quotes.