Case 2-2 Antoinette Is Part of a College Department Creating a Number

question 42

Multiple Choice

Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.

• A) cell formatting
• B) conditional formatting
• C) highlighting
• D) fill color

---

Definitions:

Equilibrium Price

The price at which the quantity of a good or service demanded equals the quantity supplied, resulting in market balance.

Surplus

A situation where the quantity of a product or service supplied exceeds the quantity demanded at the current price.

Maximum Price

A price ceiling set by the government or another regulatory body, beyond which prices cannot legally rise for essential goods or services.

Economic Impact

The effect of an event, policy, or market change on the economy, which can be measured in terms of changes in employment, GDP, or other economic indicators.