Test Bank 20. To track his highest-earning employees, which conditional formatting rule does Kenny apply to his selected data? A. Highlight Cells Rules B. Top/Bottom Rules C. Data Bars D. Color Scales E. Icon Sets 21. Match each range to its conditional formatting rule. North East South West Quarter 1 $762 $876 $983 $753 Quarter 2 $764 $987 $786 $687 Quarter 3 $896 $378 $936 $993 Quarter 4 $783 $987 $598 $734 Quarter 1 Quarter 2 Quarter 3 Quarter 4 North East South West $762 $876 $983 $753 $764 $987 $786 $687 $896 $378 $936 $993 $783 $987 $598 $734 North East South West Quarter 1 $762 $876 $983 $753 Quarter 2 $764 $987 $786 $687 Quarter 3 $896 $378 $936 $993 Quarter 4 $783 $987 $598 $734 North East South West Quarter 1 Quarter 2 $762 $876 $983 $753 $764 $987 $786 $687 Quarter 3 $896 $378 $936 $993 Quarter 4 $783 $987 $598 $734 ABCD A. Between $500 and $800 B. Less than $750 C. Equal to $687 D. Greater than $750 Excel 2019 & 365 Page 3 of 6