A list is created by the sales manager of a firm,listing the number of sales per week for the current financial quarter.The column for number of sales per week is as follows: 25,37,34,56,44,26,35,35,37.The sales manager wants to find the number of weeks where sales was above 37.Using Excel,he clicks on a cell in the list,on Data (from the menu bar),and on Filter.Subsequently,he clicks on the list box arrow next to the Sales/week column and selects 37.What will his answer be?
A)37
B)2
C)4
D)5

Question

Quizplus · Accepted Answer

Since the manager used the process for the basic Filter function,he would have found the number of weeks where sales was equal to 37,which is 2.

A List Is Created by the Sales Manager of a Firm,listing