1. Use Excel’s filtering capability to (1) extract all orders for control panels, (2) all orders for

1. Use Excel’s filtering capability to (1)
extract all orders for control panels, (2) all orders for quantities of less
than 500 units, and (3) all orders for control panels with quantities of less
than 500 units in the Purchase Orders database.

2. In the Sales Transactions database, use
Excel’s filtering capability to extract all orders that used PayPal, all orders
under $100, and all orders that were over $100 and used a credit card.