GRADED LP2.2 ASSIGNMENT Download: LP2.2AssignmentDataFile.xlsx located in the Student Resources folder. Background Information: For this assignment, we are going to complete some advanced sorting and filtering based on 3 salespeople in 3 regions. The workbook that you need to download contains 1 worksheet. You will need to work with this data in three different worksheets. Complete the following with each of the worksheets (10 pts each). The end solution is provided. Make sure to match what is shown: Worksheet 1 (Conditional Formatting-Sorting) 1. Conditionally format the bottom 10% of the sales units. (2 salespeople). 2. Sort based on these bottom 10% at the 'top' Worksheet 2 (Cell Attribute-Filter) 1. Conditionally format the sales units that are greater than 1000. (5 salespeople). 2. Filter by the format that you applied in #1. Worksheet 3 (Number-Filter) 1. Conditionally format the sales units by the 'top 10 items'. (10 salespeople). 2. Filter by the top 5 items. BF008 EA LP2.2AssignmentDataFile (3) Sales Rep Tom Braedy Drew Breeze Tom Braedy Drew Breeze Tom Braedy Michell Joordan Tom Braedy Michell Joordan Michell Joordan Tom Braedy Michell Joordan Drew Breeze Tom Braedy Michell Joordan Michell Joordan Tom Braedy Drew Breeze Tom Braedy Drew Breeze Michell Joordan Tom Braedy Drew Breeze Tom Braedy Michell Joordan Tom Braedy Region Specialty Sales (units) Northeast Toys 290 Souteast Gadgets 585 Northeast Plumbing 1027 Northeast Toys 1081 Souteast Gadgets 923 Northeast Toys 541 Souteast Plumbing 418 Central Toys 1155 Central Gadgets 436 Northeast Toys 115 Souteast Plumbing 815 Central Toys 153 Northeast Gadgets 630 Souteast Toys 924 Central Gadgets 295 Northeast Toys 987 Central Toys 985 Souteast Toys 1033 Northeast Gadgets 164 Northeast Toys 121 Souteast Plumbing 331 Northeast Plumbing 1086 Central Toys 226 Northeast Gadgets 576 Souteast Gadgets 685