In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that...

Transcribed Image Text:

In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card. Click the icon to view the sales transactions. Region Payment East Paypal West Credit North Credit West South West East West West South South East North East West West East West North West Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Paypal Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Web Web Email Web Amount 18.61 15.57 22.78 23.24 15.88 17.42 179.24 22.29 17.95 22.25 27.05 21.57 20.26 154.61 21.37 22.85 18.67 21.55 17.07 17.82 Product Book Book DVD Book DVD DVD Book Book DVD DVD Book DVD DVD DVD Book DVD DVD Book DVD Book 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A Region East West North West South West West West South South East North West West East West North West B Payment Paypal Credit Credit Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit C Source Web Web Web Email Web Email Web Web Web Email Web Web Web Web Web Web Email Web D Amount E Product Book Book DVD Book DVD DVD Book DVD DVD Book DVD DVD Book DVD DVD Book DVD Book In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card. Click the icon to view the sales transactions. Region Payment East Paypal West Credit North Credit West South West East West West South South East North East West West East West North West Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Credit Paypal Credit Credit Paypal Paypal Paypal Paypal Credit Source Web Web Web Email Web Email Web Web Web Web Email Web Web Web Web Web Web Web Email Web Amount 18.61 15.57 22.78 23.24 15.88 17.42 179.24 22.29 17.95 22.25 27.05 21.57 20.26 154.61 21.37 22.85 18.67 21.55 17.07 17.82 Product Book Book DVD Book DVD DVD Book Book DVD DVD Book DVD DVD DVD Book DVD DVD Book DVD Book 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A Region East West North West South West West West South South East North West West East West North West B Payment Paypal Credit Credit Paypal Credit Paypal Credit Paypal Paypal Paypal Credit Paypal Credit Paypal Paypal Paypal Paypal Credit C Source Web Web Web Email Web Email Web Web Web Email Web Web Web Web Web Web Email Web D Amount E Product Book Book DVD Book DVD DVD Book DVD DVD Book DVD DVD Book DVD DVD Book DVD Book