A worksheet contains a list of graduates at your university. The worksheet contains these columns in this sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by College, then by Major, and then by Student Last Name. What is the default At a change in setting within the Subtotal dialog box, and what would be a more appropriate setting?

A worksheet contains a list of graduates at your university. The worksheet contains these columns in this sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by College, then by Major, and then by Student Last Name. What is the default At a change in setting within the Subtotal dialog box, and what would be a more appropriate setting?


A. College (default field), Student Last Name (correct field)
B. Student First Name (default field), Student Last Name (correct field)
C. Student Last Name (default field), College (correct field)
D. Student Last Name (default field), GPA (correct field)


Answer: C. Student Last Name (default field), College (correct field)


Learn More :