7. The conditional formatting rule in column G highlights cells that contain the value 5, the highest evaluation rating. Padma wants to change the highlighting to use colors that are associated with positive values. Edit the conditional formatting Highlight Cells Rule for the range G5:652 to highlight the cells containing values equal to 5 with a font color of Teal, Accent 2, Darker 50% (6th column, 6th row in the Theme Colors palette) and a fill color of Teal, Accent 2, Lighter 60% (6th column, 3rd row in the Theme Colors palette). 8. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2022, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell 45. Clear the conditional formatting rule from the range H5:H52 if Excel applies it. 9. Padma asks you to make it easy to filter the table based on the contractor's specialty and starting year. Insert two slicers, one based on the Specialty field and the other based on the Start Year field. 10. Resize both slicers to a height of 2.2" and a width of 1.5". Move the Specialty slicer so its upper-left corner is in cell 14 and its lower-right corner is in cell 114. Move the Start Year slicer so its upper-left corner is in cell 34 and its lower-right corner is in cell J14. 11. Use the slicers to filter the Contractors table to show contractors who started in 2021 or 2022 with specialties of Electronics and Movies and music. 12. Since Padma is using slicers to filter the data, hide the filter buttons in the Contractors table. 1 Contractors Contractor List 2 2021 3 4 First Last 5 c7469 Howard Agbaje 6 C7972 Nikita Amiri 71c6541 Hunter Baker 3 C3571 Kirstin Bohner c7075 Bradley Bowers LOC1885 Victorina Cobblewick . -1 c3923 Blake Collins . 2c5486 Maria Conner M. 304412 Marguerite Cortez 4 c5228 Laverne Custer 2o Lave 503948 Nancy Dereda . 609888 Louise Diallo 71c3049 Ruth Dudusola pono L8C9808 Marilyn Frazier _909808 Marilyn Frazier 0c7466 Donnie Grazia 1 C8031 Reid Greene when 2c6771 Carin Hall 304573 Pete Hamadache Los =41c4218 Nhung Hong - 1521722 Thanh Hue 606071 Melissa Jensen be 71c5356 Eun Johns 8 C8508 Hannah Johnson 9c1438 Lenard Kalende sol c1922 Rusty 1922 Rusty Lawson +12469 ber 1 -2489 Bert Leonard 21.2463 Rashad Mahala Manala 21-2463 Rashad 3104317 Anita Melander 4104614 William 41-4614 William Miller 5c5847 Anne Moussa 6c8597 Joanna Munisi =7c8686 Everett Murray 817251 Fernanda Ne 906664 Susan usan Olson 10c2326 Vashti 012320 Van Popoola 1165261 Jarvis Ransom 15261 Jarvis 2109453 Bobby 29453 BODDY Rodgers 3104986 Elicia 3124986 Elica settles 1405455 Long Sow 5c6084 Phc venue Trang 16104865 My +624863 MY Van 71c5496 Mai Vang 18c5117 Shantelle Washington 19-2158 Craig Waters 0 06406 Gregg Watts 1 04866 Jack Westerman 2c3217 Jarod Whetstone 3 c2525 Luna Zimmerman 64 Product Specialty 5 Automotive 66 Clothing and shoes 57 Electronics 58 Garden and home 99 Movies and music 50 Sports and outdoors 51 52 Specialty Electronics Automotive Automotive Clothing and shoes Sports and outdoors Clothing and shoes Movies and music Garden and home Garden and home Movies and music Sports and outdoors pons and Sports and outdoors Electronics Garden and home Garden and home Electronics Movies and music ma Sports and outdoors Movies and music Clothing and shoes Movies and music Sports and outdoors Automotive Movies and music Movies and music Automotive Electronics Garden and home Electronics Automotive Automotive Automotive Movies and music Clothing and shoes Clothing and shoes Clothing and shoes Sports and outdoors Sports and outdoors Electronics Garden and home Clothing and shoes Automotive Garden and home Garden and home Movies and music Electronics Electronics Movies and music Electronics Automotive Garden and home Category 1 Start Year Pav Catero Eval Rati 2019 2018 2 4 2021 3 3 2017 1 5 2021 3 3 - 2020 2 4 2021 2 4 2020 1 5 - 2017 2 4 2018 1 5 2021 2 4 2020 3 3 2017 2 2 2018 1 5 2022 1 5 - 2020 2 4 2017 2 4 2021 2 4 2017 1 5 2022 1 5 - 2022 2 4 3 3 2021 3 3 2020 2 4 4 2020 2024 1 5 2017 2011 1 5 2011 2017 1 5 2011 2017 1 5 2019 2019 1 5 2021 202 1 5 2015 2019 1 5 2020 2024 3 3 2021 202 2 - 4 2022 2024 3 3 202 2021 - 2. 4 2011 2017 1 5 2024 2020 2 - 4 2017 2011 3 3 2017 2011 1 5 2020 1 5 2021 202 3 3 2018 4 2 2010 2022 2024 1 3 2020 2024 2 4 2020 2024 2 4 4 2020 2024 2 4 2021 1 5 2020 3 3 2020 2 4 Min per Post $50 $100 $200 $100 $125 $150 Automotive 2 3 2 2 3 7. The conditional formatting rule in column G highlights cells that contain the value 5, the highest evaluation rating. Padma wants to change the highlighting to use colors that are associated with positive values. Edit the conditional formatting Highlight Cells Rule for the range G5:652 to highlight the cells containing values equal to 5 with a font color of Teal, Accent 2, Darker 50% (6th column, 6th row in the Theme Colors palette) and a fill color of Teal, Accent 2, Lighter 60% (6th column, 3rd row in the Theme Colors palette). 8. Padma wants to list the number of years each contractor has been working for Veritate. Insert a column to the right of the Eval Rating column. Use Years as the column heading. In cell H5, insert a formula without a function that uses a structured reference to subtract the Start Year from 2022, the current year. If Excel does not automatically copy the formula to the other cells in column H, fill the range H6:H52 with the formula in cell 45. Clear the conditional formatting rule from the range H5:H52 if Excel applies it. 9. Padma asks you to make it easy to filter the table based on the contractor's specialty and starting year. Insert two slicers, one based on the Specialty field and the other based on the Start Year field. 10. Resize both slicers to a height of 2.2" and a width of 1.5". Move the Specialty slicer so its upper-left corner is in cell 14 and its lower-right corner is in cell 114. Move the Start Year slicer so its upper-left corner is in cell 34 and its lower-right corner is in cell J14. 11. Use the slicers to filter the Contractors table to show contractors who started in 2021 or 2022 with specialties of Electronics and Movies and music. 12. Since Padma is using slicers to filter the data, hide the filter buttons in the Contractors table. 1 Contractors Contractor List 2 2021 3 4 First Last 5 c7469 Howard Agbaje 6 C7972 Nikita Amiri 71c6541 Hunter Baker 3 C3571 Kirstin Bohner c7075 Bradley Bowers LOC1885 Victorina Cobblewick . -1 c3923 Blake Collins . 2c5486 Maria Conner M. 304412 Marguerite Cortez 4 c5228 Laverne Custer 2o Lave 503948 Nancy Dereda . 609888 Louise Diallo 71c3049 Ruth Dudusola pono L8C9808 Marilyn Frazier _909808 Marilyn Frazier 0c7466 Donnie Grazia 1 C8031 Reid Greene when 2c6771 Carin Hall 304573 Pete Hamadache Los =41c4218 Nhung Hong - 1521722 Thanh Hue 606071 Melissa Jensen be 71c5356 Eun Johns 8 C8508 Hannah Johnson 9c1438 Lenard Kalende sol c1922 Rusty 1922 Rusty Lawson +12469 ber 1 -2489 Bert Leonard 21.2463 Rashad Mahala Manala 21-2463 Rashad 3104317 Anita Melander 4104614 William 41-4614 William Miller 5c5847 Anne Moussa 6c8597 Joanna Munisi =7c8686 Everett Murray 817251 Fernanda Ne 906664 Susan usan Olson 10c2326 Vashti 012320 Van Popoola 1165261 Jarvis Ransom 15261 Jarvis 2109453 Bobby 29453 BODDY Rodgers 3104986 Elicia 3124986 Elica settles 1405455 Long Sow 5c6084 Phc venue Trang 16104865 My +624863 MY Van 71c5496 Mai Vang 18c5117 Shantelle Washington 19-2158 Craig Waters 0 06406 Gregg Watts 1 04866 Jack Westerman 2c3217 Jarod Whetstone 3 c2525 Luna Zimmerman 64 Product Specialty 5 Automotive 66 Clothing and shoes 57 Electronics 58 Garden and home 99 Movies and music 50 Sports and outdoors 51 52 Specialty Electronics Automotive Automotive Clothing and shoes Sports and outdoors Clothing and shoes Movies and music Garden and home Garden and home Movies and music Sports and outdoors pons and Sports and outdoors Electronics Garden and home Garden and home Electronics Movies and music ma Sports and outdoors Movies and music Clothing and shoes Movies and music Sports and outdoors Automotive Movies and music Movies and music Automotive Electronics Garden and home Electronics Automotive Automotive Automotive Movies and music Clothing and shoes Clothing and shoes Clothing and shoes Sports and outdoors Sports and outdoors Electronics Garden and home Clothing and shoes Automotive Garden and home Garden and home Movies and music Electronics Electronics Movies and music Electronics Automotive Garden and home Category 1 Start Year Pav Catero Eval Rati 2019 2018 2 4 2021 3 3 2017 1 5 2021 3 3 - 2020 2 4 2021 2 4 2020 1 5 - 2017 2 4 2018 1 5 2021 2 4 2020 3 3 2017 2 2 2018 1 5 2022 1 5 - 2020 2 4 2017 2 4 2021 2 4 2017 1 5 2022 1 5 - 2022 2 4 3 3 2021 3 3 2020 2 4 4 2020 2024 1 5 2017 2011 1 5 2011 2017 1 5 2011 2017 1 5 2019 2019 1 5 2021 202 1 5 2015 2019 1 5 2020 2024 3 3 2021 202 2 - 4 2022 2024 3 3 202 2021 - 2. 4 2011 2017 1 5 2024 2020 2 - 4 2017 2011 3 3 2017 2011 1 5 2020 1 5 2021 202 3 3 2018 4 2 2010 2022 2024 1 3 2020 2024 2 4 2020 2024 2 4 4 2020 2024 2 4 2021 1 5 2020 3 3 2020 2 4 Min per Post $50 $100 $200 $100 $125 $150 Automotive 2 3 2 2 3