Cali Has Just Discovered the Power of Using Text Filters

question 62

Multiple Choice

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 named Cathy,Carla,and Carey,what should she do?

• A)Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value.
• B)Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value.
• C)Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value.
• D)Create a text filter using the Contains operator to display all records that include Ca in the text value.

---

Definitions:

Market Imperfection

Any deviation from the ideal conditions of a fully competitive market, which may lead to inefficient market outcomes.

Persistent Wage Differentials

The continuous difference in wages across sectors, regions, or occupations due to factors like differences in skill levels, working conditions, or geographic location.

Principal-Agent Problems

Issues that arise when a principal hires an agent to perform tasks, and the agent's best interest does not align with the principal's.

Human Capital

The skills, knowledge, and experience possessed by an individual or population, viewed in terms of their value to an organization or society.