Question: 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

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. a. Complete the table to show the amounts of all orders that used Paypal. D Amount 1 Region East West Source Web E Product DVD 2 N Email DVD 3 4 West Email Book 4 5 West Web Book ah 6 B Payment Paypal Paypal Paypal Paypal Paypal Paypal Paypal Paypal Paypal Paypal Paypal Web South South Book 7 Email DVD 8 North Web Book 9 9 Web West East 10 Book Book DVD West Web Web Email 11 North 12 Book Region East West North West South West East West West South South East North East West West East West North West Payment Paypal Credit Credit 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.99 16.11 24.54 24.45 14.84 17.86 183.58 25.92 15.02 23.28 25.71 22.16 18.47 152.48 21.98 22.74 19.53 20.13 17.18 17.15 Product DVD DVD Book DVD Book Book DVD DVD Book Book DVD Book Book Book DVD Book Book DVD Book DVD
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
