Mila Wants to Specify What Data Users Can Enter in a Table

question 428

Multiple Choice

Mila wants to specify what data users can enter in a table column.What Excel feature should she use?

• A) Table filters
• B) VLOOKUP function
• C) Multilevel sort
• D) Data validation

---

Definitions:

Investment

The allocation of resources, usually money, in the expectation of generating an income or profit.

Personal Expense

Expenses incurred by individuals for non-business-related activities, often not tax-deductible.

Goodwill Method

An accounting approach for handling goodwill during a business combination, where goodwill is not amortized but tested annually for impairment.

Capital Balances

The amounts shown in a company’s books representing the capital owned by partners or shareholders.