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:

Debt Investment

A type of investment where investors lend money to an entity (corporate or governmental) that borrows the funds for a defined period at a variable or fixed interest rate.

Semiannually

Occurring or happening twice a year; every six months.

Face Value

The nominal value printed on a bond or share, distinct from its market value.

Par Value

The face value of a bond or stock, representing the amount the issuer agrees to pay at maturity (for bonds) or as an arbitrary value assigned to shares.