Solved

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

Related Questions

Q43: The HLOOKUP function searches horizontally _ of

Q44: To clear a filter,click the _.<br>A) Clear

Q45: You can filter records based on information

Q46: The menu that appears when you click

Q47: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying

Q49: To specify a long list of valid

Q50: You often create subtotals with the _

Q51: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB7032/.jpg" alt=" -In the accompanying

Q52: When you create a table,Excel automatically generates

Q53: Use the _ function when you want