Multiplication Table Challenge
Feeling up to a challenge?
Here is a challenge for you to complete in Excel.
Can you come up with a formula in cell B2 below that can be copied down and across the rest of the table below?
- From cell B1 across to K1, list the numbers 1 to 10
- From cell A2 down to A11, list the numbers 1 to 10
- In B2 enter a formula that can be copied and pasted to the remaining cells making a multiplication table
Hint: You will need mixed references
Were you able to complete this? We will post the solution next week.
[grwebform url=”http://app.getresponse.com/view_webform.js?wid=4307503&u=CucD” css=”on”/]