Susan is a bookstore owner who maintains sales records in a spreadsheet. She wants to highlight the records that show sales in excess of 100 books per day. Which spreadsheet feature will enable her to highlight the records?

The

feature of the spreadsheet will enable Susan to highlight the records.

Conditional formatting will enable her to highlight the records with sales in excess of 100.

Explanation:

On the ribbon home button select conditional formatting. A menu will open to select highlight type. Next select a conditional operator. You can select an operator from that menu or define your own custom rule. Next select column to apply rule on and specify color coding (green) for matched results. Press Ok and close window. Now all the cell with sale in excess will be highlighted in the color coding specified earlier (green).