A student wants to use the Advanced Filter dialog box to filter data and then copy it to a new worksheet. What information must be provided in the Advanced Filter box?

the data set, the criteria range, and the copy location

the workbook name, the list range, and the copy location

the list range, the criteria range, and the copy location

the criteria range, the copy location, and the inserted formula