Skip to content
MathAnvil

Spreadsheet Calculations Worksheets

Free printable spreadsheet calculations worksheets with step-by-step answer keys. Every worksheet is uniquely generated so students never see the same problems twice. Topics covered range from write a simple addition formula with cell references at the easy level through to multi-step budget formula (sum + subtraction) at the advanced level.

CCSS.6.SPLK20.10

Difficulty Levels

Beginner

Concepts
Write a simple addition formula with cell references
Number Range
2 cells, values 1–20
Steps
1 step
Example
A1=5, A2=8. What formula gives their sum?

Easy

Concepts
Evaluate a SUM function over a range
Number Range
3 cells, values 5–50
Steps
1 step
Example
A1=10, A2=25, A3=15. What is =SUM(A1:A3)?

Medium

Concepts
Write and evaluate an AVERAGE formula
Number Range
3 cells, values 10–99
Steps
2 steps
Example
Prices: A1=30, A2=45, A3=60. Write a formula for the average

Hard

Concepts
Multi-step budget formula (SUM + subtraction)
Number Range
income 3000–6000, 3 expenses 400–1500
Steps
2 steps
Example
Income A1=5000, expenses B1..B3. Write a savings formula

Grade Availability

Spreadsheet Calculations worksheets are available for Grades 6–10. Problems are automatically adjusted to match grade-level expectations in number range, complexity, and notation.

Try a Sample Problem

Try it right now

Learn the theory β†’ Read our spreadsheet calculations guide with worked examples.

Practice online β†’ Interactive spreadsheet calculations problems with instant feedback.