Question

8. Hwan wants to summarize project information in column I. Calculate the number of projects, the total estimates, and the average estimate in each category.

a. Next to the cell labeled "Bridge", use a function to count the number of Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
b. In the appropriate cell, use a function to total the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
c. In the appropriate cell, use a function to average the estimates for Bridge projects in the Projects table. Use a cell reference to the cell labeled Bridge.
d. Use these formulas to fill the data for the remaining categories, filling without formatting.

Answer 1

To summarize project information, one would use COUNTIF, SUMIF, and AVERAGEIF functions next to the Bridge label cell to calculate the number of projects, total estimates, and average estimates, respectively, and then apply these formulas for the remaining categories.

Step-by-step explanation:

Hwan wants to summarize project information in column I by calculating the number of projects, the total estimates, and the average estimate for each category:

• To count the number of Bridge projects, you would use the COUNTIF function next to the cell labeled "Bridge".
• To total the estimates for Bridge projects, the SUMIF function would be used, again referencing the cell labeled "Bridge".
• The AVERAGEIF function can then be used to calculate the average estimates for the Bridge projects, utilizing the same cell reference.
• These formulas would then be replicated for the remaining categories to fill in the data without altering the formatting.

Note that you need to ensure cell references align with the actual cells used in your specific worksheet. The COUNTIF, SUMIF, and AVERAGEIF functions are powerful tools for summarizing data based on specific criteria in Excel or similar spreadsheet programs.