Answered

Select the correct answer.
Tom teaches at a high school. He wishes to sort a spreadsheet that contains students' scores in various subjects in descending order of total scores.
While sorting the spreadsheet, what should he do before clicking the Sort option from the menu?
O A.
select the data to sort
B.
arrange the data alphabetically
C.
filter the data to sort
OD. highlight the data to sort in a specific color
O E. divide the text and number data into separate columns



Answer :

GinnyAnswer

Final answer:

To sort data in Excel, select the data to be sorted and then use the Sort option under the Data menu.


Explanation:

Before clicking the Sort option in Excel, Tom should:

  1. Select the data he wishes to sort, ensuring not to include the header row.
  2. After selecting the data, he should proceed to click on the Sort option under the Data menu at the top of the screen.
  3. Next, Tom should enter the field by which he wants to sort in the provided space and select Values in the 'Sort On' field.

Learn more about Excel data sorting here:

https://brainly.com/question/37598526