the file taxdata contains information from federal tax returns filed in 2007 for all counties in the united states (3,142 counties in total). create a pivottable in excel to answer the questions below. the pivottable should have state abbreviation as row labels. the values in the pivottable should be the sum of adjusted gross income for each state. (a) sort the pivottable data to display the states with the smallest sum of adjusted gross income on top and the largest on the bottom. which state had the smallest sum of adjusted gross income? what is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income (in dollars)? (hint: to sort data in a pivottable in excel, right-click any cell in the pivottable that contains the data you want to sort, and select sort.) nd correct: your answer is correct. has the smallest sum of adjust gross income with $ 14923737 incorrect: your answer is incorrect. .