Making a multiplication table is an excellent beginning Excel Activity. This video shows an efficient way to do it using absolute references, but there are many other approaches. I use an open-ended handout for this activity in class. This video is a good introduction to absolute references. Spreadsheet used in the video.
I start this activity by handing out buckets of tiles (any small objects will do) and asking students to take 10. They can sort their ten tiles into any number of piles, and their “prize” is the product of the sizes of their piles — so if they sort them into piles of size 5 and 5; their prize is 5 x 5, and if they sort into piles of sizes 1, 2, 3, and 4, their prize is 1 x 2 x 3 x 4. The goal, of course, is to get the highest possible prize, and then to generalize for other numbers of tiles. Read more >>
All Topics Blog Only