Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Return to the Projects worksheet. In the range 117:J22, Hwan wants to display the project estimate amounts per state. He can retrieve this information from

image text in transcribed
image text in transcribed
image text in transcribed
Return to the Projects worksheet. In the range 117:J22, Hwan wants to display the project estimate amounts per state. He can retrieve this information from the PivotTable on the Projects by State worksheet. Display the estimates per state as follows: a. In cell 118, insert a formula using the GETPIVOTDATA function to display the total estimate amount for projects in Montana from cell G5 on the Projects by State worksheet. Number Styles H I K Projects by State MT ND NE SD WY B D H E W & K Projects by State 1 2 3 Estimates 4 State 5 EMT Category Bridge Project Start Highway Paving $31,250 $29,800 6 7 B Mar May Tun Site development Grand Total $241,067 $302,117 $42,350 $42,350 $198,717 $198,717 $29,800 $31,250 $29,800 $31,250 9 171

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions