For your information, this question is from Management Information System (MIS) Subject

Lab Exercise : Pivot Table Online Management Training Inc. Transaction Log: October 28 Sum of Amount Column Labels Product / Source Paypal Credit 9772.23 Grand Total 15316.23 Book 5544 Email 3099.17 1674.49 4773.66 East 833.38 101.55 934.93 North 130.44 292.65 162.21 1117.21 South 118.28 1235.49 986.37 1324.22 2310.59 West Web 6673.06 3869.51 10542.57 2447.39 East 1661.18 786.21 631.17 1224.28 1855.45 1659.98 824.91 North South West Online Email 2484.89 3754.84 2720.73 1034.11 2920.71 1564.67 4485.38 349.8 1097.85 East 748.05 99.21 192.75 22.51 121.72 North 252.41 South 126.58 242.94 West 329.51 480.78 eWeb 2172.66 59.66 116.36 151.27 1214.87 162.65 201.49 321.16 3387.53 East 561.18 723.83 North 587.56 South 588.51 386.07 267.35 958.06 12692.94 West 529.57 1487.63 Grand Total 7108.67 19801.61 Please use Pivot Table Data Set File in UV. 1. Where do most of our book customers come from? The answer might tell managers where to spend more marketing resources, or to initiate new marketing efforts for increasing book sales. 2. What is the most effective source of advertisement to sell books in the South region? Is it also the most efficient? So what should OMT do? 3. Are there regional differences in the sources of advertisements for our book customers? Perhaps in certain regions email advertisement is more effective, while it is web banners in others. The answer to this complicated question could help managers develop an enhanced regional marketing strategy. 4. What is the total revenue generated from the sale of books that are priced between RM150 to RM200, paid using PayPal? (Hint: Use the Filter function instead)