Sarah, Who Has Been an Apparel Retailer for Ten Years

Multiple Choice

Sarah, who has been an apparel retailer for ten years, wants to analyze and compare the monthly profits for the ten years. She fills details such as the year, month, and profit in three columns on an Excel sheet. She wants to highlight the months with a profit of more than $100. In this scenario, Sarah should use the _____ function to highlight the relevant cells at once. ​

A) conditional formatting
B) tatistical
C) Flash Fill
D) Text to Columns