Data Analytics Super League Competition (Challenge 1)

So, I entered a competition, which will have 5 stages, you can be dropped at any stage. so it will be two individual stages and 3 group stages. I have passed the first stage so here’s the project that was done below with every detail necessary, take your time to read and give your feedbacks, thanks.

Challenge 1: Cell Referencing

Using Cell Referencing, write a formula that calculates and auto-populates a multiplication table into cell B2.

Use the fill handle in cell B2 to drag the formula across the entire multiplication table so it can auto-populate the cells.

See the example below:

Replace the word ‘FORMULA’ in cell B2 with the correct formula that calculates the product of values in cells B1 and A2 then drag the fill handle to auto-populate the rest of the cells in the multiplication table.

NOTE: Just one formula is needed and it is based on your knowledge of cell referencing.

Your submission should be a link to a Google Spreadsheet or a One Drive link to the Excel Spreadsheet.

Answer -https://docs.google.com/spreadsheets/d/1PuvVP3UXrXxCmuwSd20xsqggr-IZi8F7wkQoGEg0b-k/edit#gid=0

The goal of this challenge is to see how well we reference cells in spreadsheets, it took me less than 5 mins to get this done because it was that simple.
I’m sure the next challenge will be a great learning experience
Can’t wait!