Sample Answers

From the above Datasets, may I know what kind of Excel Formulas should I use to get the same answer as shown in the Sample Answers? Provide your answers in the yellow highlighted fields of each answer tab.

As clear as possible, please show your workings for your attempts at answering the questions. E.g. usage of formulas, pivot tables

A 1 Year 2 2015 3 2015 4 2015 5 2015 6 2015 7 2015 8 2015 9 2015 10 2015 11 2015 12 2015 13 2015 14 2015 15 2015 16 2015 17 2015 18 2015 19 2015 20 2016 21 2016 22 2016 23 2016 24 2016 25 2016 26 2016 B Services Industry Accommodation Services Accommodation Services Accommodation Services Accommodation Services Business Services Financial & Insurance Activities Financial & Insurance Activities Financial & Insurance Activities Financial & Insurance Activities Food & Beverage Services Food & Beverage Services Information & Communications Information & Communications Information & Communications Recreation, Community & Personal Services Recreation, Community & Personal Services Recreation, Community & Personal Services Recreation, Community & Personal Services Accommodation Services Accommodation Services Accommodation Services Accommodation Services Business Services Financial & Insurance Activities Financial & Insurance Activities Business Cost Item 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost 3. Services Cost D E Detailed Business Cost Item Business Cost Structure (% share) 3.1 Cargo handling fees and port & airport charges 0.0 3.15 Fuel 0.0 3.2 Charter fees 0.0 3.3 Freight charges 0.0 3.3 Freight charges 0.0 3.1 Cargo handling fees and port & airport charges 0.0 3.15 Fuel 0.0 3.2 Charter fees 0.0 3.3 Freight charges 0.0 3.1 Cargo handling fees and port & airport charges 0.0 3.2 Charter fees 0.0 3.15 Fuel 0.0 3.2 Charter fees 0.0 3.3 Freight charges 0.0 3.1 Cargo handling fees and port & airport charges 3.15 Fuel 0.0 3.2 Charter fees 3.3 Freight charges 0.0 3.1 Cargo handling fees and port & airport charges 0.0 3.15 Fuel 0.0 3.2 Charter fees 0.0 3.3 Freight charges 0.0 3.3 Freight charges 0.0 3.1 Cargo handling fees and port & airport charges 0.0 3.15 Fuel 0.0 0.0 0.0 B D E F G H Sum of Business Cost Structure (% share) WN 0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Accommodation Services 1. Labour Cost 2. Non-Labour Production Taxes 3. Services Cost Business Services 1. Labour Cost 2. Non-Labour Production Taxes 3. Services Cost Financial & Insurance Activities 1. Labour Cost 2. Non-Labour Production Taxes 3. Services Cost Information & Communications 1. Labour Cost 2. Non-Labour Production Taxes 3. Services Cost Grand Total 2015 2016 2017 25.00% 24.98% 24.98% 25.03% 10.78% 10.90% 10.90% 0.65% 0.73% 0.73% 13.58% 13.35% 13.40% 25.05% 25.03% 24.96% 6.80% 6.83% 7.00% 0.48% 0.43% 0.45% 17.78% 17.78% 17.50% 24.98% 24.98% 25.03% 3.73% 3.58% 3.40% 0.05% 0.05% 0.05% 21.20% 21.36% 21.58% 24.98% 25.01% 24.98% 5.50% 5.23% 4.65% 0.10% 0.10% 0.08% 19.38% 19.68% 20.26% 100.00% 100.00% 100.00%