Question: 12. Return to the Projects worksheet. In the section labeled Projects by State, Hwan wants to display the grand totals of the project estimate per


12. Return to the Projects worksheet. In the section labeled "Projects by State", Hwan wants to display the grand totals of the project estimate per state. He can retrieve this information from the PivotTable on the Projects by State worksheet. Display the estimates for each states projects. In the appropriate cell, retrieve the grand total estimate amount for projects in Montana from the PivotTable on the Projects by State worksheet. Retrieve the data for the remaining states to complete the section. MT ND NE SD WY Projects by State #REF! #REF! #REF! #REF! #REF! 12. Return to the Projects worksheet. In the section labeled "Projects by State", Hwan wants to display the grand totals of the project estimate per state. He can retrieve this information from the PivotTable on the Projects by State worksheet. Display the estimates for each states projects. In the appropriate cell, retrieve the grand total estimate amount for projects in Montana from the PivotTable on the Projects by State worksheet. Retrieve the data for the remaining states to complete the section. MT ND NE SD WY Projects by State #REF! #REF! #REF! #REF! #REF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
