Excel isn’t just for budgets and spreadsheets—it can also be a helpful tool for solving math problems. By organizing information into cells, using formulas, and formatting numbers as fractions, you can break complex word problems into smaller, easier-to-understand steps.
In this tutorial, you’ll learn how to use Microsoft Excel to solve a fraction word problem involving a pizza party. Along the way, you’ll learn how to format cells as fractions, perform calculations using fractional values, and visualize the solution.
What You’ll Learn
- How to format cells to display fractions
- How Excel performs calculations with fractions
- How to calculate the number of pizzas needed
- How to determine how much pizza will be left over
- How to organize a word problem in Excel
- How simple formulas can help verify your math
Common Uses
- Solving fraction word problems
- Checking homework answers
- Teaching fractions visually
- Planning food quantities for groups
- Learning how Excel handles fractions
- Organizing math problems into logical steps
Requirements / Compatibility
This tutorial was originally recorded in 2020 and remains accurate in current versions of Microsoft Excel, including:
- Microsoft 365
- Excel 2024
- Excel 2021
- Excel 2019
- Excel 2016
- Excel for Mac
Excel has supported fraction formatting for many years, so the steps shown in this tutorial continue to work today.
Practice & Resources
Want to follow along with the example?
The companion workbook includes the completed pizza party problem so you can explore the formulas, change the number of students or pizza portions, and see how the answers update automatically.
Click the button below to View Practice & Resources.
Video Tutorial
Breaking Down the Concepts
This tutorial doesn’t rely on complicated Excel functions. Instead, it demonstrates how Excel can organize information and perform calculations automatically.
Fraction Formatting
Before entering any fractions, the worksheet is formatted to display numbers as fractions instead of decimals.
For example:
1/4
instead of
0.25
The underlying value is exactly the same – only the display changes.
Why it’s used:
- Makes fraction problems easier to read.
- Matches the way fractions are typically written in school.
Multiplication
To determine how much pizza is needed, Excel multiplies:
Number of Students × Pizza Per Student
For this example:
21 × 1/4
which equals
5 1/4 pizzas
Why it’s used:
This tells us the exact amount of pizza required before rounding.
Rounding to Whole Pizzas
Since restaurants sell whole pizzas rather than partial pizzas, the answer must be rounded up.
Although only 5¼ pizzas are needed, you’ll need to order:
6 pizzas
Why it’s used:
Everyone receives enough pizza, even if there is some left over.
Subtraction
To determine the leftovers, Excel subtracts:
6 − 5¼
Result:
3/4 pizza
Why it’s used:
This answers the second part of the story problem.
Visualizing the Answer
One unique aspect of this tutorial is using simple shapes to represent pizzas.
Drawing the pizzas makes it easier to understand:
- how many full pizzas are needed,
- how the last pizza is divided,
- and why three-quarters remains.
Sometimes a picture makes the math easier to understand than numbers alone.
Step-by-Step Instructions
Format the Worksheet
- Select the cells you’ll use.
- Right-click and choose Format Cells.
- Select Fraction.
- Choose a fraction style (such as Up to three digits).
- Click OK.
Enter the Information
Enter:
- Fraction per student (1/4)
- Number of students (21)
Calculate Pizza Needed
- Enter an equals sign.
- Multiply the number of students by the fraction.
Example:
=21*1/4
Excel returns:
5 1/4
Determine Full Pizzas
Round up to the nearest whole pizza.
Result:
6 pizzas
Calculate Leftovers
Subtract:
6 - 5 1/4
Result:
3/4 pizza
Additional Tips
- Excel performs the calculations using decimal values, even though the cells display fractions.
- You can reuse this worksheet for other scenarios by simply changing the number of students or serving size.
- Fraction formatting only changes how numbers appear—it doesn’t affect the math.
- Drawing simple diagrams or shapes can make word problems easier to understand.
Related
How to Remove Extra Spaces in Excel
Learn how to remove extra spaces from text in Microsoft Excel using the TRIM function. This beginner-friendly tutorial explains what TRIM removes, when to use it, and why it’s one of the most useful functions for cleaning imported or inconsistent data.
How to Create an Order Form with Drop-Down Menus in Microsoft Excel
Learn how to create a professional order form in Microsoft Excel using drop-down menus, Data Validation, and named ranges. This step-by-step tutorial also covers formatting dates, ZIP codes, and credit card fields to build cleaner, more accurate spreadsheets for real-world business use.
Stay Updated
There are two easy ways to get notified when new tutorials are published:
Subscribe on YouTube for new video tutorials: @SimpleSoftwareTutorials
or enter your email below to receive new blog posts directly in your inbox:
Simple Software Tutorials 