Case-Based Critical Thinking Questions

question 40

Multiple Choice

Case-Based Critical Thinking Questions
Case 5-2
Simon has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number.
-If Simon wants to find all of his colleagues whose last names end in "berg" (such as Goldberg and Steenberg) ,what should he do?

• A) Create a text filter using the Ends With operator to display all records that have dberg as the last characters in the text value.
• B) Create a text filter using the Contains operator to display all records that include berg in the text value.
• C) Create a text filter using the Ends With operator to display all records that have berg as the last characters in the text value.
• D) Create a text filter using the Contains operator to display all records that have berg as the last characters in the text value.

---

Definitions:

Carrying Value

Carrying Value, also known as book value, is the value of an asset as it appears on a balance sheet, calculated by netting the asset against its accumulated depreciation.

Nonvoting Preferred Stock

A type of preferred stock that does not grant the holder voting rights in the company's shareholder meetings, typically in exchange for certain financial preferences.

Outstanding Shares

The total number of shares of stock that are currently owned by shareholders, including shares held by institutional investors and restricted shares held by insiders and company officers.

Balance Sheet

An accounting statement that captures the financial standing of a corporation by itemizing assets, obligations, and shareholders' capital at a certain time.