Question

Pierre has entered marks obtained by the students in all the classes he teaches in a spreadsheet. Now he wants to highlight some data according to his specifications. Which spreadsheet feature should he use

Answer 1

Sorting and Filtering feature .

Step-by-step explanation:

Pierre has used Sorting and Filtering feature in the Microsoft excel to highlight some data according to the specifications.

• Sorting is used to arrange the data in the ascending or in the descending order .following are the steps where we can used sorting feature in the Microsoft excel

• select the range of cell
• Click on data tab
• After that click on sort .

• The filtering feature is used for filtering the data According to the need Following are the steps where we can used sorting feature in the Microsoft excel.

• Select the cell

• Click on data tab

• After that click on filter .