Factor Table

Spreadsheets always automatically perform the operations you ask them to do. But sometimes we want to see the process. We can make spreadsheets show us that in several ways. Here we show the factors and have students build a times table showing the factors by using a special formula called Concatenate which means join together. This enables us to create a table of factors that we can see with a single rule. Concatenate has a wide variety of uses and it is worth playing with both to visualize factors and to build interesting spreadsheets.