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

Question

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

Quizplus · Accepted Answer

Conditional formatting in Excel allows users to automatically apply formatting—such as colors, icons, or data bars—to cells based on the cell's value. In Sarah's case, she can use conditional formatting to highlight cells that meet her specific criteria, such as profits greater than $100.

Sarah, Who Has Been an Apparel Retailer for Ten Years