Question: hello can I get some help with this? thank you! In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders

hello can I get some help with this? thank you!  hello can I get some help with this? thank you! In
the accompanying Sales Transactions data, use Excel's filtering capability to extract a.

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. 2 a. Complete the table to show the amounts of all orders that used Paypal. B E 1 Region Payment Source Amount Product East Paypal Web Book 3 West Paypal Email Book 4 West Paypal Email DVD 5 West Paypal Web DVD South Paypal Web DVD 7 South Paypal Email Book 8 North Paypal Web DVD 9 West Paypal Web DVD 10 East Paypal Web DVD 11 West Paypal Web Book 12 North Paypal Email DVD 6 9 Sale Transactions Region East West North West South West East West West South South East North East West 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.85 15.08 24.66 24.08 14.32 17.07 175.91 23.05 15.13 23.35 25.39 21.61 18.37 15127 20.05 22.86 18.37 21.22 17,63 17.55 Product Book Book DVD Book DVD DVD Book Book DVD DVD Book DVD DVD DVD Book DVD DVD Book DVD Book East West North West

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!