Before You Begin: Download the sample spreadsheet: Student
Records.xlsx
Try This: Do the following steps
1. Open the
spreadsheet: Student
Records.xlsx
2. Delete the columns
for Grade and Homeroom Teacher
3. Add the following
students to the bottom of the spreadsheet
4. Sort the Spreadsheet by Class
5. Format with Table Style Light 8 and select “My Table
has Headers”
6. Use the Remove Duplicate Tool
7. Apply conditional formatting to the Percent Column, Column B. Create a new rule and
select 2 color scale.
Pick red for the lowest value and
green for the highest value.
8. Save this as YOUR NAME Works for Me Practice |
||||||||||||||||
| ||||||||||||||||
