Excel Essay

469 Words2 Pages
Sports Programs Project Description: In this project, you will create a worksheet for the Assistant Director of Athletics at Laurel 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_h3.xlsx. | 0 | 2 | Sort the values in the Campus column using a custom sort order list. Use the following order: Valley, Park, and then West. | 9 | 3 | Sort the Sport Group column in ascending order as a second level sort in the table, and then sort the Program Name column in ascending order as a third level sort in the table. | 6 | 4 | Convert the table to a range. | 4 | 5 | Display the Sports 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 Group and then by Coach Stipend. | 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 columns C:D. | 4 | 10 | Select all three worksheets and modify the page setup so that each worksheet fits on one page and is centered

More about Excel Essay

Open Document