Using spreadsheet software,a manager makes a list of the number of employees in each department in his company.The team size column has the following entries in each cell: 3,3,7,13,22,15,26,4.If the manager uses a basic Filter,which of the following can he accomplish?
A)Only hide all rows with a team size below 13.
B)Highlight all cells with a team size greater than 13.
C)Show only production departments with 3 people.
D)Show all management departments with 7 or more people.

Question

Quizplus · Accepted Answer

The basic Filter function filters a list and allows you to hide all the rows in a list except those that match criteria you specify.

Using Spreadsheet Software,a Manager Makes a List of the Number