When You Define the Criteria Range and the Copy-To Location

question 48

Multiple Choice

When you define the criteria range and the copy-to location in the Advanced Filter dialog box,Excel automatically creates which two range names?

• A) Criteria and Copy-To
• B) Criteria and Extract
• C) Data and Copy-To
• D) Data and Extract

---

Definitions:

Percentage-Of-Completion Method

An accounting method used to recognize revenues and expenses of long-term contracts in proportion to the work completed.

Contract Costs

Expenses directly related to securing and fulfilling a contract, including raw materials, labor, and overhead.

Percentage-Of-Completion Method

An accounting method used to recognize revenues and expenses of long-term projects proportionally to the degree of completion.

Long-Term Contracts

Agreements that extend over a long period, often used in industries like construction or supply services, specifying performance obligations and payment terms.