SEQUENCE function in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Output of a basic SEQUENCE function

What is the output of the formula =SEQUENCE(3,2) when entered in a cell?

Excel

=SEQUENCE(3,2)

A A 3-row by 2-column array with numbers 1 to 6 filled by rows

B A 3-row by 2-column array with numbers 1 to 6 filled by columns

C A single column with numbers 1 to 3

D A single row with numbers 1 to 2

💡 Hint

Remember SEQUENCE fills numbers starting from 1 by default, filling down columns first.

The formula =SEQUENCE(3,2) creates a 3-row by 2-column array. It fills numbers starting at 1, going down the first column, then continuing to the next column. So the numbers go 1, 2, 3 in the first column and 4, 5, 6 in the second.

❓ Function Choice

intermediate

Choosing the right SEQUENCE formula for a custom start and step

Which formula creates a 1-row by 5-column sequence starting at 10 and increasing by 3 each step?

A =SEQUENCE(1,5,10,3)

B =SEQUENCE(5,1,10,3)

C =SEQUENCE(1,5,3,10)

D =SEQUENCE(5,1,3,10)

💡 Hint

Remember the order of arguments: rows, columns, start, step.

The formula =SEQUENCE(1,5,10,3) creates 1 row and 5 columns, starting at 10 and increasing by 3 each time: 10, 13, 16, 19, 22.

🎯 Scenario

advanced

Generating a vertical sequence with negative step

You want to create a vertical list of 4 numbers starting at 20 and decreasing by 5 each step. Which formula will do this correctly?

A =SEQUENCE(4,1,-5,20)

B =SEQUENCE(1,4,20,-5)

C =SEQUENCE(4,1,20,-5)

D =SEQUENCE(1,4,-5,20)

💡 Hint

Rows first, then columns. Negative step decreases the number.

=SEQUENCE(4,1,20,-5) creates 4 rows and 1 column, starting at 20 and subtracting 5 each step: 20, 15, 10, 5.

📊 Formula Result

advanced

Output of SEQUENCE with zero rows

What happens if you enter the formula =SEQUENCE(0,3) in a cell?

Excel

=SEQUENCE(0,3)

A Returns a #VALUE! error because rows cannot be zero

B Returns an empty array with zero rows and 3 columns

C Returns a single cell with value 1

D Returns a 3-row by 0-column array

💡 Hint

Check if SEQUENCE allows zero for rows or columns.

The SEQUENCE function requires the number of rows and columns to be positive integers. Zero rows is invalid and causes a #VALUE! error.

❓ data_analysis

expert

Counting numbers generated by a complex SEQUENCE formula

How many numbers does the formula =SEQUENCE(4,3,5,2) generate in total?

Excel

=SEQUENCE(4,3,5,2)

A 8

B 7

C 15

D 12

💡 Hint

Multiply rows by columns to find total numbers generated.

The formula creates 4 rows and 3 columns, so total numbers = 4 × 3 = 12.

Practice

1. What does the Excel function =SEQUENCE(5) do?

easy

A. Creates a vertical list of numbers from 1 to 5

B. Creates a horizontal list of numbers from 1 to 5

C. Creates a 5x5 grid of numbers starting at 1

D. Returns the number 5

Solution

1. Step 1: Understand the SEQUENCE function with one argument

   When SEQUENCE has one number, it creates that many rows in one column, starting at 1.

2. Step 2: Apply to SEQUENCE(5)

   It creates a vertical list: 1, 2, 3, 4, 5 in one column.

3. Final Answer:

   Creates a vertical list of numbers from 1 to 5 -> Option A

4. Quick Check:

   SEQUENCE(5) = vertical list 1 to 5 [OK]

Hint: One number means rows, vertical list from 1 [OK]

Common Mistakes:

• Thinking it creates a horizontal list
• Assuming it creates a grid
• Confusing output with a single number

2. Which of these is the correct syntax to create a 3-row, 4-column sequence starting at 10 with step 2?

easy

A. =SEQUENCE(3,4,10)

B. =SEQUENCE(4,3,10,2)

C. =SEQUENCE(3,4,2,10)

D. =SEQUENCE(3,4,10,2)

Solution

1. Step 1: Recall SEQUENCE syntax

   SEQUENCE(rows, columns, start, step) is the order of arguments.

2. Step 2: Match the question requirements

   3 rows, 4 columns, start at 10, step 2 matches =SEQUENCE(3,4,10,2).

3. Final Answer:

   =SEQUENCE(3,4,10,2) -> Option D

4. Quick Check:

   Rows=3, Columns=4, Start=10, Step=2 [OK]

Hint: Remember order: rows, columns, start, step [OK]

Common Mistakes:

• Swapping rows and columns
• Mixing start and step values
• Omitting step argument

3. What is the output of =SEQUENCE(2,3,5,5) in Excel?

medium

A. [[5, 10], [15, 20], [25, 30]]

B. [[5, 10, 15], [20, 25, 30]]

C. [[5, 6, 7], [8, 9, 10]]

D. [[5, 10, 15, 20, 25, 30]]

Solution

1. Step 1: Understand parameters of SEQUENCE(2,3,5,5)

   It creates 2 rows and 3 columns, starting at 5, increasing by 5 each step.

2. Step 2: Fill the sequence row-wise

   Numbers fill left to right, top to bottom: 5,10,15 in first row; 20,25,30 in second row.

3. Final Answer:

   [[5, 10, 15], [20, 25, 30]] -> Option B

4. Quick Check:

   2 rows x 3 columns, start=5, step=5 [OK]

Hint: Rows x columns fill left to right, start and step control numbers [OK]

Common Mistakes:

• Confusing rows and columns order
• Assuming step applies per row instead of per element
• Mixing vertical and horizontal filling

4. You entered =SEQUENCE(3,2,1,1) but got a #SPILL! error. What is the likely cause?

medium

A. You entered the formula in a single cell without enough empty cells to spill into

B. The step value cannot be 1

C. The SEQUENCE function requires at least 4 arguments

D. Rows and columns cannot be numbers

Solution

1. Step 1: Understand SEQUENCE spill behavior

   SEQUENCE outputs multiple cells. If adjacent cells are not empty, it causes a spill error.

2. Step 2: Check the error cause

   #SPILL! error often means the formula cannot spill because cells below or right are occupied.

3. Final Answer:

   You entered the formula in a single cell without enough empty cells to spill into -> Option A

4. Quick Check:

   Spill errors need empty space [OK]

Hint: Ensure enough empty cells for SEQUENCE to spill [OK]

Common Mistakes:

• Thinking step cannot be 1
• Believing SEQUENCE needs 4 arguments always
• Assuming rows/columns can't be numbers

5. You want to create a 4x4 grid starting at 16, decreasing by 3 each step, filling left to right, top to bottom. Which formula achieves this?

hard

A. =SEQUENCE(4,4,-3,16)

B. =SEQUENCE(4,4,16,3)

C. =SEQUENCE(4,4,16,-3)

D. =SEQUENCE(4,4,16,-1)

Solution

1. Step 1: Identify parameters for decreasing sequence

   Rows=4, Columns=4, Start=16, Step=-3 (negative for decreasing).

2. Step 2: Match formula to parameters

   =SEQUENCE(4,4,16,-3) creates a 4x4 grid starting at 16, decreasing by 3 each step.

3. Final Answer:

   =SEQUENCE(4,4,16,-3) -> Option C

4. Quick Check:

   Negative step decreases numbers [OK]

Hint: Use negative step for decreasing sequences [OK]

Common Mistakes:

• Using positive step for decreasing numbers
• Swapping start and step arguments
• Using wrong step size