Select the cells the same way as when creating a paper version.The applicant must copy this formula to all cells of the spreadsheet.The formula contained in any cell of the spreadsheet will refer to the corresponding cell of the column in Row 1. Helping children master multiplication charts can be a daunting task for parents. The formula contained in any cell of the spreadsheet will refer to the corresponding cell of the row in Column A. It contains two absolute links that are entered using the dollar symbol ($). Then enter the following formula in cell B2: =$A2*B$1.The applicant should indicate the numbers from 1 to 20 in the columns and rows as follows: enter numbers in order from 1 to 20 in Row 1 (starting from Column B) and Column A (starting from Row 2).Such a document is functional and convenient because it contains predefined formulas, automated cells, and calculations. You can create a Multiplication Chart to 20 as a spreadsheet and use MS Excel for this purpose. These cells must be selected for a more convenient perception of the table. Cells that indicate the result of multiplying identical numbers are arranged diagonally from the upper-right corner to the lower-right corner. And we're going to see a pattern there in a second when we try to complete an entire times tables.

Enter the multiplication result in the cell where the two multipliable numbers intersect Paint the Squares Number Charts, is an interactive way to explore number patterns such as odd and even numbers and counting in multiples from times tables.Then fill the cells on the topmost row and the leftmost column with numbers from 1 to 20, skipping the first cell.The applicant should draw a square and divide it into equal 21 parts vertically and horizontally.A Multiplication Table 20x20 should be created as follows:įor the paper version, you only need a piece of paper, a pencil, and a ruler.

Multiplication chart to 20