Return to the Projects worksheet. In the section labeled Estimate Pivotable, 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.

Please show me step-by-step.

B D E F G H I K L W &K Engineering Projects Add Project Print Stats 1 State NE NE WY NE SD Category Bridge Highway Paving Site development Projects Total Estimates Avg Estimates 4 $176,406 $44,102 $258,530 $36.933 15 $858,325 $57.222 8 $389.934 $48, 742 ND NE Estimate >50,000 Projects: : 14 WY NE ND MIT NE SD MIT Client ID W-0338 Total paid: $170,270 Projects by State Curbing 3 Client ID 4 W-0338 5 W-0341 6 W-0277 - W-0290 8 W-0344 9 W-0185 10 W-0338 11 W-0322 12 W-0290 13 W-0327 W 14 W-0332 15 W-0338 16 W-0364 17 W-0132 18 W-0277 19 W-0185 20 W-0332 21 W-0358 22 W-0284 23 W-0360 24 W-0322 25 W-0185 26 W-0332 27 W-0284 28 W-0379 29 W-0344 30 W-0338 31 W-0358 32 W-0277 33 W-0338 34 W-0290 35 W-0344 36 W-0185 37 W-0410 38 Project Type Category Attenuators Higlwar Signage Highway Grade crossing Bridge Erosion control Site development Noise abatement Site development Cold planing Paring Abutments Bridge Off-road rest area Site development Hydraulic fill Site development Patching Paving Ramps Paving Seal coating Paving Seal coating Paving Highway grading Paving Grade separation Bridge Paving Patching Shoulders Paving Median strip Highway Resurfacing Paring Grading Site development Patching Abutments Bridge Attenuators Highway Signage Highway Erosion control Site development Curbing Paving Attenuators Highway Ramps Paving Road sucfacing Paving Noise abatement Site development Geacling Site development Attenuators Highway Pavement grooving Paving WY ND MIT MT Paving 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 6/1/2021 6/3/2021 6/6/2021 6/12/2021 6/17/2021 6/20/2021 6/24/2021 6/26/2021 Estimate $30,562 $14,500 $54,672 $107.654 $38,750 $48,932 $72,358 $24,505 $34,756 $68,900 $42,350 $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 $85,437 $82,350 $31.250 $75.250 $100,350 $34,582 $44.500 $82,300 $37,650 Paid to Date $30,562 $12,000 $50,000 $57,654 $30,000 $45.932 $72,358 $24,505 $34,756 $34,900 $4,250 $17.000 $28,500 $30,400 $10,576 $38,400 $16,320 $12,050 $6.000 $17,000 $2,000 $24.000 $20,000 $2,400 $18,500 $43.000 $40,000 $11,250 $7,500 $10,350 $14,582 $20,500 $42,000 $17.000 MT ND NE SD WY Paving SD NE WY ND MT SD ND SD NE MIT WY NE NE SD ND NE B D E H I 2 3 Estimates 4 State 5 EMT Category Project Start Bridge Highway Paving $29,800 $31,250 6 Mar 7 8 Apr May Jun $29,800 9 $31,250 $100,800 Mar Apr May Jun 10 END 11 12 13 14 15 ONE 16 17 18 19 20 $18,500 $82,300 $45,062 $45,062 $72,358 Jan Feb Mar Apr Jun $72,358 Site development Grand Total $241,067 $302,117 $42,350 $42,350 $198,717 $198,717 $29,800 $31,250 $230,798 $331,598 $117,832 $117,832 $78,400 $78,400 $34,566 $53,066 $82,300 $282,710 $176,992 $577,122 $45,062 $107,654 $107,654 $34,756 $107,114 $62,360 $62,360 $220,350 $34,582 $254,932 $28,500 $168,687 $278,605 $38,750 Estimates $38,750 Value: $278,605 $28,500 Row: SD $85,390 $85,437 Column: Grand Total $109,965 $44,500 $44,500 $75,250 $44,255 $193,753 $54,672 $24,505 $24,505 $19,576 $19,750 $19,750 $75,250 $75,250 $858,325 $389,934 $1,683,195 21 TESD $81,418 22 Feb Apr May Jun $56,890 $24,528 $74,248 $54,672 23 24 25 26 OWY 27 28 29 30 31 32 Grand Total 33 Feb Mar Apr May Jun $19,576 $176,406 $258,530