Y5 Spreadsheets – investigations

1 Going up the wall

1. Open the Going up the wall spreadsheet
2. Follow the instructions under the wall and write your answers in the boxes

2 Giant multiplication grid

1. Start a new Google Sheets
2. In A1 put an X
3. In A2 to A11 put the numbers 1 to 10
4. In B1 to K1 put the numbers 1 to 10
5. You could format your spreadsheet – change text size, change column widths, colour column A and row 1, add grid lines
6. In B2 put this formula: =A2*B1 (this does 1 X 1 and shows the answer 1)
7. Copy the formula by selecting it and dragging the corner down
8. This should give the 1 times table. Is it right?
9. Can you work out what has gone wrong with the formulae?
10. Change the formula in B2 to: =$A2*B$1
11. The $ symbol means that when we copy it doesn;t change the A or the 1
12. Now copy again to get the 1 times table
13. Now drag across to get the other times tables
14. Can you extend your mutliplication grid to be 25 x 25? Even bigger?

Giant multipication grid video

Conditional formatting

1. Select the range of answers
2. Conditional formatting:
   • custon formula is
   • =iseven(B2)
   • choose a cell colour
3. This shoud highlight even numbers

3 1-100 grid

1. Set up a 1-100 grid
   • Put 1 in the top corner cell A1
   • Put =a1+1 next to it in cell B1
   • Drag this cell to the right up to 10 (cell J1)
   • Put =a1+10 underneath in cell A2
   • Drag this to the right up to J2
   • Then drag this row down
2. Use conditional formatting to highlight different multiples
   • custon formula is
   • =mod(b2,2)=0 should hightlight multiples of 2
   • choose a cell colour
3. Screenshot the patterns and paste onto a j2e5 page