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.