When you sort a table on the Department and then the Last Name columns, Excel first sorts the records by Department, and then sorts by Last Name within each Department.
Correct Answer:
Verified
Q26: To select a table to copy it
Q343: The Remove Duplicates tool locates and deletes
Q344: To remove duplicate values from an Excel
Q345: A teacher creates a table of student
Q347: Banded Rows applies banding to table rows
Q349: Sophia has a table with a column
Q350: When you remove duplicate records from a
Q351: A teacher creates a table for Sports
Q352: Which of the following conditional formatting types
Q353: Warren has a table that applies fill
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents