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' A 1 Sales Rep Region Specialty Sales (units) 2 Tom Brady Northeast Toys 115 3 Michell Joordan Northeast Toys 121 4 Tom Braedy Northeast Toys 290 5 Drew Breeze Souteast Gadgets 585 6 Tom Braedy Northeast Plumbing 1027 7 Drew Breeze Northeast Toys 1081 8 Tom Brady Souteast Gadgets 923 9 Michell Jordan Northeast Toys 541 10 Tom Braedy Souteast Plumbing 418 11 Michell Joordan Central Toys 1155 12 Michell Joordan Central Gadgets 436 13 Michell Joordan Souteast Plumbing 815 14 Drew Breeze Central Toys 153 15 Tom Brady Northeast Gadgets 630 16 Michell Joordan Souteast To 924 17 Michell Joordan Central Gadgets 295 18 Tom Braedy Northeast Toys 987 19 Drew Breeze Central Toys 985 20 Tom Braedy Souteast Toys 1033 21 Drew Breeze Northeast Gadgets 164 22 Tom Brady Souteast Plumbing 331 23 Drew Breeze Northeast Plumbing 1056 24 Tom Braedy Central Toys 226 25 Michell Joordan Northeast Gadgets 576 26 Tom Braedy Souteast Gadgets 685 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. 1 D Sales Rep Region Specialty Sales (units) 2 Tom Brady Northed Toys 4 Tom Brady Northeast Plumbing 1027 5 Drew Breeze Northeast Toys 1081 9 Michell Joordan Central Toys 1155 19 Tom Braedy Souteast Toys 1033 23 Drew Breeze Northeast Plumbing 1086 Worksheet 3 (Number-Filter) 1. Conditionally format the sales units by the 'top 10 items!. (10 salespeople). 2. Filter by the top 5 items. D 1 Sales Rep Region Special Sales (unir 4 Tom Brady Northeast Plumbing 1027 s Drew Breeze Northeast Toys 1081 9 Michell Joordan Central Toys 1155 19 Tom Brady Souteast Toys 1033 23 Drew Breeze Northeast Plumbing 1086