Reports and Data Analysis with ExceL 401
swearing123
Hands-OnExcelExercisesPivotandReports.xlsxEx1
| Group | Country | Revenue | Expense | Profit | |||||||||
| Asia | China | $ 8,249.33 | $ 594.88 | $ 7,654.45 | |||||||||
| Asia | China | $ 6,557.87 | $ 83.34 | $ 6,474.53 | |||||||||
| Africa | South Africa | $ 6,180.04 | $ 551.27 | $ 5,628.77 | 1) Total Revenue, Expense and Profit | ||||||||
| Asia | China | $ 9,915.45 | $ 336.86 | $ 9,578.59 | Country | Revenue | Expense | Profit | |||||
| Africa | Nigeria | $ 4,047.67 | $ 481.01 | $ 3,566.66 | India | ||||||||
| Africa | South Africa | $ 4,797.09 | $ 962.36 | $ 3,834.73 | Great Britain | ||||||||
| Africa | South Africa | $ 6,537.80 | $ 931.97 | $ 5,605.83 | South Africa | ||||||||
| Asia | India | $ 3,151.42 | $ 848.21 | $ 2,303.21 | |||||||||
| US and Europe | Germany | $ 9,504.78 | $ 827.56 | $ 8,677.22 | |||||||||
| Asia | India | $ 9,378.14 | $ 566.80 | $ 8,811.34 | 2) Highest Average Revenue | ||||||||
| US and Europe | Germany | $ 6,772.13 | $ 436.88 | $ 6,335.25 | Country | Revenue | Expenses | Profit | |||||
| Africa | South Africa | $ 1,854.63 | $ 930.55 | $ 924.08 | |||||||||
| US and Europe | Great Britain | $ 8,303.94 | $ 680.75 | $ 7,623.19 | |||||||||
| Africa | South Africa | $ 6,741.46 | $ 418.03 | $ 6,323.43 | |||||||||
| Africa | Nigeria | $ 4,151.44 | $ 336.41 | $ 3,815.03 | |||||||||
| Africa | South Africa | $ 7,972.30 | $ 917.14 | $ 7,055.16 | 3) Lowest Average Expense | ||||||||
| US and Europe | Germany | $ 10,331.58 | $ 440.47 | $ 9,891.11 | Country | Revenue | Expenses | Profit | |||||
| Africa | South Africa | $ 3,695.19 | $ 217.66 | $ 3,477.53 | |||||||||
| Africa | South Africa | $ 7,904.29 | $ 764.58 | $ 7,139.71 | |||||||||
| Asia | China | $ 849.26 | $ 94.52 | $ 754.74 | |||||||||
| US and Europe | Great Britain | $ 7,157.63 | $ 915.92 | $ 6,241.71 | |||||||||
| Asia | China | $ 3,712.57 | $ 432.55 | $ 3,280.02 | 4) Highest Average Profit | ||||||||
| Africa | Nigeria | $ 7,596.44 | $ 134.82 | $ 7,461.62 | Country | Revenue | Expense | Profit | |||||
| Africa | Nigeria | $ 2,198.66 | $ 1,037.29 | $ 1,161.37 | |||||||||
| US and Europe | Germany | $ 4,724.00 | $ 463.29 | $ 4,260.71 | |||||||||
| Asia | China | $ 1,331.26 | $ 959.23 | $ 372.03 | |||||||||
| Asia | India | $ 2,743.80 | $ 222.92 | $ 2,520.88 | |||||||||
| US and Europe | Great Britain | $ 5,038.31 | $ 306.96 | $ 4,731.35 | |||||||||
| Africa | Nigeria | $ 10,458.27 | $ 692.76 | $ 9,765.51 | |||||||||
| Africa | South Africa | $ 7,567.04 | $ 720.32 | $ 6,846.72 | |||||||||
| US and Europe | Great Britain | $ 7,688.43 | $ 851.85 | $ 6,836.58 | |||||||||
| Africa | South Africa | $ 4,023.23 | $ 166.49 | $ 3,856.74 | |||||||||
| Asia | India | $ 4,551.60 | $ 701.05 | $ 3,850.55 | |||||||||
| Asia | India | $ 2,665.11 | $ 654.98 | $ 2,010.13 | |||||||||
| Africa | Nigeria | $ 6,589.12 | $ 278.19 | $ 6,310.93 | |||||||||
| Asia | India | $ 5,220.43 | $ 589.17 | $ 4,631.26 | |||||||||
| Asia | India | $ 7,282.19 | $ 387.55 | $ 6,894.64 | |||||||||
| Africa | South Africa | $ 6,444.58 | $ 258.50 | $ 6,186.08 | |||||||||
| Africa | Nigeria | $ 10,299.03 | $ 287.80 | $ 10,011.23 | |||||||||
| Africa | South Africa | $ 9,841.23 | $ 824.48 | $ 9,016.75 | |||||||||
| Africa | Nigeria | $ 8,237.85 | $ 48.30 | $ 8,189.55 | |||||||||
| Asia | China | $ 6,221.25 | $ 414.88 | $ 5,806.37 | |||||||||
| Asia | China | $ 5,401.24 | $ 877.97 | $ 4,523.27 | |||||||||
| Africa | Nigeria | $ 10,013.81 | $ 807.85 | $ 9,205.96 | |||||||||
| US and Europe | Great Britain | $ 8,466.70 | $ 450.57 | $ 8,016.13 | |||||||||
| Africa | South Africa | $ 8,382.21 | $ 958.25 | $ 7,423.96 | |||||||||
| Africa | Nigeria | $ 8,105.42 | $ 647.65 | $ 7,457.77 | |||||||||
| Africa | Nigeria | $ 10,051.26 | $ 1,003.73 | $ 9,047.53 | |||||||||
| Africa | South Africa | $ 3,667.20 | $ 680.71 | $ 2,986.49 | |||||||||
| Africa | South Africa | $ 7,822.06 | $ 924.36 | $ 6,897.70 | |||||||||
| Africa | Nigeria | $ 4,575.53 | $ 657.65 | $ 3,917.88 | |||||||||
| Africa | South Africa | $ 3,178.20 | $ 756.21 | $ 2,421.99 | |||||||||
| Africa | South Africa | $ 1,734.41 | $ 864.15 | $ 870.26 | |||||||||
| Asia | China | $ 8,601.07 | $ 666.92 | $ 7,934.15 | |||||||||
| Asia | China | $ 8,328.45 | $ 898.71 | $ 7,429.74 | |||||||||
| Asia | India | $ 9,715.27 | $ 536.26 | $ 9,179.01 | |||||||||
| Asia | China | $ 4,722.77 | $ 837.71 | $ 3,885.06 | |||||||||
| Asia | India | $ 3,434.69 | $ 574.12 | $ 2,860.57 | |||||||||
| Africa | Nigeria | $ 8,696.76 | $ 581.44 | $ 8,115.32 | |||||||||
| Asia | India | $ 9,195.08 | $ 1,000.67 | $ 8,194.41 | |||||||||
| US and Europe | Germany | $ 4,168.87 | $ 650.90 | $ 3,517.97 | |||||||||
| US and Europe | Germany | $ 885.24 | $ 323.98 | $ 561.26 | |||||||||
| Asia | China | $ 3,222.21 | $ 760.28 | $ 2,461.93 | |||||||||
| Africa | South Africa | $ 3,185.18 | $ 455.46 | $ 2,729.72 | |||||||||
| Africa | South Africa | $ 5,050.98 | $ 618.33 | $ 4,432.65 | |||||||||
| Africa | Nigeria | $ 306.08 | $ 275.31 | $ 30.77 | |||||||||
| Africa | South Africa | $ 9,598.98 | $ 613.29 | $ 8,985.69 | |||||||||
| Africa | Nigeria | $ 10,338.80 | $ 979.85 | $ 9,358.95 | |||||||||
| Asia | China | $ 7,350.61 | $ 271.99 | $ 7,078.62 | |||||||||
| Africa | Nigeria | $ 7,506.47 | $ 408.01 | $ 7,098.46 | |||||||||
| Africa | Nigeria | $ 1,939.78 | $ 413.94 | $ 1,525.84 | |||||||||
| US and Europe | Great Britain | $ 7,692.22 | $ 1,015.87 | $ 6,676.35 | |||||||||
| US and Europe | Germany | $ 1,060.49 | $ 607.34 | $ 453.15 | |||||||||
| Asia | China | $ 738.51 | $ 431.47 | $ 307.04 | |||||||||
| Africa | Nigeria | $ 8,174.84 | $ 206.65 | $ 7,968.19 | |||||||||
| Africa | Nigeria | $ 4,368.81 | $ 203.38 | $ 4,165.43 | |||||||||
| Africa | South Africa | $ 1,292.52 | $ 123.11 | $ 1,169.41 | |||||||||
| US and Europe | Great Britain | $ 2,210.75 | $ 465.53 | $ 1,745.22 | |||||||||
| US and Europe | Germany | $ 4,240.74 | $ 737.07 | $ 3,503.67 | |||||||||
| Africa | Nigeria | $ 5,927.04 | $ 501.24 | $ 5,425.80 | |||||||||
| Africa | Nigeria | $ 2,597.35 | $ 489.99 | $ 2,107.36 | |||||||||
| Africa | Nigeria | $ 9,549.49 | $ 835.02 | $ 8,714.47 | |||||||||
| Africa | South Africa | $ 3,931.33 | $ 191.42 | $ 3,739.91 | |||||||||
| Africa | South Africa | $ 8,578.80 | $ 670.24 | $ 7,908.56 | |||||||||
| US and Europe | Great Britain | $ 1,946.14 | $ 273.51 | $ 1,672.63 | |||||||||
| Asia | India | $ 9,021.02 | $ 402.06 | $ 8,618.96 | |||||||||
| Asia | India | $ 5,575.67 | $ 148.33 | $ 5,427.34 | |||||||||
| US and Europe | Great Britain | $ 1,193.07 | $ 148.13 | $ 1,044.94 | |||||||||
| Africa | Nigeria | $ 10,340.53 | $ 250.08 | $ 10,090.45 | |||||||||
| Africa | Nigeria | $ 5,512.77 | $ 542.62 | $ 4,970.15 | |||||||||
| Asia | India | $ 2,556.00 | $ 824.13 | $ 1,731.87 | |||||||||
| Africa | South Africa | $ 10,157.81 | $ 508.17 | $ 9,649.64 | |||||||||
| Asia | China | $ 8,921.52 | $ 259.33 | $ 8,662.19 | |||||||||
| US and Europe | Great Britain | $ 10,494.44 | $ 565.43 | $ 9,929.01 | |||||||||
| Asia | China | $ 7,007.77 | $ 765.69 | $ 6,242.08 | |||||||||
| Asia | India | $ 4,811.04 | $ 193.17 | $ 4,617.87 | |||||||||
| Africa | South Africa | $ 8,657.83 | $ 171.60 | $ 8,486.23 | |||||||||
| Asia | China | $ 8,204.32 | $ 278.75 | $ 7,925.57 | |||||||||
| Africa | South Africa | $ 4,246.88 | $ 644.52 | $ 3,602.36 | |||||||||
| Averages | |||||||||||||
| Country | Revenue | Expense | Profit | ||||||||||
| China | |||||||||||||
| South Africa | |||||||||||||
| Nigeria | |||||||||||||
| India | |||||||||||||
| Germany | |||||||||||||
| Great Britain | |||||||||||||
Exercise: Revenue Expense & Profit Analysses 1. Using the appropriate function(s) calculate Total Revenue, Expense, and Profit for India, Great Britain, and South Africa from data in columns E - I. 2. Using the appropriate function(s), list the 3 Countries with the HIGHEST average Revenue along with their Expense, and Profit figures. 3. Using the appropriate function(s), list the 3 Countries with the LOWEST average Expense along their Revenue and Profit figures. 4. Using the appropriate function(s), list the 3 Countries with the HIGHEST average Profits along their Revenue and Expense figures. Hint: For Questions 2, 3, 4 there is a need to first create an unduplicated list of countries to calculate the averages first! See rows 102 - 109, Column G - I below. 5. Briefly discuss the results obtained for each of the above activity in the Ex1 Discussions Tab. *Keep answers for Ex 1-4 in this tab. Hint Total Points: 50
Ex1 Discussions
Example 1 Discussions 1. The 3 Cities with the HIGHEST average Revenue along with their Expense, and Profit figures 2. The 3 Cities with the LOWEST average Expense along their Revenue and Profit figures. 3. The 3 Cities with the LOWEST average Expense along their Revenue and Profit figures. 4. The 3 Cities with the HIGHEST average Profits along their Revenue and Expense figures.
Ex2
| Year | Region | Country | Quarter | Revenue | Expenses | |||
| 2019 | Africa | Egypt | 1 | $ 5,695.19 | $ 4,175.56 | |||
| 2019 | Africa | Egypt | 2 | $ 7,904.29 | $ 5,058.75 | |||
| 2019 | Africa | Egypt | 3 | $ 7,596.44 | $ 8,508.01 | |||
| 2019 | Africa | Egypt | 4 | $ 2,198.66 | $ 2,550.45 | |||
| 2019 | Africa | Kenya | 1 | $ 9,841.23 | $ 6,692.04 | |||
| 2019 | Africa | Kenya | 2 | $ 8,237.85 | $ 5,601.74 | |||
| 2019 | Africa | Kenya | 3 | $ 4,047.67 | $ 2,752.42 | |||
| 2019 | Africa | Kenya | 4 | $ 4,797.09 | $ 3,262.02 | |||
| 2019 | Africa | Moroco | 1 | $ 4,575.53 | $ 5,124.59 | |||
| 2019 | Africa | Moroco | 2 | $ 7,822.06 | $ 8,838.93 | |||
| 2019 | Africa | Moroco | 3 | $ 3,151.42 | $ 2,016.91 | |||
| 2019 | Africa | Moroco | 4 | $ 3,178.20 | $ 3,559.58 | |||
| 2019 | Africa | Nigeria | 1 | $ 10,013.81 | $ 11,616.02 | |||
| 2019 | Africa | Nigeria | 2 | $ 6,537.80 | $ 4,445.70 | |||
| 2019 | Africa | Nigeria | 3 | $ 1,854.63 | $ 1,261.15 | |||
| 2019 | Africa | Nigeria | 4 | $ 8,382.21 | $ 5,699.90 | |||
| 2019 | Africa | Rwanda | 1 | $ 6,589.12 | $ 4,480.60 | |||
| 2019 | Africa | Rwanda | 2 | $ 6,444.58 | $ 7,217.93 | |||
| 2019 | Africa | Rwanda | 3 | $ 8,105.42 | $ 9,321.23 | |||
| 2019 | Africa | Rwanda | 4 | $ 7,972.30 | $ 4,065.87 | |||
| 2019 | Africa | Senegal | 1 | $ 10,299.03 | $ 5,355.50 | |||
| 2019 | Africa | Senegal | 2 | $ 6,180.04 | $ 3,275.42 | |||
| 2019 | Africa | Senegal | 3 | $ 10,458.27 | $ 6,065.80 | |||
| 2019 | Africa | Senegal | 4 | $ 10,051.26 | $ 5,829.73 | |||
| 2019 | Africa | South Africa | 1 | $ 6,741.46 | $ 4,651.61 | |||
| 2019 | Africa | South Africa | 2 | $ 4,151.44 | $ 2,532.38 | |||
| 2019 | Africa | South Africa | 3 | $ 3,667.20 | $ 2,273.66 | |||
| 2019 | Africa | South Africa | 4 | $ 8,249.33 | $ 5,279.57 | |||
| 2019 | Americas | Argentina | 1 | $ 5,575.67 | $ 3,735.70 | |||
| 2019 | Americas | Argentina | 2 | $ 2,556.00 | $ 1,763.64 | |||
| 2019 | Americas | Argentina | 3 | $ 1,789.20 | $ 1,288.22 | |||
| 2019 | Americas | Argentina | 4 | $ 4,460.54 | $ 3,256.19 | |||
| 2019 | Americas | Brazil | 1 | $ 4,551.60 | $ 3,413.70 | |||
| 2019 | Americas | Brazil | 2 | $ 2,665.11 | $ 1,918.88 | |||
| 2019 | Americas | Brazil | 3 | $ 7,282.19 | $ 5,534.46 | |||
| 2019 | Americas | Brazil | 4 | $ 5,220.43 | $ 4,489.57 | |||
| 2019 | Americas | Canada | 1 | $ 5,738.51 | $ 4,494.80 | |||
| 2019 | Americas | Canada | 2 | $ 2,743.80 | $ 2,112.73 | |||
| 2019 | Americas | Canada | 3 | $ 8,601.07 | $ 6,364.79 | |||
| 2019 | Americas | Canada | 4 | $ 4,722.77 | $ 3,683.76 | |||
| 2019 | Americas | Chile | 1 | $ 7,007.77 | $ 4,765.28 | |||
| 2019 | Americas | Chile | 2 | $ 8,921.52 | $ 7,048.00 | |||
| 2019 | Americas | Chile | 3 | $ 7,567.04 | $ 6,129.30 | |||
| 2019 | Americas | Chile | 4 | $ 9,021.02 | $ 7,577.66 | |||
| 2019 | Americas | Ecuador | 1 | $ 1,331.26 | $ 1,131.57 | |||
| 2019 | Americas | Ecuador | 2 | $ 9,715.27 | $ 8,257.98 | |||
| 2019 | Americas | Ecuador | 3 | $ 5,401.24 | $ 4,645.07 | |||
| 2019 | Americas | Ecuador | 4 | $ 8,303.94 | $ 7,141.39 | |||
| 2019 | Americas | Mexico | 1 | $ 4,023.23 | $ 3,459.98 | |||
| 2019 | Americas | Mexico | 2 | $ 3,222.21 | $ 2,803.32 | |||
| 2019 | Americas | Mexico | 3 | $ 3,434.69 | $ 3,022.53 | |||
| 2019 | Americas | Mexico | 4 | $ 9,195.08 | $ 8,275.57 | |||
| 2019 | Americas | USA | 1 | $ 8,204.32 | $ 7,794.10 | |||
| 2019 | Americas | USA | 2 | $ 16,504.78 | $ 16,009.64 | |||
| 2019 | Americas | USA | 3 | $ 33,712.57 | $ 38,095.20 | |||
| 2019 | Americas | USA | 4 | $ 48,328.45 | $ 30,930.21 | |||
| 2019 | Asia | China | 1 | $ 12,734.41 | $ 14,262.54 | |||
| 2019 | Asia | China | 2 | $ 15,927.04 | $ 18,475.37 | |||
| 2019 | Asia | China | 3 | $ 23,185.18 | $ 15,765.92 | |||
| 2019 | Asia | China | 4 | $ 28,174.84 | $ 19,158.89 | |||
| 2019 | Asia | India | 1 | $ 4,368.81 | $ 2,970.79 | |||
| 2019 | Asia | India | 2 | $ 9,549.49 | $ 6,493.65 | |||
| 2019 | Asia | India | 3 | $ 8,578.80 | $ 9,608.26 | |||
| 2019 | Asia | India | 4 | $ 5,050.98 | $ 5,808.63 | |||
| 2019 | Asia | Japan | 1 | $ 9,598.98 | $ 6,527.31 | |||
| 2019 | Asia | Japan | 2 | $ 10,338.80 | $ 7,030.38 | |||
| 2019 | Asia | Japan | 3 | $ 7,506.47 | $ 5,104.40 | |||
| 2019 | Asia | Japan | 4 | $ 7,306.08 | $ 5,342.81 | |||
| 2019 | Asia | Pakistan | 1 | $ 2,597.35 | $ 2,935.01 | |||
| 2019 | Asia | Pakistan | 2 | $ 3,931.33 | $ 2,516.05 | |||
| 2019 | Asia | Pakistan | 3 | $ 16,772.13 | $ 18,784.79 | |||
| 2019 | Asia | Pakistan | 4 | $ 15,255.01 | $ 17,695.81 | |||
| 2019 | Asia | South Korea | 1 | $ 6,557.87 | $ 4,459.35 | |||
| 2019 | Asia | South Korea | 2 | $ 8,657.83 | $ 5,887.32 | |||
| 2019 | Asia | South Korea | 3 | $ 4,246.88 | $ 2,887.88 | |||
| 2019 | Asia | South Korea | 4 | $ 5,235.00 | $ 3,559.80 | |||
| 2019 | Asia | Taiwan | 1 | $ 10,157.81 | $ 11,376.75 | |||
| 2019 | Asia | Taiwan | 2 | $ 5,512.77 | $ 6,339.69 | |||
| 2019 | Asia | Taiwan | 3 | $ 7,350.61 | $ 4,557.38 | |||
| 2019 | Asia | Taiwan | 4 | $ 4,811.04 | $ 5,436.48 | |||
| 2019 | Asia | Vietnam | 1 | $ 4,696.76 | $ 3,005.93 | |||
| 2019 | Asia | Vietnam | 2 | $ 7,939.78 | $ 8,892.55 | |||
| 2019 | Asia | Vietnam | 3 | $ 5,292.52 | $ 6,139.32 | |||
| 2019 | Asia | Vietnam | 4 | $ 10,494.44 | $ 7,136.22 | |||
| 2019 | Europe | Belgium | 1 | $ 7,644.58 | $ 5,198.31 | |||
| 2019 | Europe | Belgium | 2 | $ 9,378.14 | $ 6,377.14 | |||
| 2019 | Europe | Belgium | 3 | $ 6,258.14 | $ 4,255.54 | |||
| 2019 | Europe | Belgium | 4 | $ 4,649.01 | $ 5,206.89 | |||
| 2019 | Europe | Denmark | 1 | $ 8,466.70 | $ 9,736.71 | |||
| 2019 | Europe | Denmark | 2 | $ 7,692.22 | $ 3,538.42 | |||
| 2019 | Europe | Denmark | 3 | $ 9,615.28 | $ 5,192.25 | |||
| 2019 | Europe | Denmark | 4 | $ 7,915.45 | $ 4,353.50 | |||
| 2019 | Europe | England | 1 | $ 4,240.74 | $ 5,088.89 | |||
| 2019 | Europe | England | 2 | $ 1,946.14 | $ 1,109.30 | |||
| 2019 | Europe | England | 3 | $ 1,193.07 | $ 739.70 | |||
| 2019 | Europe | England | 4 | $ 4,885.24 | $ 5,000.32 | |||
| 2019 | Europe | France | 1 | $ 7,329.03 | $ 4,690.58 | |||
| 2019 | Europe | France | 2 | $ 10,331.58 | $ 11,571.37 | |||
| 2019 | Europe | France | 3 | $ 7,697.50 | $ 8,929.10 | |||
| 2019 | Europe | France | 4 | $ 12,210.75 | $ 8,303.31 | |||
| 2019 | Europe | Germany | 1 | $ 4,724.00 | $ 5,101.92 | |||
| 2019 | Europe | Germany | 2 | $ 5,038.31 | $ 3,778.73 | |||
| 2019 | Europe | Germany | 3 | $ 7,688.43 | $ 8,687.93 | |||
| 2019 | Europe | Germany | 4 | $ 7,157.63 | $ 5,439.80 | |||
| 2019 | Europe | Italy | 1 | $ 4,168.87 | $ 4,502.38 | |||
| 2019 | Europe | Italy | 2 | $ 6,629.11 | $ 5,170.71 | |||
| 2019 | Europe | Italy | 3 | $ 1,060.49 | $ 1,368.03 | |||
| 2019 | Europe | Italy | 4 | $ 3,285.94 | $ 2,694.47 | |||
| 2019 | Europe | Netherland | 1 | $ 7,365.38 | $ 5,229.42 | |||
| 2019 | Europe | Netherland | 2 | $ 6,683.62 | $ 5,614.24 | |||
| 2019 | Europe | Netherland | 3 | $ 8,822.83 | $ 10,940.31 | |||
| 2019 | Europe | Netherland | 4 | $ 12,057.90 | $ 14,107.74 | |||
| 2019 | Europe | Spain | 1 | $ 7,777.35 | $ 6,766.30 | |||
| 2019 | Europe | Spain | 2 | $ 2,302.44 | $ 2,072.19 | |||
| 2019 | Europe | Spain | 3 | $ 4,849.26 | $ 6,788.96 | |||
| 2019 | Europe | Spain | 4 | $ 6,221.25 | $ 4,417.09 | |||
| 2020 | Americas | Argentina | 1 | $ 3,735.70 | $ 2,502.92 | |||
| 2020 | Americas | Argentina | 2 | $ 1,763.64 | $ 1,216.91 | |||
| 2020 | Americas | Argentina | 3 | $ 5,288.22 | $ 4,927.52 | |||
| 2020 | Americas | Argentina | 4 | $ 3,256.19 | $ 2,377.02 | |||
| 2020 | Europe | Belgium | 1 | $ 5,198.31 | $ 3,534.85 | |||
| 2020 | Europe | Belgium | 2 | $ 6,377.14 | $ 4,336.45 | |||
| 2020 | Europe | Belgium | 3 | $ 4,255.54 | $ 2,893.76 | |||
| 2020 | Europe | Belgium | 4 | $ 5,206.89 | $ 5,831.72 | |||
| 2020 | Americas | Brazil | 1 | $ 3,413.70 | $ 2,560.28 | |||
| 2020 | Americas | Brazil | 2 | $ 1,918.88 | $ 1,381.59 | |||
| 2020 | Americas | Brazil | 3 | $ 5,534.46 | $ 4,206.19 | |||
| 2020 | Americas | Brazil | 4 | $ 4,489.57 | $ 3,861.03 | |||
| 2020 | Americas | Canada | 1 | $ 3,494.80 | $ 2,331.52 | |||
| 2020 | Americas | Canada | 2 | $ 2,112.73 | $ 1,626.80 | |||
| 2020 | Americas | Canada | 3 | $ 6,364.79 | $ 4,709.95 | |||
| 2020 | Americas | Canada | 4 | $ 3,683.76 | $ 2,873.33 | |||
| 2020 | Americas | Chile | 1 | $ 4,765.28 | $ 3,240.39 | |||
| 2020 | Americas | Chile | 2 | $ 7,048.00 | $ 5,567.92 | |||
| 2020 | Americas | Chile | 3 | $ 6,129.30 | $ 4,964.73 | |||
| 2020 | Americas | Chile | 4 | $ 7,577.66 | $ 6,365.23 | |||
| 2020 | Asia | China | 1 | $ 14,262.54 | $ 15,974.04 | |||
| 2020 | Asia | China | 2 | $ 18,475.37 | $ 21,431.43 | |||
| 2020 | Asia | China | 3 | $ 15,765.92 | $ 10,720.83 | |||
| 2020 | Asia | China | 4 | $ 19,158.89 | $ 13,028.05 | |||
| 2020 | Europe | Denmark | 1 | $ 9,736.71 | $ 11,197.21 | |||
| 2020 | Europe | Denmark | 2 | $ 3,538.42 | $ 1,627.67 | |||
| 2020 | Europe | Denmark | 3 | $ 5,192.25 | $ 2,803.82 | |||
| 2020 | Europe | Denmark | 4 | $ 4,353.50 | $ 2,394.42 | |||
| 2020 | Americas | Ecuador | 1 | $ 4,131.57 | $ 3,961.84 | |||
| 2020 | Americas | Ecuador | 2 | $ 8,257.98 | $ 7,019.28 | |||
| 2020 | Americas | Ecuador | 3 | $ 4,645.07 | $ 3,994.76 | |||
| 2020 | Americas | Ecuador | 4 | $ 7,141.39 | $ 6,141.59 | |||
| 2020 | Africa | Egypt | 1 | $ 6,435.56 | $ 4,718.39 | |||
| 2020 | Africa | Egypt | 2 | $ 5,058.75 | $ 3,237.60 | |||
| 2020 | Africa | Egypt | 3 | $ 8,508.01 | $ 9,528.97 | |||
| 2020 | Africa | Egypt | 4 | $ 2,550.45 | $ 2,958.52 | |||
| 2020 | Europe | England | 1 | $ 5,088.89 | $ 6,106.67 | |||
| 2020 | Europe | England | 2 | $ 6,109.30 | $ 6,632.30 | |||
| 2020 | Europe | England | 3 | $ 7,739.70 | $ 8,458.62 | |||
| 2020 | Europe | England | 4 | $ 1,000.32 | $ 1,130.36 | |||
| 2020 | Europe | France | 1 | $ 4,690.58 | $ 3,001.97 | |||
| 2020 | Europe | France | 2 | $ 11,571.37 | $ 12,959.93 | |||
| 2020 | Europe | France | 3 | $ 8,929.10 | $ 10,357.76 | |||
| 2020 | Europe | France | 4 | $ 8,303.31 | $ 5,646.25 | |||
| 2020 | Europe | Germany | 1 | $ 5,101.92 | $ 5,510.07 | |||
| 2020 | Europe | Germany | 2 | $ 3,778.73 | $ 2,834.05 | |||
| 2020 | Europe | Germany | 3 | $ 8,687.93 | $ 9,817.36 | |||
| 2020 | Europe | Germany | 4 | $ 5,439.80 | $ 4,134.25 | |||
| 2020 | Asia | India | 1 | $ 2,970.79 | $ 2,020.14 | |||
| 2020 | Asia | India | 2 | $ 6,493.65 | $ 4,415.68 | |||
| 2020 | Asia | India | 3 | $ 9,608.26 | $ 10,761.25 | |||
| 2020 | Asia | India | 4 | $ 5,808.63 | $ 6,679.92 | |||
| 2020 | Europe | Italy | 1 | $ 4,502.38 | $ 4,862.57 | |||
| 2020 | Europe | Italy | 2 | $ 5,170.71 | $ 4,033.15 | |||
| 2020 | Europe | Italy | 3 | $ 1,368.03 | $ 1,764.76 | |||
| 2020 | Europe | Italy | 4 | $ 2,694.47 | $ 2,209.47 | |||
| 2020 | Asia | Japan | 1 | $ 6,527.31 | $ 4,438.57 | |||
| 2020 | Asia | Japan | 2 | $ 7,030.38 | $ 4,780.66 | |||
| 2020 | Asia | Japan | 3 | $ 5,104.40 | $ 3,470.99 | |||
| 2020 | Asia | Japan | 4 | $ 9,342.81 | $ 8,383.95 | |||
| 2020 | Africa | Kenya | 1 | $ 6,692.04 | $ 4,550.58 | |||
| 2020 | Africa | Kenya | 2 | $ 5,601.74 | $ 3,809.18 | |||
| 2020 | Africa | Kenya | 3 | $ 2,752.42 | $ 1,871.64 | |||
| 2020 | Africa | Kenya | 4 | $ 3,262.02 | $ 2,218.17 | |||
| 2020 | Americas | Mexico | 1 | $ 3,459.98 | $ 2,975.58 | |||
| 2020 | Americas | Mexico | 2 | $ 2,803.32 | $ 2,438.89 | |||
| 2020 | Americas | Mexico | 3 | $ 3,022.53 | $ 2,659.82 | |||
| 2020 | Americas | Mexico | 4 | $ 8,275.57 | $ 7,448.01 | |||
| 2020 | Africa | Moroco | 1 | $ 5,124.59 | $ 5,739.54 | |||
| 2020 | Africa | Moroco | 2 | $ 8,838.93 | $ 9,987.99 | |||
| 2020 | Africa | Moroco | 3 | $ 2,016.91 | $ 1,290.82 | |||
| 2020 | Africa | Moroco | 4 | $ 3,559.58 | $ 3,986.73 | |||
| 2020 | Europe | Netherland | 1 | $ 5,229.42 | $ 3,712.89 | |||
| 2020 | Europe | Netherland | 2 | $ 5,614.24 | $ 4,715.96 | |||
| 2020 | Europe | Netherland | 3 | $ 10,940.31 | $ 13,565.99 | |||
| 2020 | Europe | Netherland | 4 | $ 14,107.74 | $ 16,506.06 | |||
| 2020 | Africa | Nigeria | 1 | $ 11,616.02 | $ 13,474.58 | |||
| 2020 | Africa | Nigeria | 2 | $ 4,445.70 | $ 3,023.08 | |||
| 2020 | Africa | Nigeria | 3 | $ 1,261.15 | $ 857.58 | |||
| 2020 | Africa | Nigeria | 4 | $ 5,699.90 | $ 3,875.93 | |||
| 2020 | Asia | Pakistan | 1 | $ 2,935.01 | $ 3,316.56 | |||
| 2020 | Asia | Pakistan | 2 | $ 2,516.05 | $ 1,610.27 | |||
| 2020 | Asia | Pakistan | 3 | $ 18,784.79 | $ 21,038.96 | |||
| 2020 | Asia | Pakistan | 4 | $ 17,695.81 | $ 20,527.14 | |||
| 2020 | Africa | Rwanda | 1 | $ 4,480.60 | $ 3,046.81 | |||
| 2020 | Africa | Rwanda | 2 | $ 7,217.93 | $ 8,084.08 | |||
| 2020 | Africa | Rwanda | 3 | $ 9,321.23 | $ 10,719.42 | |||
| 2020 | Africa | Rwanda | 4 | $ 4,065.87 | $ 2,073.60 | |||
| 2020 | Africa | Senegal | 1 | $ 5,355.50 | $ 2,784.86 | |||
| 2020 | Africa | Senegal | 2 | $ 3,275.42 | $ 1,735.97 | |||
| 2020 | Africa | Senegal | 3 | $ 6,065.80 | $ 3,518.16 | |||
| 2020 | Africa | Senegal | 4 | $ 5,829.73 | $ 3,381.24 | |||
| 2020 | Africa | South Africa | 1 | $ 4,651.61 | $ 3,209.61 | |||
| 2020 | Africa | South Africa | 2 | $ 2,532.38 | $ 1,544.75 | |||
| 2020 | Africa | South Africa | 3 | $ 2,273.66 | $ 1,409.67 | |||
| 2020 | Africa | South Africa | 4 | $ 5,279.57 | $ 3,378.93 | |||
| 2020 | Asia | South Korea | 1 | $ 4,459.35 | $ 3,032.36 | |||
| 2020 | Asia | South Korea | 2 | $ 5,887.32 | $ 4,003.38 | |||
| 2020 | Asia | South Korea | 3 | $ 2,887.88 | $ 1,963.76 | |||
| 2020 | Asia | South Korea | 4 | $ 3,559.80 | $ 2,420.66 | |||
| 2020 | Europe | Spain | 1 | $ 6,766.30 | $ 5,886.68 | |||
| 2020 | Europe | Spain | 2 | $ 2,072.19 | $ 1,864.97 | |||
| 2020 | Europe | Spain | 3 | $ 6,788.96 | $ 9,504.55 | |||
| 2020 | Europe | Spain | 4 | $ 4,417.09 | $ 3,136.13 | |||
| 2020 | Asia | Taiwan | 1 | $ 11,376.75 | $ 12,741.96 | |||
| 2020 | Asia | Taiwan | 2 | $ 6,339.69 | $ 7,290.64 | |||
| 2020 | Asia | Taiwan | 3 | $ 4,557.38 | $ 2,825.57 | |||
| 2020 | Asia | Taiwan | 4 | $ 5,436.48 | $ 6,143.22 | |||
| 2020 | Americas | USA | 1 | $ 7,794.10 | $ 7,404.40 | |||
| 2020 | Americas | USA | 2 | $ 16,009.64 | $ 15,529.35 | |||
| 2020 | Americas | USA | 3 | $ 38,095.20 | $ 43,047.58 | |||
| 2020 | Americas | USA | 4 | $ 30,930.21 | $ 19,795.33 | |||
| 2020 | Asia | Vietnam | 1 | $ 3,005.93 | $ 1,923.79 | |||
| 2020 | Asia | Vietnam | 2 | $ 8,892.55 | $ 9,959.66 | |||
| 2020 | Asia | Vietnam | 3 | $ 6,139.32 | $ 7,121.61 | |||
| 2020 | Asia | Vietnam | 4 | $ 7,136.22 | $ 4,852.63 | |||
| 2021 | Americas | Canada | 1 | $ 1,331.52 | $ 1,222.12 | |||
| 2021 | Asia | Japan | 4 | $ 4,383.95 | $ 3,430.02 | |||
| 2021 | Europe | England | 3 | $ 6,458.62 | $ 5,284.34 | |||
| 2021 | Europe | England | 2 | $ 7,632.30 | $ 8,360.41 | |||
| 2021 | Africa | Nigeria | 3 | $ 5,857.58 | $ 4,583.16 | |||
| 2021 | Americas | Argentina | 3 | $ 927.52 | $ 667.82 | |||
| 2021 | Americas | Ecuador | 1 | $ 1,961.84 | $ 1,817.56 | |||
| 2021 | Europe | England | 4 | $ 1,130.36 | $ 1,277.31 | |||
| 2021 | Americas | Argentina | 2 | $ 1,216.91 | $ 839.67 | |||
| 2021 | Africa | Moroco | 3 | $ 1,290.82 | $ 826.13 | |||
| 2021 | Americas | Brazil | 2 | $ 1,381.59 | $ 994.75 | |||
| 2021 | Africa | South Africa | 3 | $ 1,409.67 | $ 874.00 | |||
| 2021 | Africa | South Africa | 2 | $ 1,544.75 | $ 942.30 | |||
| 2021 | Asia | Pakistan | 2 | $ 1,610.27 | $ 1,030.57 | |||
| 2021 | Americas | Canada | 2 | $ 1,626.80 | $ 1,252.64 | |||
| 2021 | Europe | Denmark | 2 | $ 1,627.67 | $ 748.73 | |||
| 2021 | Africa | Senegal | 2 | $ 1,735.97 | $ 920.07 | |||
| 2021 | Europe | Italy | 3 | $ 1,764.76 | $ 2,276.54 | |||
| 2021 | Europe | Spain | 2 | $ 1,864.97 | $ 1,678.48 | |||
| 2021 | Africa | Kenya | 3 | $ 1,871.64 | $ 1,272.72 | |||
| 2021 | Asia | Vietnam | 1 | $ 1,923.79 | $ 1,231.23 | |||
| 2021 | Asia | South Korea | 3 | $ 1,963.76 | $ 1,335.35 | |||
| 2021 | Asia | India | 1 | $ 2,020.14 | $ 1,373.69 | |||
| 2021 | Africa | Rwanda | 4 | $ 2,073.60 | $ 1,057.53 | |||
| 2021 | Europe | Italy | 4 | $ 2,209.47 | $ 1,811.76 | |||
| 2021 | Africa | Kenya | 4 | $ 2,218.17 | $ 1,508.36 | |||
| 2021 | Americas | Argentina | 4 | $ 2,377.02 | $ 1,735.22 | |||
| 2021 | Europe | Denmark | 4 | $ 2,394.42 | $ 1,316.93 | |||
| 2021 | Asia | South Korea | 4 | $ 2,420.66 | $ 1,646.05 | |||
| 2021 | Americas | Mexico | 2 | $ 2,438.89 | $ 2,121.83 | |||
| 2021 | Americas | Argentina | 1 | $ 2,502.92 | $ 1,676.96 | |||
| 2021 | Americas | Brazil | 1 | $ 2,560.28 | $ 1,920.21 | |||
| 2021 | Americas | Mexico | 3 | $ 2,659.82 | $ 2,340.65 | |||
| 2021 | Africa | Senegal | 1 | $ 2,784.86 | $ 1,448.13 | |||
| 2021 | Europe | Denmark | 3 | $ 2,803.82 | $ 1,514.06 | |||
| 2021 | Asia | Taiwan | 3 | $ 2,825.57 | $ 1,751.86 | |||
| 2021 | Europe | Germany | 2 | $ 2,834.05 | $ 2,125.54 | |||
| 2021 | Americas | Canada | 4 | $ 2,873.33 | $ 2,241.20 | |||
| 2021 | Europe | Belgium | 3 | $ 2,893.76 | $ 1,967.76 | |||
| 2021 | Africa | Egypt | 4 | $ 2,958.52 | $ 3,431.88 | |||
| 2021 | Americas | Mexico | 1 | $ 2,975.58 | $ 2,559.00 | |||
| 2021 | Europe | France | 1 | $ 3,001.97 | $ 1,921.26 | |||
| 2021 | Africa | Nigeria | 2 | $ 3,023.08 | $ 2,055.69 | |||
| 2021 | Asia | South Korea | 1 | $ 3,032.36 | $ 2,062.00 | |||
| 2021 | Africa | Rwanda | 1 | $ 3,046.81 | $ 2,071.83 | |||
| 2021 | Europe | Spain | 4 | $ 3,136.13 | $ 2,226.65 | |||
| 2021 | Africa | South Africa | 1 | $ 3,209.61 | $ 2,214.63 | |||
| 2021 | Africa | Egypt | 2 | $ 3,237.60 | $ 2,072.06 | |||
| 2021 | Americas | Chile | 1 | $ 3,240.39 | $ 2,203.47 | |||
| 2021 | Asia | Pakistan | 1 | $ 3,316.56 | $ 3,747.71 | |||
| 2021 | Africa | South Africa | 4 | $ 3,378.93 | $ 2,162.51 | |||
| 2021 | Africa | Senegal | 4 | $ 3,381.24 | $ 1,961.12 | |||
| 2021 | Asia | Japan | 3 | $ 3,470.99 | $ 2,360.27 | |||
| 2021 | Africa | Senegal | 3 | $ 3,518.16 | $ 2,040.53 | |||
| 2021 | Europe | Belgium | 1 | $ 3,534.85 | $ 2,403.70 | |||
| 2021 | Europe | Netherland | 1 | $ 3,712.89 | $ 2,636.15 | |||
| 2021 | Africa | Kenya | 2 | $ 3,809.18 | $ 2,590.24 | |||
| 2021 | Americas | Brazil | 4 | $ 3,861.03 | $ 3,320.49 | |||
| 2021 | Africa | Nigeria | 4 | $ 3,875.93 | $ 2,635.64 | |||
| 2021 | Africa | Moroco | 4 | $ 3,986.73 | $ 4,465.14 | |||
| 2021 | Americas | Ecuador | 3 | $ 3,994.76 | $ 3,435.49 | |||
| 2021 | Asia | South Korea | 2 | $ 4,003.38 | $ 2,722.30 | |||
| 2021 | Europe | Italy | 2 | $ 4,033.15 | $ 3,145.86 | |||
| 2021 | Europe | Germany | 4 | $ 4,134.25 | $ 3,142.03 | |||
| 2021 | Americas | Brazil | 3 | $ 4,206.19 | $ 3,196.71 | |||
| 2021 | Europe | Belgium | 2 | $ 4,336.45 | $ 2,948.79 | |||
| 2021 | Asia | India | 2 | $ 4,415.68 | $ 3,002.67 | |||
| 2021 | Asia | Japan | 1 | $ 4,438.57 | $ 3,018.23 | |||
| 2021 | Africa | Kenya | 1 | $ 4,550.58 | $ 3,094.40 | |||
| 2021 | Americas | Canada | 3 | $ 4,709.95 | $ 3,485.36 | |||
| 2021 | Europe | Netherland | 2 | $ 4,715.96 | $ 3,961.41 | |||
| 2021 | Africa | Egypt | 1 | $ 7,272.19 | $ 5,331.78 | |||
| 2021 | Asia | Japan | 2 | $ 4,780.66 | $ 3,250.85 | |||
| 2021 | Asia | Vietnam | 4 | $ 4,852.63 | $ 3,299.79 | |||
| 2021 | Europe | Italy | 1 | $ 4,862.57 | $ 5,251.58 | |||
| 2021 | Americas | Chile | 3 | $ 4,964.73 | $ 4,021.44 | |||
| 2021 | Europe | Germany | 1 | $ 5,510.07 | $ 5,950.88 | |||
| 2021 | Americas | Chile | 2 | $ 5,567.92 | $ 4,398.66 | |||
| 2021 | Europe | France | 4 | $ 5,646.25 | $ 3,839.45 | |||
| 2021 | Africa | Moroco | 1 | $ 5,739.54 | $ 6,428.29 | |||
| 2021 | Europe | Belgium | 4 | $ 5,831.72 | $ 6,531.53 | |||
| 2021 | Europe | Spain | 1 | $ 5,886.68 | $ 5,121.41 | |||
| 2021 | Europe | England | 1 | $ 6,106.67 | $ 7,328.00 | |||
| 2021 | Americas | Ecuador | 4 | $ 6,141.59 | $ 5,281.77 | |||
| 2021 | Asia | Taiwan | 4 | $ 6,143.22 | $ 6,941.84 | |||
| 2021 | Americas | Chile | 4 | $ 6,365.23 | $ 5,346.79 | |||
| 2021 | Asia | India | 4 | $ 6,679.92 | $ 7,681.91 | |||
| 2021 | Americas | Ecuador | 2 | $ 7,019.28 | $ 5,966.39 | |||
| 2021 | Asia | Vietnam | 3 | $ 7,121.61 | $ 8,261.07 | |||
| 2021 | Asia | Taiwan | 2 | $ 7,290.64 | $ 8,384.23 | |||
| 2021 | Americas | USA | 1 | $ 7,404.40 | $ 7,034.18 | |||
| 2021 | Americas | Mexico | 4 | $ 7,448.01 | $ 6,703.21 | |||
| 2021 | Africa | Rwanda | 2 | $ 8,084.08 | $ 9,054.17 | |||
| 2021 | Europe | Spain | 3 | $ 9,504.55 | $ 13,306.37 | |||
| 2021 | Africa | Egypt | 3 | $ 9,528.97 | $ 10,672.45 | |||
| 2021 | Europe | Germany | 3 | $ 9,817.36 | $ 11,093.61 | |||
| 2021 | Asia | Vietnam | 2 | $ 9,959.66 | $ 11,154.82 | |||
| 2021 | Africa | Moroco | 2 | $ 9,987.99 | $ 11,286.43 | |||
| 2021 | Europe | France | 3 | $ 10,357.76 | $ 12,015.00 | |||
| 2021 | Africa | Rwanda | 3 | $ 10,719.42 | $ 12,327.33 | |||
| 2021 | Asia | China | 3 | $ 10,720.83 | $ 7,290.16 | |||
| 2021 | Asia | India | 3 | $ 10,761.25 | $ 12,052.60 | |||
| 2021 | Europe | Denmark | 1 | $ 11,197.21 | $ 12,876.79 | |||
| 2021 | Asia | Taiwan | 1 | $ 12,741.96 | $ 14,270.99 | |||
| 2021 | Europe | France | 2 | $ 12,959.93 | $ 14,515.13 | |||
| 2021 | Asia | China | 4 | $ 13,028.05 | $ 8,859.07 | |||
| 2021 | Africa | Nigeria | 1 | $ 13,474.58 | $ 15,630.52 | |||
| 2021 | Europe | Netherland | 3 | $ 13,565.99 | $ 16,821.82 | |||
| 2021 | Americas | USA | 2 | $ 15,529.35 | $ 15,063.47 | |||
| 2021 | Asia | China | 1 | $ 15,974.04 | $ 17,890.93 | |||
| 2021 | Europe | Netherland | 4 | $ 16,506.06 | $ 19,312.09 | |||
| 2021 | Americas | USA | 4 | $ 19,795.33 | $ 12,669.01 | |||
| 2021 | Asia | Pakistan | 4 | $ 20,527.14 | $ 23,811.48 | |||
| 2021 | Asia | Pakistan | 3 | $ 21,038.96 | $ 23,563.64 | |||
| 2021 | Asia | China | 2 | $ 21,431.43 | $ 24,860.45 | |||
| 2021 | Americas | USA | 3 | $ 43,047.58 | $ 48,643.77 |
Exercise: Pivot Table Financial performance data are collected for cities in the regions of Africa, Americas, Asia, and Europe for years of 2019, 2020, and 2021 . See columns D - I 1. Make a Pivot Table of Average Revenue and Expenses for each region for 2020 and 2021. 2. Make a Pivot Chart of Average Expenses for each region for all 3 years. 3. Make a Pivot Table of showing Total Profit for each country for 2021 (Hint: Profit = Revenue - Expenses. Must be calculated using Pivot Commands.) 4. Make a Pivot chart of showing Total Profit for each country for 2021. 5. Briefly discuss the results obtained for each of the above activity in the Ex2 Discussions Tab. *Keep answers for Ex 2 1-4 in this tab.
Ex2 Discussions
Example 2 Discussions 1. Pivot Table of Average Revenue and Expenses for each region for 2020 and 2021. 2. Pivot Chart of Average Expenses for each region for all 3 years. 3. Pivot Table showing Total Profit for each country for 2021 4. Make a Pivot chart of showing Total Profit for each country for 2021.
Ex7
| Group Name | Group Segment | Revenue | Expenses | Net Income/Loss | Data | ||||||||
| Postcards Store | Big | 8249.3276698127 | 594.878242008 | 7654.4494278048 | Group Segment | Sum of Expenses | Sum of Revenue | ||||||
| Randles Roadshack | Small | 6557.8729832219 | 83.3393859721 | 6474.5335972499 | Big | 41586390.9696846 | 48945091.5423439 | ||||||
| Examineers Inc | Medium | 6180.0357471981 | 551.2667803915 | 5628.7689668066 | Medium | 2310.7997296187 | 22222.6176752647 | ||||||
| Buttersworth Co | Small | 9915.4543112251 | 336.8576784372 | 9578.5966327879 | Small | 2186.2988659312 | 30444.5522903428 | ||||||
| FASST Trax | Small | 4047.6691780881 | 481.0083008923 | 3566.6608771959 | Grand Total | 41590888.0682801 | 48997758.7123095 | ||||||
| Hula Hoopers | Big | 4797.0875045761 | 962.3550943443 | 3834.7324102318 | |||||||||
| Hehehe | Medium | 6537.8001010167 | 931.9697247837 | 5605.830376233 | |||||||||
| Marleyville Tea | Small | 3151.4227753704 | 848.2135170178 | 2303.2092583526 | |||||||||
| Creepy Lada | Medium | 9504.7818270498 | 827.5632244434 | 8677.2186026064 | |||||||||
| Jokes R Us | Big | 9378.1404699585 | 566.7976536033 | 8811.3428163552 | |||||||||
| Petie's Palace | Small | 6772.1330424373 | 436.8799836118 | 6335.2530588255 | |||||||||
| Ramone's Castle | Big | 48922666.9867 | 41584266.9386946 | 7338400.04800493 |
Exercise 7 Because Ramone's Castle is a high outlier, take it out of the pivot table that is already done. Show Revenue and Expenses by Group Segment (excluding Ramone's Castle). Have "Sum of Revenue" be the left column (you may need to switch the two columns). Keep pivot table in this tab.
