Antoinette Is Part of a College Department Creating a Number

question 76

Multiple Choice

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:

Unit Cost

The cost incurred to produce, store, and sell one unit of a product or service.

Unit Price

The cost assigned to a single unit of a product or service.

Journal Entries

Records of financial transactions in a company’s accounting system, providing a chronological record.

Periodic Inventory System

An inventory system that updates inventory balance after a certain period, typically incorporating physical counts to determine cost of goods sold.