Can someone solve my excel?
EX16_XL_COMP GRADER CAP_HW -Stock Transactions 1.6 Project Description: I this project, you will update a workbook to display bank transactions as a PivotTable. You will fater the Pivot Table, format the values, display the values as cakculations, and create a PivotChart using this data. Additionally you will sort and subtotal data, create data tables, and use Goal Seek and Scenario Manager. You wil format grouped worksheets, set up validation rules, and create functions. You w also import a text file and XML data and manipulate the imported text. Finally, you wall modify the document properties, insert a comment and mark the workbook as final. EInstructions: For the purpose of grading the project you are required to perform the following tasks: step Start Excel. Open exploring ecap grader 2Transactions.xtor and save the workbook as exploring ecap grader c2 Transactions tastFirst. On the luneTotals workssheet, sort the data in the range A3 E16 in ascending order by Category. At each change in Category, use the Sum function to add subtotals to the data in the Amount column. Accept all other defaults. Collapse the outine to show the grand total and Category subtotals only Create a Pivet Table in cel FI on the AnnualExn worksheet using the data in the range AI:D17. Add the Expense field to the PvotTable as a row label:; add the Amount field as the value; add the Year field as the colume label. Change the format of the values in the PlwokTable to accounting with no decimal places and set columns Fal to AutoFt Column Width Add the Cabegory field to the Report Fiter area of the PivotTable. Filter the data so that only expenses in the vartie category are displayed. Digay the vales as percentages of the grand total, 4 Ireert a Year slicer in the worksheet and use the sicer to flter the data so that only data from let corner aligns with the top left corner of cell 12. Create a PiwotChart based on the data in the PvotTable using the default Pie chart type. S 2015 is deplayed. Change the height of the slicer to 2" and then reposition it so that the top Change the chart title tesxt to Variable Expenses and remove the legend. Add data labels to the outside end position displaying only the category names and leader ines, Reposition the chart so that the top left corner On the Homelsan worksheet, in cell A1o, enter a reference to the monthly payment from column B. Create a one variable data table for the range A9:H20 using the interest rate from celumn B as the Row input cell On the Homeloan worksheet in cell A12, enter a reference to the monthly payment from column B as the Row input cell and the term in months from column B as the Column input data table in the range A12:H16, using the interest rate from On the HotmeLoan worksheet, perform a goal seek analysis to determine what the down payment in column 8 needs to be you want the monthly payment in column B to be 2000o. Accept the solution EX16_XL_COMP GRADER CAP_HW -Stock Transactions 1.6 Project Description: I this project, you will update a workbook to display bank transactions as a PivotTable. You will fater the Pivot Table, format the values, display the values as cakculations, and create a PivotChart using this data. Additionally you will sort and subtotal data, create data tables, and use Goal Seek and Scenario Manager. You wil format grouped worksheets, set up validation rules, and create functions. You w also import a text file and XML data and manipulate the imported text. Finally, you wall modify the document properties, insert a comment and mark the workbook as final. EInstructions: For the purpose of grading the project you are required to perform the following tasks: step Start Excel. Open exploring ecap grader 2Transactions.xtor and save the workbook as exploring ecap grader c2 Transactions tastFirst. On the luneTotals workssheet, sort the data in the range A3 E16 in ascending order by Category. At each change in Category, use the Sum function to add subtotals to the data in the Amount column. Accept all other defaults. Collapse the outine to show the grand total and Category subtotals only Create a Pivet Table in cel FI on the AnnualExn worksheet using the data in the range AI:D17. Add the Expense field to the PvotTable as a row label:; add the Amount field as the value; add the Year field as the colume label. Change the format of the values in the PlwokTable to accounting with no decimal places and set columns Fal to AutoFt Column Width Add the Cabegory field to the Report Fiter area of the PivotTable. Filter the data so that only expenses in the vartie category are displayed. Digay the vales as percentages of the grand total, 4 Ireert a Year slicer in the worksheet and use the sicer to flter the data so that only data from let corner aligns with the top left corner of cell 12. Create a PiwotChart based on the data in the PvotTable using the default Pie chart type. S 2015 is deplayed. Change the height of the slicer to 2" and then reposition it so that the top Change the chart title tesxt to Variable Expenses and remove the legend. Add data labels to the outside end position displaying only the category names and leader ines, Reposition the chart so that the top left corner On the Homelsan worksheet, in cell A1o, enter a reference to the monthly payment from column B. Create a one variable data table for the range A9:H20 using the interest rate from celumn B as the Row input cell On the Homeloan worksheet in cell A12, enter a reference to the monthly payment from column B as the Row input cell and the term in months from column B as the Column input data table in the range A12:H16, using the interest rate from On the HotmeLoan worksheet, perform a goal seek analysis to determine what the down payment in column 8 needs to be you want the monthly payment in column B to be 2000o. Accept the solution
