LAAM LEOAaBb AaBbcc AaB Aabet ADAC AD ABCD AOC I NO SAMA SAMPONS Hewling Hendi? Title Subte Site Engine bacte sis Para Se Info 1. In the range 13:L7, Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows: a. In cell 34, enter a formula using the COUNTIF function that counts the number of projects in the Bridge category, checking that the column of categories in the Projects table (Projects[Category]) is equal to the value in cell 14. b. Fill the range 35:37 with the formula in cell 34, filling without formatting. C. In cell K4, enter a formula using the SUMIF function that totals the estimates for projects in the Bridge category, checking that the column of categories in the Projects table (Projects Category]) is equal to the value in cell 14, and that the formula totals the values in the Estimate column (Projects[Estimate]). d. Fill the range K5:K7 with the formula in cell K4, filling without formatting. In cell L4, enter a formula using the AVERAGEIF function that averages the estimates of projects in the Bridge category, checking that the column of categories in the Projects table (Projects[Category]) is equal to the value in cell 14, and that the formula averages the values in the Estimate column (Projects[Estimate]). f. Fill the range L5:L7 with the formula in cell L4, filling without formatting. e. C D E F G H K 1 Engineering Projects Add Project Paint Stats State Category Highway NE NE WY NE SD ND NE Category Projects Total Estimates Avg Estimates =COUNTIF Hagles COUNT.Forange criteria Paving Site development Estinate >50,000 Projects NE ND ACT Badge Site development Site development Pering Bridge 1 Site development 2 Site enhancement Paving 4 Paring 15 Paving 16 Parang 17 Paip 18 Bades 19 Paving 20 Png 21 Paving 23 Pering 24 See development Pavang 26 Bad 2 Hugow 28 H Site developentot Project Start 1/12/2021 1/20/2021 2/16/2021 2/22/2021 2/22/2021 3/1/2021 3/12/2021 3/20/2021 3/23/2021 3/24/2021 3/30/2021 4/2/2021 4/2/2021 4/5/2021 4/5/2021 4/14/2021 4/16/2021 4/16/2021 4/17/2021 4/23/2021 5/2/2021 5/10/2021 5/14/2021 5/14/2021 5/26/2021 5/30/2021 Projecte proj Estimate $30,562 $14.500 $54,672 $107.654 $38,750 $48,932 $72,358 $24,505 $34,756 568,900 $42350 $27,800 $28,500 $70 347 $19,576 $78.400 $76 320 $52,050 $56,890 $34,560 $19,750 $34,566 $29,800 $24,528 $18.500 585437 Client ID W-0338 Total paad NE SD MT WY ND Arr MET SD NE WY ND MT SD ND SD Documento Paid to Date $30,562 $12.000 $50,000 $57,654 $30,000 $45,932 $72358 $24,505 $34,756 $34,900 $4,250 $17,000 $28,500 $30,400 $10,576 $38,400 $16,320 $12050 $6,000 $17.000 $2.000 $24,000 $20,000 $2.400 $18,500 $43.000 Noget Payments Projects by State ND NE SD WY Projets by Category Mont Sales Employees pansion e
