donors: follow the instructions in the green box and make a pivot table and chart with the following data. Finally answered the questions in the donation questions box.
Use the aperepriate functions to find the anwess to the Guestions atoun the Order Dede. fieference af vilues. Create cacvable fermulas where atpisable format values appreprialely Frestiable Rerreste the piver able based off the 'Donation Dasa' dstatet. Find the m of oonasiani by State Sort by Donation in dricending berder Qhirt: Becteute the chart uala the gummarired donation by atate. Make a pivot table dicplaying w of donations for each state. Sort by $ of Donations in descending order. The tables below contain donation data for a nationwide disaster relief organization and a table of those who have donated. Checklist Donation Questions Table Use the appropriate functions to find the answers to the questions about the Order Data. Reference all values. Create copyable formulas where applicable. Format values appropriately. Pivot Table Recreate the pivot table based off the 'Donation Data' dataset. Find the \# of Donations by State. Sort by Donations in descending order. Chart Recreate the chart using the summarized donations by state. \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & \multicolumn{3}{|c|}{ Donation Data } \\ \hline Donation \# & Donor ID & Donation Type & Donation Value & State & Donor Email \\ \hline D28371 & 41355 & Money & $ & 247.40 & FL & dogdude@verizon.net \\ \hline D28372 & 55266 & Stocks & $ & 339.09 & FL & rnelson@yahoo.com \\ \hline D28373 & 59484 & Items & $ & 35.35 & TX & novanet@outlook.com \\ \hline D28374 & 51033 & Money & $ & 85.01 & NC & rsteiner@comcast.net \\ \hline D28375 & 83741 & Money & $ & 300.57 & FL & crusader@sbcglobal.net \\ \hline D28376 & 41355 & Stocks & $ & 99.15 & FL & dogdude@verizon.net \\ \hline D28377 & 67220 & Items & $ & 152.03 & SC & bester@live.com \\ \hline D28378 & 69795 & Items & $ & 269.56 & Rl & horrocks@hotmail.com \\ \hline D28379 & 60678 & Money & $ & 326.19 & IL & mddallara@hotmail.com \\ \hline D28380 & 28505 & Items & $ & 61.61 & TN & yfreund@icloud.com \\ \hline D28381 & 55266 & Money & $ & 106.56 & FL & rnelson@yahoo.com \\ \hline D28382 & 59484 & Items & $ & 337.31 & TX & novanet@outiook.com \\ \hline D28383 & 51033 & Items & $ & 60.81 & NC & rsteiner@comcast.net \\ \hline D28384 & 83741 & Money & $ & 286.41 & FL & crusader@sbcglobal.net \\ \hline D28385 & 41355 & Money & $ & 349.83 & FL & dogdude@verizon.net \\ \hline D28386 & 67220 & Money & $ & 239.15 & SC & bester@live.com \\ \hline D28387 & 69795 & Items & $ & 77.75 & RI & horrocks@hotmail.com \\ \hline D28388 & 60678 & Stocks & $ & 335.85 & IL & mddallara@hotmail.com \\ \hline D28389 & 41355 & Items & $ & 357.74 & FL & dogdude@verizon.net \\ \hline D28390 & 51033 & Money & $ & 172.24 & NC & rsteiner@comcast.net \\ \hline D28391 & 83741 & Money & $ & 231.90 & FL & crusader@sbcglobal.net \\ \hline \end{tabular} Make a pivot table displaying \# of donations for each state. Sort by \# of Donations in descending order
