Problem 4 1. Create a table for 5 students for Becky Galaris's class for Spring 2021. 2. The first project is worth 15% of their final grade. Second project is 20%; midterm is 25%; and the final is 40%. 3. Find the average grade for each student. 4. Using the sumproduct function, to find the weighted average grade for each student. 5. Find the class average for each item, including the average and weighted average grades for the students. 6. Create a column chart that illustrates the difference between the average and weighted average grades for each student. Problem 5 1. Create a table for Chelsea Corp for 5 items with sales in units for the first three months of 2021. 2. Insert a value between 1,000 and 2,000 for Item 1 for January. 3. Sales for item 1 increase each month by 20%. 4. If total sales for Item 1 for the 3 months exceeds 4000 units, then sales for Item 2 are 10% more each month than Item 1. If Item 1 sales are not more than 4000 then sales for Item 2 are 600 items less per month. 5. Items 3-5 are 10% more than Item 1 each month. Note: You can only place the 10% in one cell on the worksheet to use in the formulas to calculate their values. You must use $ in your formulas which means that the formula for item 3 should be able to be copied to the other two months, and items 4 and 5 without having to retype the formula. 6. Find total sales for each month and quarter for all items. 7. Using the appropriate function, find the lowest sales quantity for each month. 8. Create a Sparkline chart for each item for the quarter in the cell next to Total Sales for the quarter