Question no 4

Question 4 In an excel's spreadsheet: -At cell A2 generate a series of numbers going from 1975 up to 2021. Name this column as "Years". -Generate a series of 47 random numbers from 100 up to 1200 starting at the cell 32. Name this column as "Sales" For cells 313. I323, B45 and I314 change their value for the string "NaN". Use the \"average" built in function to infer the value of this NaN's. Use the following formula to estimate the sale's performance. Performing sales = Sales divided by four * 12%, all divided by 0.2 Create a new column called "Performance" using the values you've obtained. Create a plot showing the performance per year in the most clear way. What is the total net sales