Part I(35 Marks): 1. Complete the Total Pts (3) 2. Complete the Final Marks (6) 3. Use conditional formatting to show the grade lower than 60(4) 4. Complete Pass/Fail by using IF function (6) 5. Complete the Letter Grade by using IF or Match function (6) 6. Complete Statistics (Average, Median, Low Score, High Score, Number of Students) (10) Part II (15 Marks): 1. Complete the Amount of Loan (3) 2. Complete Periodic Rate (3) Hint: P=R/m where R is the annual rate. 3. No. Payment Periods (3) 4. Monthly Payment: (6) Part III (15 Marks): Complete a Pivot table to satisfy the following requirements: 1. Average of selling price for each city (3) (\$2 decimals) 2. Number of sales for each city (2) 3. What is the average time to sell a house (No decimals) (5) 4. Show the min of sale days for each city. (3) 5. Show the max of sale days for each city. (2) 6. Bonus Question: Show average selling price, number of sales, average sale days, minimum of sale days and max of sale days for each agent in the same table. (5) Part I(35 Marks): 1. Complete the Total Pts (3) 2. Complete the Final Marks (6) 3. Use conditional formatting to show the grade lower than 60(4) 4. Complete Pass/Fail by using IF function (6) 5. Complete the Letter Grade by using IF or Match function (6) 6. Complete Statistics (Average, Median, Low Score, High Score, Number of Students) (10) Part II (15 Marks): 1. Complete the Amount of Loan (3) 2. Complete Periodic Rate (3) Hint: P=R/m where R is the annual rate. 3. No. Payment Periods (3) 4. Monthly Payment: (6) Part III (15 Marks): Complete a Pivot table to satisfy the following requirements: 1. Average of selling price for each city (3) (\$2 decimals) 2. Number of sales for each city (2) 3. What is the average time to sell a house (No decimals) (5) 4. Show the min of sale days for each city. (3) 5. Show the max of sale days for each city. (2) 6. Bonus Question: Show average selling price, number of sales, average sale days, minimum of sale days and max of sale days for each agent in the same table