Selecting cells, rows, and columns in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select cell A1 in Excel.

Excel

Range("[1]")

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

AB2

BA1

CC3

DD4

Attempts:

3 left

💡 Hint

Common Mistakes

Using a row number only like "1" instead of "A1".

Using a column letter only like "A" instead of "A1".

To select a single cell, use its address like "A1" inside the Range function.

2fill in blank

medium

Complete the code to select the entire row 3 in Excel.

Excel

Rows([1])

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

A4

B2

C3

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a number as a string like "3" instead of 3.

Using a column letter instead of a row number.

To select a whole row, use the row number as a number inside Rows(). For row 3, use 3.

3fill in blank

hard

Fix the error in the code to select column B in Excel.

Excel

Columns([1])

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

A2

B"B"

CB

Attempts:

3 left

💡 Hint

Common Mistakes

Using the column letter "B" instead of the column number.

Using the number 2 as a string.

Columns() expects the column number as a number, so use 2 for column B.

4fill in blank

hard

Fill both blanks to select cells from A1 to C3 in Excel.

Excel

Range("[1]:[2]")

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

AA1

BB2

CC3

DD4

Attempts:

3 left

💡 Hint

Common Mistakes

Using cells that do not form a proper rectangle.

Swapping the start and end cells.

To select a range, use the start cell and end cell separated by a colon. Here, from A1 to C3.

5fill in blank

hard

Fill all three blanks to select cells from B2 to D4 and then select row 5 in Excel.

Excel

Set myRange = Range("[1]:[2]")
myRange.Select
Rows([3]).Select

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

AB2

BD4

C5

D"5"

Attempts:

3 left

💡 Hint

Common Mistakes

Using numbers as strings in Rows().

Mixing up the order of cells in the range.

First select the range from B2 to D4, then select row 5 using Rows(5).