| Name: | Kourtney Lynch | |
| Date done: | Tuesday, September 14, 2021[1] | |
| Today is: | Wednesday, October 27, 2021 | |
| Days Since | Saturday, January 0, 1900 | |
| Task # | Task (most done on the "Combined" sheet) | |
| 1 | Open this file, and save it on your C: drive | x |
| 2 | Format the Field names in Row 1 with Bold, Center, Wrap Text. Adjust all columns appropriately | x |
| 3 | Add "Freeze Panes" so you can view the field names as you scroll down through the records | x |
| 4 | Sort the records by "Title" | x |
| what is the 1st record? | Abnormal Psychology | |
| what is the last record? | Worship: Foretaste Heaven-EC | |
| 5 | How many total courses are there? | 462 |
| 6 | How many courses have a "wait list"? | 40 |
| 7 | What percent of total records is this? | 8.67% |
| 8 | How many courses are "Senior level" courses? | 94 |
| 9 | How many different "Departments" are there? | 44 |
| 10 | How many different "Instructors" teach at Loras? | 141 |
| 11 | How many "Online" classes are there? | 17 |
| 12 | Which building has the most courses (not including the Online courses)? | HOFF |
| 13 | How many different courses are offered at 10:00 am on MWF? | 33 |
| 14 | Insert two new rows above the field names | x |
| 15 | Type in a number in row 1 above the % Cap, e.g. 90% | x |
| 16 | Use a Conditional Format to highlight this number, as well as all the capacities that are equal or above this number | x |
| 17 | Group both sheets, and add the proper headers & footers to these sheets | |
| 18 | Ungroup the sheets; use "Rows to Repeat" on the Combined sheet | x |
| 19 | Go to the Combined sheet, change the L & R margin to 0.2, Orientation to Landscape, and adjust the print to print just 1 page wide | x |
| 20 | Save and turn in your work | x |