0 Sierra Pacific Community College District Credit Hours and Fees by Department TAB INSTRUCTIONS: #of Fee per Dept Course NameHours Sections Fees Total Fees Credit Hour (1) Enterformulas to calculate total fees and fee per credit hour BIo BIO BIO 12 $125.00 10135.00 S180.00 $60.00 $60.00 $60,00 $75.00 575.00 575.00 71 S125.00 80.00 $125.00 General Biology intro to Microbiology... Using the fill handle,copy the formulas throughout the table Anatomy& P Spanish 13 Use SUMIF to calculate the total fees for each department noted. French I Mandarin Intro to MS Office Intro to Excel Hint: Formulas, Math &Trig For the first calculation, out ofall 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.comMunctions/count-sum-functions html 13 15 13 15 MSAccess Programmine Use SUMPRODUCT to calculate the credit hours for each department noted. 17 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.c Fundamentals of Ph 19 Average Enrollment 15 Insert the current date as a function Hint: Formulas, Date/Time, TODAY 23 Total Credit 25 26 27 Total Fees Bioloeical Science Foreien Languages Science