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 & [email protected] \\ \hline D28372 & 55266 & Stocks & $ & 339.09 & FL & [email protected] \\ \hline D28373 & 59484 & Items & $ & 35.35 & TX & [email protected] \\ \hline D28374 & 51033 & Money & $ & 85.01 & NC & [email protected] \\ \hline D28375 & 83741 & Money & $ & 300.57 & FL & [email protected] \\ \hline D28376 & 41355 & Stocks & $ & 99.15 & FL & [email protected] \\ \hline D28377 & 67220 & Items & $ & 152.03 & SC & [email protected] \\ \hline D28378 & 69795 & Items & $ & 269.56 & Rl & [email protected] \\ \hline D28379 & 60678 & Money & $ & 326.19 & IL & [email protected] \\ \hline D28380 & 28505 & Items & $ & 61.61 & TN & [email protected] \\ \hline D28381 & 55266 & Money & $ & 106.56 & FL & [email protected] \\ \hline D28382 & 59484 & Items & $ & 337.31 & TX & [email protected] \\ \hline D28383 & 51033 & Items & $ & 60.81 & NC & [email protected] \\ \hline D28384 & 83741 & Money & $ & 286.41 & FL & [email protected] \\ \hline D28385 & 41355 & Money & $ & 349.83 & FL & [email protected] \\ \hline D28386 & 67220 & Money & $ & 239.15 & SC & [email protected] \\ \hline D28387 & 69795 & Items & $ & 77.75 & RI & [email protected] \\ \hline D28388 & 60678 & Stocks & $ & 335.85 & IL & [email protected] \\ \hline D28389 & 41355 & Items & $ & 357.74 & FL & [email protected] \\ \hline D28390 & 51033 & Money & $ & 172.24 & NC & [email protected] \\ \hline D28391 & 83741 & Money & $ & 231.90 & FL & [email protected] \\ \hline \end{tabular} Make a pivot table displaying \# of donations for each state. Sort by \# of Donations in descending order