FOR EACH QUESTION CREATE A NEW WORKSHEET

1. Which supplier is highly paid? Show the rank list.

ROW

COLUMN

SUPPLIERS

HIGHEST TAX

2. Prepare a data table with Suppliers (row) and the highest tax inclusive amount paid for each service description ( as column)?

ROW

COLUMN

SUPPLIERS

HIGHEST TAX (SERIVE DESCRIPTION)

3. Identify using Top 3 description of services that records the highest tax inclusive amount paid? Represent the table using a suitable graph

ROW

COLUMN

SERVICES DESCRIPTION

HIGHEST TAX

4. Identify for which description of service did the company pay the Highest paid tax inclusive amont in the year 2012 ? Represent the value as a % of Grand total and show it using a suitable graph

2012

ROW

COLUMN

SERVICES DESCRIPTION

HIGHEST TAX AS A % OF GRAND TOTAL

5

Example (Pty) Ltd, Capital Bank,HP Finance tax payment details for the month of october 2011?

Sum of TAX INCUX AMT

Row Labels

2011

Grand Total

Capital Bank

$

Example (Pty) Ltd

$

HP Finance

$

Grand Total

Student name and id Intro DATA SHEET Questions BANK CODE ACCOUNT CODE AYNENT DATE B1 BS-500 20791 81 31311 81 15-375 14211 23/11 153/11 15/02/11 15/11 1578711 18911 20/07/11 20/311 20/3/11 20/3/11 20/3/11 SERVICE DESCRIPTION Opening Barice Internet Service Provider Subscrior merance Service Service locong Account Trailer Inter Account Tale San REFERENCE 577782 inwe EP22 Debilde Bank Statement Bara fatament www Cash TROUW Transfer Payroll De Order Det Debit Order Batman Statement Exp Debat Cash Bus Statement Trader SUPPLIER XY Solution 13 Communications News.com EAG Broker Cat Bore More 0 International re Eum IPL Example Pay L HP France PR Egy EPY I Carm EM w Capwers Cow Bar AS A EP BPLN and eventue ang FONY 01 12 01 PC 31 B2 31 32 81 TAX INCUXAMT STATUS CODE 170 478 A 30 A 50 A 30 A 1.000 A 00 A 200 A 15.000 E 15.000 E 18.000 E 220 E 100 E 6,400 A 100 E -100 E 19 A 10 A AT A RO A A 1.000 A 20.000 20.000 1100 Cooler 15/311 15/11 24/11 15311 1311 2011 20/11 11 311 2011 2011 371 31/01 111 WUM 111 191 19 31 Pay Cash Rembrane Potty Cash Return Service 18-315 15-315 18-300 15.345 18-300 B9300 B8-300 15-365 33.900 15.500 15-30 35.300 15. 15.00 0 15345 15-315 15-315 15-306 B. 15-300 35.400 15-16 1.100 PO 11 13/11 11 151 1511 2011 2014 Power Service Fees Services 31 PC 31 2 51 2 B Transfer in Account Trader Account Transfer 2011 2011 2011 2011 2011 Maler Parol w Debe DO 2011 Card 200 3 11 00 2411 Student name and id Intro DATA SHEET Questions BANK CODE ACCOUNT CODE AYNENT DATE B1 BS-500 20791 81 31311 81 15-375 14211 23/11 153/11 15/02/11 15/11 1578711 18911 20/07/11 20/311 20/3/11 20/3/11 20/3/11 SERVICE DESCRIPTION Opening Barice Internet Service Provider Subscrior merance Service Service locong Account Trailer Inter Account Tale San REFERENCE 577782 inwe EP22 Debilde Bank Statement Bara fatament www Cash TROUW Transfer Payroll De Order Det Debit Order Batman Statement Exp Debat Cash Bus Statement Trader SUPPLIER XY Solution 13 Communications News.com EAG Broker Cat Bore More 0 International re Eum IPL Example Pay L HP France PR Egy EPY I Carm EM w Capwers Cow Bar AS A EP BPLN and eventue ang FONY 01 12 01 PC 31 B2 31 32 81 TAX INCUXAMT STATUS CODE 170 478 A 30 A 50 A 30 A 1.000 A 00 A 200 A 15.000 E 15.000 E 18.000 E 220 E 100 E 6,400 A 100 E -100 E 19 A 10 A AT A RO A A 1.000 A 20.000 20.000 1100 Cooler 15/311 15/11 24/11 15311 1311 2011 20/11 11 311 2011 2011 371 31/01 111 WUM 111 191 19 31 Pay Cash Rembrane Potty Cash Return Service 18-315 15-315 18-300 15.345 18-300 B9300 B8-300 15-365 33.900 15.500 15-30 35.300 15. 15.00 0 15345 15-315 15-315 15-306 B. 15-300 35.400 15-16 1.100 PO 11 13/11 11 151 1511 2011 2014 Power Service Fees Services 31 PC 31 2 51 2 B Transfer in Account Trader Account Transfer 2011 2011 2011 2011 2011 Maler Parol w Debe DO 2011 Card 200 3 11 00 2411