please JUST DO QUESTION 3.

Sierra Pacific Community College District Credit Hours and Fees by Department TAB INSTRUCTIONS Sections Dept NO NO BO FRL Course Name General Biology Intro to Microbiology Anatomy & Physiology Spanish French Mandarin Intro to MS Office imro to Excel Access Programming Chemistry Fundamentals Organic Chemistry Fundamentals of Physics Credit Hours 3 3 4 3 3 3 3 3 3 4 4 4 10 8 33 S 5 15 12 Fee per Fees Total Fees Credit hour $125,00 $ 1.500.00 S 500.00 $115.00 $ 1.150.00S 450.00 $180,00 $ 1,440.00 S 360.00 $10.00 $ 780.00 $ 260,00 $40.00 $ 300.00 $ 100.00 $60.00 $ 300.00 100.00 $75.00 $ 1,125.00 S 375.00 $75.00 S 900.00 S 300.00 $75.00 $ 300.00 100.00 $125.00 S 875.00 S 218.75 5180.00 $ 1.260.00 S 315.00 $125.00 $ 1.000.00S 250.00 IUS IUS Enter formulas to calculate total fees and fre per credit hour Using the handle, copy the formulas troughout the table 123 US SUMIF to calculate the total fees for each department noted. Hint: Formulas, & For the first calculation, out of the data in the first table, you want to state the data from all fees. Use the following resource to review using SUMIF based on one criteria: Mata//www.exceley.com/functions/count sum functions.html Use SUM PRODUCTIO calculate the credit hours for each department noted. Hint Formulas Moth & THE For the first calculation, we only want the credithes for the department Uw the following resource to review sing SUMPRODUCT hita/www.celcoy.com/examples/product.nl 14) Insert the current date ma function Hint Forms Dute/Time TODAY 7 7 PHY PHY Average Enrollment 15 Total Credit Hours Department Biological Science Foreign Language Information Management Systems Physical Science Sierra Pacific Community College District Credit Hours and Fees by Department 3 5 TAS INSTRUCTIONS Feeper Credit Hours Cour Name General Biology Intro to Microbiology Army & Phylog of Section 12 10 3 3 Enter formulas to calculate total fres and fre percredit hour Using the li handle, copy the formules throughout the table the SUM to calculate the total leestoresh department noted. Hint Formulas, Math 12 13 5 3 3 Dept 70 BO 30 10 11 12 TL 11 M 14 15 15 IMS 16 17 PHY | | 19 Tot fees CHF $125.00 $4,500.00 $135.00 $4,050.00 $180.00 55,760.00 56000 5 2,140.00 $60.00 500.00 560.00 300.00 525.00 $ 3.375.00 $75.00 $ 2.190.00 57.00 5900.00 $125.00 5.300.00 $160.00 5504000 $125.00 5400000 Maid intro to Worce in obce Accm Program Chemiary Fundas De Chemistry Pre 15 12 4 4 4 4 Use the following reviews SUMF based on rece hytte //www.sey.com/function court sum function.html Vse SUMPRODUCT Clute the credit hours for each department noted. Formula For the frontare terror the degrinant Uthere to view SUMPRODUCT http://www.sy.com/sample/su product 7 elmen 15 21 22 25 24 In the event date function Totales Total Credit Hours 25 25 23 28 Department Biological Science information Management Systems Phy 10 10/11/20 A B 1 2 Sierra Pacific Community College District Credit Hours and Fees by Department 3 4 5 Credit Hours 3 3 6 Dept 7 BIO 8 BIO BIO 0 FRL 1 FRL 2 FRL 3 IMS 4 IMS 5 IMS 6 PHY 7 PHY 8 PHY 9 Course Name General Biology Intro to Microbiology Anatomy & Physiology Spanish French 11 Mandarin Intro to MS Office Intro to Excel Access Programming Chemistry Fundamentals Organic Chemistry! Fundamentals of Physics 4 3 3 3 3 3 3 #of Sections 12 10 8 13 5 5 15 12 4 Fee per Fees Total Fees Credit Hour $125.00 $ 4,500.00 $ 8.33 $135.00 $ 4,050.00 $ 9.00 $180.00 $ 5,760.00 $ 12.00 $60.00 $ 2,340.00 $ 4.00 $60.00 $ 900.00 $ 4.00 $60.00 $ 900.00 4.00 $75.00 $ 3,375.00 $ 5.00 $75.00 $ 2,700.00 $ 5.00 $75.00 $ 900.00 $ 5.00 $125.00 $ 3,500.00 $ 8.33 $180.00 $ 5,040.00 $ 12.00 $125.00 $ 4,000.00 $ 8.33 4 4 7 7 8 4 Average Enrollment 15 1 2 3 5 Department Biological Science Forelgn Languages Information Management Systems Physical Science Total Credit Total Fees Hours $ 14,310.00 CTO $ 4,140.00 $ 6,975.00 $ 12,540.00 3 10/12/20 Learning Objectives Fees & Credits Analysis + Edit NEYWuary . 12 TAB INSTRUCTIONS: (1) Enter formulas to calculate total fees and fee per credit hour Using the fill handle, copy the formulas throughout the table. (2) Use SUMIF to calculate the total fees for each department noted. Hint: Formulas, Math & Trig For the first calculation, out of all the data in the first table, you want to isolate the BIO data from all fees. Use the following resource to review using SUMIF based on one criteria: http://www.excel-easy.com/functions/count-sum-functions.html 3 D 3 (3) Use SUM PRODUCT to calculate the credit hours for each department noted. Hint: Formulas, Math & Trig For the first calculation, we only want the credit hrs for the BIO department. Use the following resource to review using SUMPRODUCT http://www.excel-easy.com/examples/sumproduct.html (4) Insert the current date as a function Hint: Formulas, Date/Time, TODAY