eBook 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 Pivot Table 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. Click on the datafile logo to reference the data. DATA file (a) Sort the Pivot Table 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? (Hint: To sort data in a Pivot Table in Excel, right-click any cell in the Pivot Table that contains the data you want to sort, and select Sort.) Select your answer Select your answer VT WY bss income for federal tax returns filed in this state with the smallest total adjusted gross income? ND CA NY TX (b) FL Row Labels in the Pivottable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income? (b) Add the County Name to the Row Labels in the Pivot Table. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? sum of adjusted gross income in the state of Texas? Select your answer - Select your answer King County Loving County Borden County Kenedy County Harris County Tarrant County (c) Dallas County ss Income in the values area of the Pivot Table in Excel. Click Value Field Settings... Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displayst (c) Click on Sum of Adjusted Gross Income in the values area of the Pivot Table in Excel. Click Value Field Settings... Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? Select your answer Select your answer Borden County Kenedy County quired, round your answers to two decimal places. King County Harris County Dallas County (d) Tarrant County Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York? Bexar County ers to two decimal places. Travis County Loving County What is this percentage? If required, round your answers to two decimal places. % (d) Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York? If required, round your answers to two decimal places. % elbook In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates indude students majoring in management, finance, accounting, information systems, and marketing. Create a pivot Table in Excel to display the number of graduates in each maler and the average monthly starting salary for students in each malor. Click on the datafile logo to reference the data. DATA file (a) Which major has the greatest number of graduates? - Select your answer - (b) which major has the highest average starting monthly salary? - Select your answer (c) Use the Pivot Table to determine the major of the student with the highest overal starting monthly salary. - Select your answer - What is the maior of the student with the lowest overall starting monthly salary - Select your answer lect your answer - Finance Management ar Check My Wor Info Systems Marketing eBook 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 Pivot Table 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. Click on the datafile logo to reference the data. DATA file (a) Sort the Pivot Table 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? (Hint: To sort data in a Pivot Table in Excel, right-click any cell in the Pivot Table that contains the data you want to sort, and select Sort.) Select your answer Select your answer VT WY bss income for federal tax returns filed in this state with the smallest total adjusted gross income? ND CA NY TX (b) FL Row Labels in the Pivottable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income? (b) Add the County Name to the Row Labels in the Pivot Table. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? sum of adjusted gross income in the state of Texas? Select your answer - Select your answer King County Loving County Borden County Kenedy County Harris County Tarrant County (c) Dallas County ss Income in the values area of the Pivot Table in Excel. Click Value Field Settings... Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displayst (c) Click on Sum of Adjusted Gross Income in the values area of the Pivot Table in Excel. Click Value Field Settings... Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? Select your answer Select your answer Borden County Kenedy County quired, round your answers to two decimal places. King County Harris County Dallas County (d) Tarrant County Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York? Bexar County ers to two decimal places. Travis County Loving County What is this percentage? If required, round your answers to two decimal places. % (d) Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York? If required, round your answers to two decimal places. % elbook In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates indude students majoring in management, finance, accounting, information systems, and marketing. Create a pivot Table in Excel to display the number of graduates in each maler and the average monthly starting salary for students in each malor. Click on the datafile logo to reference the data. DATA file (a) Which major has the greatest number of graduates? - Select your answer - (b) which major has the highest average starting monthly salary? - Select your answer (c) Use the Pivot Table to determine the major of the student with the highest overal starting monthly salary. - Select your answer - What is the maior of the student with the lowest overall starting monthly salary - Select your answer lect your answer - Finance Management ar Check My Wor Info Systems Marketing