Answer:
The correct sequence of steps in sorting text is;
III, IV, I and II
Which is option 'C' where the last item is II
C. III, IV, I and II
Explanation:
Sorting is the orderly arrangement of items (data) according to a specified criteria such as arranging a list of items alphabetically or a numerical arrangement of a data collection
Filtering is the selection for display, data that meets a specific condition
To arrange the names of the participants of the two-day virtual seminar alphabetically using MS Excel the sequence of steps are;
1. Select the rows or columns the are to be sorted by using steps for selecting rows and/or columns
2. Go to the Editing group of the Home Tab ribbon
3. Click on (the down arrow besides) the Sort & Filter command icon to display a drop down menu with options for type of sorting and filtering
4. Choose Sort A to Z to sort the contents of the cell range in increasing alphabetical order
Therefore, the correct sequence of steps are;
III. Select the cell range needed to be sorted
IV. Go to the Editing Styles group of the Home Tab
I. Click the Sort & Filter command. A drop down menu appears
II. Choose Sort A to Z.
The correct sequence is III, IV, I and II.
