Microsoft
77-420 · Question #6
Sort and Filter Apply a sort and a filter to the table. Cell range B6:F29 Sort Column Zero Scores Order Largest to Smallest Filter Hide students ids with no zero scores.
Sign in or unlock 77-420 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Prepare the Technician Computer Environment
Question
Sort and Filter
Apply a sort and a filter to the table.
Cell range B6:F29
Sort
Column Zero Scores Order Largest to Smallest
Filter
Hide students ids with no zero scores.
Unlock 77-420 to see the answer
You've previewed enough free 77-420 questions. Unlock 77-420 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#sort and filter#table sorting#Excel filter#data organization