Astudent 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