Skip over navigation
Guide and features
Guide and features
Science, Technology, Engineering and Mathematics
Featured Early Years Foundation Stage; US Kindergarten
Featured UK Key Stage 1&2; US Grades 1-4
Featured UK Key Stage 3-5; US Grades 5-12
Featured UK Key Stage 1, US Grade 1 & 2
Featured UK Key Stage 2; US Grade 3 & 4
Featured UK Key Stages 3 & 4; US Grade 5-10
Featured UK Key Stage 4 & 5; US Grade 11 & 12
Excel Interactive Resource: Remainder
This month I'm revisiting an NRICH problem called
which appeared in October 2002. As always, I've picked a problem where using a spreadsheet adds something powerful to the problem-solving process.
What is the remainder when 2
is divided by 7?
What happens with different powers of 2?
Try to explain the mathematics behind what you discover.
The spreadsheet quickly produces a line of results, and leaves my brain free to think about the pattern I observe.
remainder when divided by 7
Download the Excel file
(Right-click on the link, "Save Target As", and select where you want the file to be saved.)
Click on the cell C3 to see the formula =2^B3 in the formula bar. Remember the ^ sign makes Excel do powers.
Click on D3 to see the formula =MOD(C3,7) in the formula bar. The MOD function will calculate the remainder when the number in C3 is divided by 7.
Next these formulae are copied down for several rows to produce results for increasing powers of 2.
The remainders make a simple pattern : 2 4 1 2 4 1 2 4 1 . . .
Why does this pattern occur?
An explanation might go something like this:
Going to the next power of 2 doubles the previous answer, and therefore doubles the remainder. The remainder starts at 2 ( 2 divided by 7 has a remainder of 2). The next remainder is twice that(4), followed by another remainder, which is twice that (8). However when we divide we are taking out whole sevens, so the actual remainder this time is not 8 but 1 . Double that 1, to make the next remainder, 2 , which was the first remainder we calculated, so we are in a loop, and the pattern will continue endlessly.
That didn't take very long. Using the spreadsheet to generate the initial results got us through the calculation stage quickly, so we have plenty of time to consider a more general problem.
What about division by any number, not just 7?
And what about powers of numbers other than 2?
Here's an Excel sheet I created to explore these questions.
(Right-click on the file name link, and "Save Target As", as usual). You'll see there are Spinners to control the new variables.
Have fun. And remember, it's accounting for the pattern that's the real solution.
Meet the team
The NRICH Project aims to enrich the mathematical experiences of all learners. To support this aim, members of the NRICH team work in a wide range of capacities, including providing professional development for teachers wishing to embed rich mathematical tasks into everyday classroom practice. More information on many of our other activities can be found here.
Register for our mailing list
Copyright © 1997 - 2014. University of Cambridge. All rights reserved.
NRICH is part of the family of activities in the
Millennium Mathematics Project