LIMIT and OFFSET in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to get the first 5 rows from the range A1:A10.

Google Sheets

=INDEX(A1:A10, SEQUENCE([1]))

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

A5

B10

C3

D7

Attempts:

3 left

💡 Hint

Common Mistakes

Using 10 returns all rows, not limiting to 5.

Using 3 or 7 returns too few or too many rows.

The SEQUENCE function generates a list of numbers from 1 to the number you specify. Using 5 returns the first 5 rows.

2fill in blank

medium

Complete the formula to skip the first 3 rows and get the next 4 rows from A1:A10.

Google Sheets

=INDEX(A1:A10, SEQUENCE([1], 1, 4))

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

A3

B7

C5

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using 3 returns fewer rows than needed.

Using 5 or 7 returns too many rows.

The SEQUENCE function here creates 4 numbers starting at 4, which skips the first 3 rows and gets the next 4.

3fill in blank

hard

Fix the error in the formula to get 3 rows starting from row 6 in A1:A10.

Google Sheets

=INDEX(A1:A10, SEQUENCE([1], 1, 6))

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

A3

B6

C10

D4

Attempts:

3 left

💡 Hint

Common Mistakes

Using 6 returns too many rows.

Using 10 exceeds the range size.

The first argument to SEQUENCE is how many rows to return. To get 3 rows starting at 6, use 3.

4fill in blank

hard

Fill both blanks to get 5 rows starting from row 4 in range B2:B20.

Google Sheets

=INDEX(B2:B20, SEQUENCE([1], 1, [2]))

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

A5

B4

C3

D6

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the start and count values.

Using a start value outside the range.

The first blank is how many rows to get (5). The second blank is the starting row (4).

5fill in blank

hard

Fill all three blanks to get 4 rows starting from row 3 in range C5:C25 and multiply each by 2.

Google Sheets

=INDEX(C5:C25, SEQUENCE([1], 1, [2])) * [3]

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

A4

B3

C2

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong start or count values.

Forgetting to multiply by 2.

Get 4 rows starting at 3, then multiply each value by 2.