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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!