SEQUENCE function in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SEQUENCE function do in Excel?

The SEQUENCE function creates a list of numbers in order, arranged in rows and columns you choose.

beginner

Write the formula to create a vertical list of numbers from 1 to 5 using SEQUENCE.

Use =SEQUENCE(5) to create a column with numbers 1, 2, 3, 4, 5.

beginner

How do you create a 3-row by 4-column grid of numbers starting at 1 with SEQUENCE?

Use =SEQUENCE(3,4) to create 3 rows and 4 columns filled with numbers from 1 to 12.

intermediate

What does the third argument in SEQUENCE(rows, columns, start) control?

The third argument sets the starting number for the sequence.

intermediate

How can you make SEQUENCE count by 2s instead of 1s?

Use the fourth argument for step size: =SEQUENCE(rows, columns, start, step). For example, =SEQUENCE(5,1,1,2) counts 1, 3, 5, 7, 9.

What formula creates a 2-row by 3-column sequence starting at 10?

A =SEQUENCE(3,2,10)

B =SEQUENCE(2,3,10)

C =SEQUENCE(10,2,3)

D =SEQUENCE(2,3)

The formula =SEQUENCE(2,3,10) creates 2 rows and 3 columns starting at 10.

What does =SEQUENCE(4) produce?

A A 4-row column with numbers 1 to 4

B A 4-column row with numbers 1 to 4

C A 4x4 grid of numbers

D An error

With only one argument, SEQUENCE creates a column with that many rows.

How do you make SEQUENCE count by 5 starting at 0 for 6 numbers?

A =SEQUENCE(6,1,5,0)

B =SEQUENCE(1,6,0,5)

C =SEQUENCE(6,1,0,5)

D =SEQUENCE(6,5,0,1)

The fourth argument sets the step size. =SEQUENCE(6,1,0,5) counts 0,5,10,15,20,25.

Which argument controls the number of columns in SEQUENCE?

A Second

B First

C Third

D Fourth

The second argument sets how many columns the sequence has.

What happens if you omit the start number in SEQUENCE?

A Starts at 0

B Returns an error

C Starts at the number of rows

D Starts at 1

If you omit the start number, SEQUENCE starts counting from 1 by default.

Explain how to use the SEQUENCE function to create a table of numbers with 3 rows and 5 columns starting at 10 and counting by 2.

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

Describe what happens when you use =SEQUENCE(4) in a cell and how the output looks.

Think about default arguments when only one number is given.

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