Nathan Is in Charge of Collections, and Is Putting Together

question 55

Multiple Choice

Nathan is in charge of collections, and is putting together a list of customers to call. Please refer to the figure above as you answer the questions below.
-One of the daily reports that is delivered to management every day lists any customer who has a balance due of $100,000 or more. If the customer has a high balance, the formula should return due date. Otherwise, the cell is left blank. Assuming that the balance due is in column D in the spreadsheet above, what would the formula look like?

• A) =IF(D5=100000,B5, " ")
• B) =IF(D5<99999,B5," ")
• C) =IF(D5>=100000,B5," ")
• D) =IF(D5," ",B5)

---

Definitions:

Illegal Drugs

Substances whose production, sale, or possession are prohibited by law due to their potential effects on users' health or society.

Freshman Year

Freshman Year is the first year of a student's journey in high school or college, marking a significant transition period.

Overconfidence

A cognitive bias where an individual's subjective confidence in their judgments is greater than the objective accuracy of those judgments.

Stockbrokers

Professionals who buy and sell stocks and other securities for clients in exchange for a fee or commission.