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 FOR EACH QUESTION CREATE A NEW WORKSHEET 1. Which supplier is highly paid? Show the rankst. ROW SUPPLIERS COLUMN HIGHEST TAX 2. Prepare a datatable with Supplier rowand the highest la indusive amount paid for each service option as coin? ROW SUPPLIERS COLUMN HIGHEST TAX (SERIVE DESCH 3. Identifying Top 3 description of services that record the Highest tax inclusive amount paid? Represent the table using a suitable graph ROW COLOW SERVICES DES HOHENTAX 4. Idently for which description of service did the company pay the Highest paid tax inclusive amont in the year 2012 7 Represent the values of Grand total and show using a suitable graph 2012 ROW COLUMN SERVICES DESIGN AS AN OF GRA Student name and id Intro DATA SHEET Questions 3. Identify ang Top 3 description of services at records the highest tax inclusive amount paid? Represent the table using a suitable grach ROW COLUMN SERVICES DESHIGHEST TAX 4. Identity for which description of service did the company pay the Highest paid tax inclusive amont in the year 2012 7 Represent the value of Grand Hotel and show it using a suitable graph 2012 ROW COLUMN SERVICES DES HIGHEST TAXAS AS OF GRAND BP. Capital Trance to payments for the month of October 2011 Sum of TAX INCUX AMT Row Labels 2011 Grand Total Cronal Bank Erde PVM HP France 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 FOR EACH QUESTION CREATE A NEW WORKSHEET 1. Which supplier is highly paid? Show the rankst. ROW SUPPLIERS COLUMN HIGHEST TAX 2. Prepare a datatable with Supplier rowand the highest la indusive amount paid for each service option as coin? ROW SUPPLIERS COLUMN HIGHEST TAX (SERIVE DESCH 3. Identifying Top 3 description of services that record the Highest tax inclusive amount paid? Represent the table using a suitable graph ROW COLOW SERVICES DES HOHENTAX 4. Idently for which description of service did the company pay the Highest paid tax inclusive amont in the year 2012 7 Represent the values of Grand total and show using a suitable graph 2012 ROW COLUMN SERVICES DESIGN AS AN OF GRA Student name and id Intro DATA SHEET Questions 3. Identify ang Top 3 description of services at records the highest tax inclusive amount paid? Represent the table using a suitable grach ROW COLUMN SERVICES DESHIGHEST TAX 4. Identity for which description of service did the company pay the Highest paid tax inclusive amont in the year 2012 7 Represent the value of Grand Hotel and show it using a suitable graph 2012 ROW COLUMN SERVICES DES HIGHEST TAXAS AS OF GRAND BP. Capital Trance to payments for the month of October 2011 Sum of TAX INCUX AMT Row Labels 2011 Grand Total Cronal Bank Erde PVM HP France Grand Total