![]() On the JuneTotals worksheet, sort the data in the range A3:E16 in ascending order by Category. Open exploring_ecap_grader_c2_Transactions.xlsx and save the workbook as FinalExam_YourName ![]() **Make sure you read the entire question, including hints, before you begin each section.įor the purpose of grading the project you are required to perform the following tasks: Step You will format grouped worksheets, set up validation rules, and create functions. Additionally, you will sort and subtotal data, create data tables, and use Goal Seek and Scenario Manager. You will filter the PivotTable, format the values, display the values as calculations, and create a PivotChart using this data. In this project, you will update a workbook to display bank transactions as a PivotTable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |