Project Analysis Worksheet

470 Words2 Pages
Sports Programs Project Description: In this project, you will create a worksheet for the Assistant Director of Athletics at Capital Cities Community College to analyze the available sports programs. To complete the project, you will sort and filter data, subtotal and group data, and apply themes to multiple worksheets. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Download, save, and open the Excel workbook named GO_e05_Grader_EOC.xlsx. | 0 | 2 | On the Harbor-Jefferson-Capital worksheet, sort the values in the Campus column using a custom sort order list. Use the following order: Harbor, Jefferson, and then Capital. | 9 | 3…show more content…
| 6 | 4 | Convert the table to a range. | 4 | 5 | Display the Sport Season Comparison worksheet. Name the range A2:F3 using the name Criteria. Name the range A6:F15 using the name Database, and then name the range A18:F18 using the name Extract. | 9 | 6 | In cell D3, type Fall and in cell E3, type Summer. Create an advanced filter that will copy all records from the Database range with Fall as their primary season and Summer as their secondary season to the range A18:F18. | 8 | 7 | Display the Stipends by Group worksheet. Sort the data in ascending order first by Coach Stipend and then by Group. | 6 | 8 | Subtotal the data on the Stipends by Group worksheet at each change in Group using the Sum function. Add the subtotals to the Coach Stipend column. | 9 | 9 | Collapse the outline so that the Level 2 summary information is displayed, and then autofit column D. | 4 | 10 | Select all three worksheets and modify the page setup so that each worksheet fits on one page and is centered horizontally. | 9

More about Project Analysis Worksheet

Open Document