Data Analysis With Spreadsheets With Lab Course Number: BIS155 in 4hrs i need this to be done

Use SUMIF, AVERAGEIF, and COUNTIF Functions (Chapter 8): Using the Educator Assessment worksheet, let’s practice using COUNTIF, SUMIF, and AVERAGEIF. In cell H3, create a formula to calculate the total number of teachers hired before January 1, 2005. In cell H4, create a formula to calculate the total salaries paid to teachers hired before January 1, 2005. In cell H5, create a formula to calculate the average salary for teachers hired before January 1, 2005.

Explain which function needs to be used in cell H3, H4, H5, and why? Share how you created your formulas with the class.