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

Question

Quizplus · Accepted Answer

Excel automatically creates the range names "Criteria" and "Extract" when you define the criteria range and the copy-to location in the Advanced Filter dialog box.

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