question 12 requires a formula this is not helpful for me, and you please give me the formula.
11. Return to the Arojectr warkheet. In the range 117:122. Mwan wants to dispiay the project estimate amounta per state. He cas setreve the information frow the Pivoctabie on the Projects by State workaheet. Distay the estimates per state as follows 14. In cen 316, incert a formule tring the Ge tptvotoAta function to display the totei estimate mrosunt for projecas im Montant from cell os on the Arejecty sy State workerere b. In cell 135, inset a formela using the cetptvoroxtx Aunction to displey the total estimate arneune far prejects in Herth Delota frem cell 610 on the Projech by state workahee. (C) Incell 320, insert a furmula uine the citravoroara function to espiar the Siate workthect. 4. Theel 22d, inseit = Kurmaia wing the eerervoroAta hunetion to disploy the ty state warkhet. state etrahimt. 11. Refurn to the Projects worksheet. In the range 117:122. Hwan wants to display the project estimate amounts per state. He can retrieve this information from the Pivotrable on the Projects by State worksheet. Display the estimates per state as follows: a. In cell 318, insert an formuls using the GETPIVOTDATA function to display the total estimate amount for proyects in Mantane frem cell 65 on the Projects by State worksheet. b. In cell 319, insert a formula using the GETPTVOTDATA function to Gisplay the total estimate ampunt for projects in Hortin bakcota from cell G10 on the Projecti by state workshect. c. In celi 120, insert a formuis using the GeTprvotoAta function to disolay the total estimete amount for projects in Nebraska from cell G15 on the frojects by State worksheet. d. In oel 121, insert a formule using the st TprvotoAta function to daplay the total estimate ambunt for projects in fouth baketa from celr Git an the Projects by Stefe worksheet. . In ceil 122. insert a formuln using the estPIVotDATA Function to dsplay the total estimete amount for projects in wroming tham eel 026 on the Prolects by State workshert. 11. Return to the Arojectr warkheet. In the range 117:122. Mwan wants to dispiay the project estimate amounta per state. He cas setreve the information frow the Pivoctabie on the Projects by State workaheet. Distay the estimates per state as follows 14. In cen 316, incert a formule tring the Ge tptvotoAta function to display the totei estimate mrosunt for projecas im Montant from cell os on the Arejecty sy State workerere b. In cell 135, inset a formela using the cetptvoroxtx Aunction to displey the total estimate arneune far prejects in Herth Delota frem cell 610 on the Projech by state workahee. (C) Incell 320, insert a furmula uine the citravoroara function to espiar the Siate workthect. 4. Theel 22d, inseit = Kurmaia wing the eerervoroAta hunetion to disploy the ty state warkhet. state etrahimt. 11. Refurn to the Projects worksheet. In the range 117:122. Hwan wants to display the project estimate amounts per state. He can retrieve this information from the Pivotrable on the Projects by State worksheet. Display the estimates per state as follows: a. In cell 318, insert an formuls using the GETPIVOTDATA function to display the total estimate amount for proyects in Mantane frem cell 65 on the Projects by State worksheet. b. In cell 319, insert a formula using the GETPTVOTDATA function to Gisplay the total estimate ampunt for projects in Hortin bakcota from cell G10 on the Projecti by state workshect. c. In celi 120, insert a formuis using the GeTprvotoAta function to disolay the total estimete amount for projects in Nebraska from cell G15 on the frojects by State worksheet. d. In oel 121, insert a formule using the st TprvotoAta function to daplay the total estimate ambunt for projects in fouth baketa from celr Git an the Projects by Stefe worksheet. . In ceil 122. insert a formuln using the estPIVotDATA Function to dsplay the total estimete amount for projects in wroming tham eel 026 on the Prolects by State workshert
