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