need workbook attached filled in from information provided by instructions in excel.

Office 2013 - myitlab:grader - Instructions GO! - Excel Chapter 5: Homework Project 3 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 Points Possible Instructions 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 Select all three worksheets and modify the page setup so that each worksheet fits on one page and is centered horizontally. 9 10 Updated: 06/12/2013 1 E_CH05_GOV2_H3_Instructions.docx Office 2013 - myitlab:grader - Instructions Step GO! - Excel Chapter 5: Homework Project 3 Points Possible Instructions 11 With all worksheets still selected, change the theme to Slice. 9 12 With all worksheets still selected, change the font theme to Corbel. 9 13 With all worksheets still selected, add the Sheet Name element to the center section of the footer, using the PAGE LAYOUT tab. 6 14 Ungroup the worksheets and display the Valley-Park-West worksheet. In cell J1, insert a hyperlink to the downloaded e05G_Coach_Information.xlsx workbook. Enter the text Click here for contact information as the ScreenTip for the hyperlink. 9 15 Change the font color for cell J1 to Orange, Accent 5, Darker 25%. 3 16 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Valley-Park-West, Sports Season Comparison, Stipends by Group. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 06/12/2013 2 100 E_CH05_GOV2_H3_Instructions.docx Coach Tom Nielsen Jan Peterson Jim Wilson Camille Navarre Raoul Zarn Rachael Weiss Seth Thompson Nan Loganof Travis Marshack Chuck Matthews Mark Buehlen Jacob Weinstein Sandra Oden Lupe Santos Kim Lammers Matt Phillips Barbara Sarto Xavier Sanchez Mary Obester Bo Janho Marcia Lui Bob Bittelongan Frieda Brzenski Sam Walsh Karol Jess Jef Davidson Jose Hernandez Linda Astor Rick Hiltz Gladys Merton Nancy Kile Judy Wright Dwayne Michaels Josh Moore Tim Devereaux Breanne Powell Adam Rodgers Anne Firestone Miguel Valdinos Phone (703) 555-0123 (703) 555-0342 (703) 555 0876 (703) 555-7626 (703) 555-0777 (703) 555-0787 (703) 555-0679 (703) 555-0880 (703) 555-0934 (703) 555-0581 (703) 555-0282 (703) 555-0785 (703) 555-0748 (703) 555-0756 (703) 555-0768 (703) 555-0081 (703) 555-0707 (703) 555-0688 (703) 555-0290 (703) 555-0291 (703) 555-0292 (703) 555-0293 (703) 555-0294 (703) 555-0295 (703) 555-0296 (703) 555-0297 (703) 555-0298 (703) 555-0299 (703) 555-0300 (703) 555-0301 (703) 555-0302 (703) 555-0303 (703) 555-0304 (703) 555-0305 (703) 555-0306 (703) 555-0307 (703) 555-0308 (703) 555-0309 (703) 555-0310 Office HR 320-A HR 322-A HR 325-B HR 325-C HR 323-D HR 323-A HR 322-C HR 323-A HR 324-C HR 324-C HR 323-B HR 323-A HR 322-B HR 324-A HR 320-B HR 325-D HR 323-D HR 324-B HR 323-B HR 323-B CT 320-A CT 322-A CT 325-B CT 325-C CT 323-D CT 323-A CT 322-C CT 323-A CT 324-C CT 324-C CT 323-B CT 323-A CT 322-B CT 324-A CT 320-B CT 325-D CT 323-D CT 324-B CT 323-B Email tnielsen@capcc.edu jpeterson@capcc.edu jwilson@capcc.edu cnavarre@capcc.edu rzarn@capcc.edu rweiss@capcc.edu sthompson@capcc.edu nloganoff@capcc.edu tmarshack@capcc.edu cmatthews@capcc.edu mbuehlen@capcc.edu jweinstein@capcc.edu soden@capcc.edu lsantos@capcc.edu klammers@capcc.edu mphillips@capcc.edu bsarto@capcc.edu xsanchez@capcc.edu mobester@capcc.edu Bjanho@capcc.edu mlui@capcc.edu bbittelongan@capcc.edu fbrzenski@capcc.edu swalsh@capcc.edu kjess@capcc.edu jdavidson@capcc.edu jhernandez@capcc.edu lastor@capcc.edu rhiltz@capcc.edu gmerton@capcc.edu nkile@capcc.edu jwright@capcc.edu dmichaels@capcc.edu jmoore@capcc.edu tdevereaux@capcc.edu bpowell@capcc.edu arodgers@capcc.edu afirestone@capcc.edu mvaldinos@capcc.edu Status FT FT FT PT PT FT FT FT FT FT FT FT PT FT FT PT FT FT FT FT FT FT PT PT FT FT FT FT FT FT FT PT FT FT PT FT FT FT FT Program Name Soccer - Men Soccer - Women Basketball - Men Rugby - Men Basketball - Women Wrestling - Men Field Hockey - Women Jr. Baseball - Freshmen Men Diving - Men Jr. Tennis - Freshmen Men Jr. Tennis - Freshmen Women Jr. Golf - Freshmen Men Program No. 13258 14386 46395 28965 65485 19375 12459 65377 47523 25436 54896 48539 Sport Group Field Field Court Field Court Court Field Field Water Court Court Field Program Preview Days M M F W F W M TR W TR W W Time 0100-0400 0900-1200 0900-1200 0100-0400 0900-1200 0900-1200 0100-0400 0100-0400 0900-1200 0100-0400 0100-0400 0900-1200 Room CC607 EC101 CC607 EC101 WC300 WC300 EC101 CC607 EC101 EC101 CC607 EC101 Seats 30 30 30 30 30 30 30 30 30 30 30 30 Enrolled 10 12 10 11 8 7 13 20 14 6 10 7 Campus Valley Valley Valley Park Valley Park Park West Park West West West Coach Tom Nielsen Jan Peterson Jim Wilson Jeff Davidson Camille Navarre Jose Hernandez Linda Astor Josh Moore Rick Hiltz Tim Devereaux Breanne Powell Adam Rodgers Criteria Program Name Group Group Office Co. Primary Season Number Secondary of Season Students Group Office Co. Primary Season Secondary Number of Season Students Sports Season Program Name Soccer Basketball Baseball Softball Football Tennis Volleyball Golf Cross Country Group Field Court Field Field Field Court Court Other Field B242 B242 R100 R100 R100 C250 C250 C250 C250 Fall Fall Spring Fall Spring Fall Fall Fall Fall Spring Summer Summer Summer Summer Summer Spring Summer Spring 48 35 18 28 41 42 19 40 35 Fall - Summer Sports Season Program Name Group Group Office Co. Primary Season Number Secondary of Season Students Coaching Stipends Group No. 13258 14386 46395 65485 85234 57823 77622 47593 74625 30303 20115 85249 47523 12968 Program Soccer - Men Soccer - Women Basketball - Men Basketball - Women Baseball - Men Softball - Women Swimming - Men Swimming - Women Gymnastics - Men Gymnastics - Women Golf - Men Golf - Women Diving - Men Diving - Women Group Field Field Court Court Field Field Water Water Court Court Other Other Water Water Coach Stipend $6,000 $6,000 $7,000 $5,000 $5,000 $6,000 $6,000 $7,000 $6,000 $7,000 $5,000 $7,000 $6,000 $6,000