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
