Sarah, Who Has Been an Apparel Retailer for Ten Years

question 61

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

---

Definitions:

Generational Differences

The variances in attitudes, behaviors, expectations, habits, and values that exist among generations within a society.

Romantic Love

An intense emotional and physical attraction towards another person often characterized by passion, intimacy, and commitment.

Traditional Family

A social unit typically consisting of parents and their children, where relationships are defined by blood or law.

United States

The United States is a federal republic in North America, consisting of 50 states, a federal district, five major territories, and various possessions, known for its significant cultural and economic influence globally.