Which of the Following Can Be Achieved Using the Conditional

question 40

Multiple Choice

Which of the following can be achieved using the conditional formatting function of Excel?

• A)Show only numbers in between 70 and 80 from a list of numbers from 1 to 100.
• B)Remove all rows not corresponding to specified criteria from a list.
• C)Calculate an unknown value from an objective specified in a worksheet.
• D)Differentiate even numbers from a list of even and odd numbers.

---

Definitions:

Macaroni and Cheese

A classic dish made by combining cooked macaroni pasta with a creamy cheese sauce.

Thanksgiving

A national holiday celebrated in several countries, commemorating a feast or giving thanks for blessings, notably observed in the United States on the fourth Thursday in November.

Marginal Utility

The additional satisfaction or utility a consumer receives from consuming one more unit of a good or service.

Total Utility

The total satisfaction or benefit a consumer receives from consuming a particular quantity of a good or service.