What are the formulas needed for the blue squares?

docs.google.com + A Blackboard + Week 2 Discussion - Google Sheets mbad6215_week_2_excel_workshop.xlsx Week 2 Discussion * Share File Edit View Insert Format Data Tools Extensions Help 2 5 100% - $ % .0 .00 123 Default B IS A . 31 F26 fx B C D E F G H K M N P Q R S T 1 Example #1 N To the left are three examples of Day 1 2 3 4 5 6 99 89 scenarios where the SUMPRODUCT # of people 76 67 98 102 76 function is useful. For each Cost/person $ 5.95 $ 5.75 $ 11.00 $ 14.00 $ 5.50 $ 13.75 $ 21.00 scenario, put a formula in the cell with the blue background to Total cost: $ 5,026.55 calculate the requested total. For 60 00 V the third example you should write Example #2 the formula using an absolute 10 reference and a relative reference Units sourced Price per unit sourced so that you can write it once and 12 lorth South Vest North South West then copy it down to the cells + 13 Input 1 3,495 744 2,342 $158.78 $118.36 $119.37 below . 14 Input 2 3,793 1,944 3,100 $111.98 $153.26 $152.50 15 Input 3 3,415 2, 65 2.980 $121.77 $132.61 $130.10 16 Total sourcing cost: $2,473,089.12 18 19 Example #3 20 21 Prices/unit Dell Latitude Macbook Pro 22 $545 $895 23 24 # of Latitudes # of Macbook Pros Cost 25 5 15 26 10 10 27 12 8 28 15 5 29 30 32 + Task #1 * Task #2 * Task #3 - Task #4 * Task #5 Task #6 - Task #7