Case-Based Critical Thinking Questions Case 5-2 Cali Has Just Discovered

question 59

Multiple Choice

Case-Based Critical Thinking Questions Case 5-2 Cali 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 camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number. If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson) , what should he do?

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

---

Definitions:

Total Tax Rate

The combined rate of all the taxes that an individual or business is liable to pay, expressed as a percentage of income.

Average Tax Rate

The ratio of total taxes paid to total income, indicating the share of income that goes to taxes.

After-Tax Distribution

The amount of money shareholders receive from a corporation's earnings after all applicable taxes have been deducted.

Before-Tax Distribution

Refers to the allocation of income among individuals or entities before accounting for taxes.