Learn how spreadsheet formulas use cell names and the * symbol to calculate multiplication facts. Read each question carefully, choose or write the formula, and check that the answer matches the multiplication table.
In a spreadsheet, cell A2 contains 3 and cell B2 contains 4. Which formula should you type in C2 to multiply the numbers in A2 and B2?
Cell A3 contains 6 and cell B3 contains 7. Write the spreadsheet formula you would enter in C3 to calculate 6 times 7 using cell references.
A multiplication practice sheet has 5 in cell A2. Cells B2 through B6 contain 1, 2, 3, 4, and 5. Which formula in C2 will calculate the first answer, and what number should appear?
In a spreadsheet, A2 contains 4. Cell B2 contains 3, B3 contains 4, and B4 contains 5. If C2 has the formula =A2*B2 and you copy that formula down to C3 and C4, what values should appear in C3 and C4? Enter the two answers separated by a comma.
A multiplication practice sheet has 5 in cell A2. Cells B2 through B6 contain 1, 2, 3, 4, and 5. Which formula in C2 will calculate the first answer, and what number should appear?