ExamFinch.com My Study

Study guide

Generate Numeric Data with RANDBETWEEN and SEQUENCE

Practice this exam

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Generate Numeric Data with RANDBETWEEN and SEQUENCE

Key Takeaways Explain This Topic AI

RANDBETWEEN(bottom, top) returns a random integer between bottom and top inclusive; it recalculates when the workbook calculates

SEQUENCE(rows, [columns], [start], [step]) spills a dynamic array of numbers—Associate tasks often need a single-cell entry that fills a block

Dynamic array awareness: enter SEQUENCE (or similar) in the top-left cell only; results #SPILL! if the spill range is blocked

Paste Special → Values after generating random or sequenced numbers when the task wants a fixed snapshot that will not keep changing

MO-210 scenarios use these functions to build sample IDs, quiz scores, date serial steps, or numbered lists without typing every value

Last updated: August 2026

Why RANDBETWEEN and SEQUENCE appear on MO-210

Microsoft’s Excel Associate (Microsoft 365 Apps) outline calls out generate numeric data by using RANDBETWEEN and SEQUENCE . These functions let you create sample scores, IDs, ranks, or evenly spaced lists without typing dozens of numbers. The exam measures whether you can enter the correct formula in the right cell, supply sensible arguments, and—when required—convert volatile or spilled results into static values.

You do not need Expert-level dynamic array mastery (FILTER, complex spilled intersections). You do need Associate-level fluency: write RANDBETWEEN and SEQUENCE correctly, recognize a spill range , clear #SPILL! blockers, and know that random functions change when Excel recalculates.

  • RANDBETWEEN syntax and behavior RANDBETWEEN(bottom, top)
  • bottom — smallest integer allowed (inclusive)
  • top — largest integer allowed (inclusive)

Returns a whole number. For decimals, Associate tasks usually stay with integers; combining with other functions is uncommon on MO-210 unless specified.

Examples:

  • Formula Meaning
  • =RANDBETWEEN(1,100) Integer from 1 through 100
  • =RANDBETWEEN(50,50) Always 50 (degenerate but valid)
  • =RANDBETWEEN(0,1) 0 or 1
  • =RANDBETWEEN(1000,9999) Four-digit style codes
  • Volatility (recalculation)

RANDBETWEEN is volatile . It recalculates when the workbook calculates—opening the file, editing other cells, pressing F9 (depending on calculation mode), and many fill/paste operations. That is useful for "fresh sample data" and annoying when a task already graded your numbers and you accidentally recalculate.

Freeze random data when instructed:

Select the random results.

Copy.

Paste Special → Values over the same range (or onto a destination the task names).

After that, cells hold constants and stop changing.

  • Filling many random values
  • Option A — Auto Fill a single-cell formula

Enter =RANDBETWEEN(60,100) in G2 for practice quiz scores.

Fill down through G25.

Each row gets its own random integer (they recalculate independently when the sheet calculates).

Option B — SEQUENCE of randoms (advanced combo)

Microsoft 365 can spill arrays such as =RANDBETWEEN(1,10) entered as an array pattern in some contexts, but Associate projects almost always expect either filled RANDBETWEEN cells or a clear SEQUENCE for ordered lists—not obscure array tricks. Prefer the method the descriptor implies.

Exam scenario — RANDBETWEEN

Descriptor: "In cells D2:D16, generate random integers between 10 and 50 inclusive. Then convert the results to values so they do not change."

Enter =RANDBETWEEN(10,50) in D2.

Fill through D16.

Select D2:D16 → Copy → Paste Special → Values.

Confirm formula bar shows numbers, not RANDBETWEEN .

If you skip Paste Values, pressing F9 or editing elsewhere may change scores before the project is scored.

SEQUENCE syntax and dynamic arrays SEQUENCE(rows, [columns], [start], [step])

  • Argument Required? Default Role
  • rows Yes — How many rows to spill
  • columns No 1 How many columns to spill
  • start No 1 First number in the sequence
  • step No 1 Increment between numbers

Examples:

  • Formula Result
  • =SEQUENCE(5) 1,2,3,4,5 down one column
  • =SEQUENCE(4,3) 4×3 grid of 1 through 12 row-wise
  • =SEQUENCE(6,,100,10) 100,110,120,130,140,150
  • =SEQUENCE(5,1,0,0.5) 0, 0.5, 1, 1.5, 2 (decimals allowed)
  • =SEQUENCE(3,3,10,-1) 10..2 in a 3×3 block stepping by −1
  • Spill behavior (Associate awareness)

Enter SEQUENCE in one top-left cell only. Excel spills results into neighboring cells automatically. You should see a blue spill boundary when you select the formula cell.

Do not pre-type numbers into the spill zone.

If something blocks the spill range, Excel shows #SPILL! . Clear or move the blocking values, or pick a clearer destination cell.

Deleting the top-left formula clears the entire spill. Editing a spilled "child" cell is not how you modify a SEQUENCE—change the formula arguments instead.

Other formulas can reference the spill with the spill operator (for example A2# ) in Microsoft 365; Associate tasks may simply ask you to create the sequence, not to build advanced spill references.

SEQUENCE vs Auto Fill series

Both can create 1,2,3,… lists:

Auto Fill — type 1 and 2 , drag the handle (or use Fill Series). Results are static constants.

SEQUENCE — one dynamic formula; change rows or step and the list updates. Use SEQUENCE when the task names the function or wants a formula-generated list.

If the descriptor says "use the SEQUENCE function to number rows 1 through 20 in column A starting at A2," enter =SEQUENCE(20) in A2—do not manually type 1 through 20.

  • Exam scenario — SEQUENCE
  • Descriptor: "In cell A2, use SEQUENCE to list the numbers 5 through 14 (ten values) in a single column."

Calculation: ten rows, start at 5, step 1 → =SEQUENCE(10,1,5,1) or =SEQUENCE(10,,5) .

Descriptor: "Create a 2-column by 5-row grid of IDs starting at 100 and increasing by 1."

→ =SEQUENCE(5,2,100,1) in the top-left cell of the target range.

Combining skills from this chapter

Projects often chain Domain 2 skills:

SEQUENCE or RANDBETWEEN to generate numbers.

Paste Special → Values to freeze them.

Insert columns beside the list for labels.

Auto Fill formulas that reference the generated IDs.

Example storyline: generate employee IDs with =SEQUENCE(12,,1001,1) , paste values, insert a column for department codes, Flash Fill full names from nearby columns, then fill a commission formula down.

Function comparison for quick decisions

  • Need Prefer
  • Random integers in a range RANDBETWEEN(bottom,top)
  • Ordered list / grid of numbers SEQUENCE(rows,columns,start,step)
  • Static list that never changes Auto Fill series or generate then Paste Values
  • List that should update if you change length/step Keep SEQUENCE live
  • Random sample that must stay fixed for grading RANDBETWEEN then Paste Values
  • Common traps

Swapping RANDBETWEEN arguments so bottom > top → #NUM! .

Entering SEQUENCE in every row manually instead of one spill formula.

Ignoring #SPILL! and typing over the spill range.

Leaving volatile randoms unfrozen when the task said values must not change.

Using RAND() (0–1 decimal) when the objective specified RANDBETWEEN .

Off-by-one errors: "numbers 1 through 10" is SEQUENCE(10) , not SEQUENCE(9) .

Starting SEQUENCE on the wrong cell so the spill overwrites headers—place it in the first data row as instructed.

Practice checklist before you leave the task

Function name matches the descriptor ( RANDBETWEEN vs SEQUENCE ).

Arguments produce the stated count, start, step, and bounds.

Spill range is unblocked and sits where the project expects.

Paste Values completed if permanence was required.

Spot-check first, middle, and last values against the instructions.

Confident use of these two functions—plus knowing when to freeze results—covers the MO-210 numeric generation objective cleanly inside broader Domain 2 projects.