SEQUENCE function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to create a sequence of 5 numbers starting from 1.

Excel

=SEQUENCE([1])

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

A10

B5

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 creates only one number, not a sequence.

Using 0 or negative numbers causes errors.

The SEQUENCE function with one argument creates a vertical array from 1 to that number. Here, 5 creates numbers 1 to 5.

2fill in blank

medium

Complete the formula to create a sequence with 3 rows and 4 columns.

Excel

=SEQUENCE([1], 4)

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

A3

B4

C5

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping rows and columns arguments.

Using the wrong number for rows.

The first argument is the number of rows. Here, 3 rows and 4 columns create a 3x4 grid of numbers.

3fill in blank

hard

Fix the error in the formula to start the sequence at 10 with 5 numbers.

Excel

=SEQUENCE(5, 1, [1])

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

A1

B0

C10

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the start number as 1.

Using 0 or 5 which start the sequence at wrong numbers.

The third argument is the start number. To start at 10, put 10 there.

4fill in blank

hard

Fill both blanks to create a 2-row, 3-column sequence starting at 5 and increasing by 2.

Excel

=SEQUENCE([1], [2], 5, 2)

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

A2

B3

C4

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping rows and columns.

Using wrong numbers for rows or columns.

The first blank is rows (2), the second is columns (3). The sequence starts at 5 and increases by 2 each step.

5fill in blank

hard

Fill all three blanks to create a 4-row, 2-column sequence starting at 3 and decreasing by 1.

Excel

=SEQUENCE([1], [2], [3], -1)

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

A4

B2

C3

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive step instead of negative.

Swapping rows and columns.

Wrong start number.

The sequence has 4 rows, 2 columns, starts at 3, and decreases by 1 each step.