![]() If you’re helping someone learn the times tables too, the tips and tricks in these two videos might help. The zipped Excel file is in xlsx format, and does not contain any macros. In the Functions section, look for FN0065 – Excel Multiplication Tables. To get the Excel Multiplication Table Practice workbook, go to the sample files page on my Contextures site. In the Protect group, click Unprotect Sheet.On the Excel Ribbon, click the Review tab.That helps protect the worksheet formulas, so they aren’t accidentally deleted. In the sample file, the OneRow and Table sheets are protected, without a password Otherwise, the result is the number above, plus 1 the end number in F4 is greater than the start number in D4.the cell above has a number equal to the end number in cell F4.To create the sequence, this formula is entered in B10, and copied down to B20: In cell B9, a formula links to cell D4, where you enter the first number in the range In column B, the multiplier numbers are shown, based on the range that you selected. ![]() There are no grid borders in row 12, because cell B12 is empty. That’s done with conditional formatting, using this formula: To keep the Table sheet from looking cluttered, cell borders are only shown for the selected range of numbers. NOTE: Cell M4 has the drop down list, where you choose “Yes” to check your answers. Here’s the formula for the Conditional Formatting rule, to highlight wrong answers on the Table sheet.Ĭell E9 has orange fill because 3×3=9, and the answer was typed as 8. Then, select “Yes” from the Check drop down, to highlight any errors. Rows are created for that range of numbers, where you can fill in the multiplication answers. On the other practice sheet, named Table, you’ll choose a range of numbers that you want to practise. Wrong answers are highlighted with orange fill colour. To check your answers, choose Yes from another drop down list. Then, fill in the grid with the multiplication answers – or your best guess! On the OneRow practice sheet, pick a number, from 1 to 12, from a drop down list. There are 2 practice sheets in the Excel multiplication workbook. There’s a link near the end of this blog post, and there are a couple of videos too, with times table memorization tips. Just in case, I’ve made an Excel multiplication table practice workbook, and you can download a copy too. The school year has ended now, but maybe my grandson wants to practise his times tables all summer! (or not) We did lots of work on those times tables! Excel Multiplication Workbook Students were working from home, so I had Zoom meetings with my grandson, and helped with his math homework. Those times tables came back to haunt me this year, when the schools closed because of the pandemic. Do you remember the number grids from your schools days, where you filled in the multiplication answers? What’s 4 times 8? Or 9 times 7? If you need a refresher, or you’re helping someone learn them, I’ve got an Excel multiplication table practice workbook for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |