When Using Advanced Filtering, Leaving a Cell Empty in the Criteria

question 60

Multiple Choice

When using advanced filtering, leaving a cell empty in the criteria range will return which of the following?

• A)All records
• B)No records
• C)Empty records
• D)#N/A

---

Definitions:

Compensatory Damages

Monetary awards given to a plaintiff to compensate for actual losses or damage incurred, as determined by a court.

Backpay

Compensation for past wages owed to an employee due to wrongful termination, underpayment, or other inappropriate workplace practices.

Criterion-Related Validity

The extent to which a test's scores are correlated with an independent measure or outcome relevant to the intended use of the test.

Objective Criterion

A measurable factor that serves as a basis for decision-making or evaluation, not influenced by personal feelings, interpretations, or prejudice.