Case-Based Critical Thinking Questions

question 80

Multiple Choice

Case-Based Critical Thinking Questions
Case 2-1

Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems.
-If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.

• A) =COUNTIF(E3:E13,"<>1")
• B) =COUNTIF(E3:E13,"=1")
• C) =COUNTIF(E3:E13,">=1")
• D) =COUNTIF(E3:E13,"<1")

---

Definitions:

Default Risk Premium

The additional yield a lender demands to compensate for the risk that the borrower may default on the loan.

Liquidity Premium

Additional yield that investors demand for holding a security that is not easily traded or sold without a significant price reduction.

Maturity Risk Premium

The extra yield that investors demand to compensate for the risk of holding a bond until its maturity date.

T-bonds

Treasury bonds, long-term government debt securities with maturity periods typically over 20 years, offering interest payments semiannually.