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!