#$12.$

Data file:

Purchase Orders.

Use Excel's filtering capability to extract records and answer the following questions.

$($a$)$ Extract all the orders for item control panels,

Total number of units of control panels is:

Average number of units in an order for control panels is:

$($b$)$ Extract all the orders for order quantities less than $500$ units per order.