INSTRUCTIONS Using spreadsheet software enter the following table below that shows the number of tourists visiting the following countries over a five-year period. Use Times New Roman and Font size 12. Name the worksheet Table. COUNTRIE S 2014 2015 2016 2017 2018 ‘000 ‘000 ‘000 ‘000 ‘000 Grenada 350 465 375 250 485 Antigua and Barbuda 153 160 155 149 256 Barbados 573 625 725 680 740 St. Kitts 347 515 538 178 384 St. Lucia 600 436 368 535 858 Trinidad and Tobago 379 563 475 415 563 Jamaica 416 200 500 300 475 Bahamas 300 450 550 460 470 Aruba 208 367 415 500 684 Dominica 135 317 279 350 465 Insert a column to the right of the table with the heading “Total Visitors”. In that same column compute the total number of tourists that visited each country over the years. Insert a row heading Maximum to show the maximum number of visitors for each given year. Sort the data in ascending order based on the Countries. Insert a row heading Minimum to show the minimum number of visitors for each given year. Display the years as vertical headings, using a different font style and bold. All other column headings should be horizontally centred and bold. Insert a column to the right, entitled Taxes. In this column calculate the total taxes each government would have earned over the five year period, if each visitor had to pay $1.25 as an entrance tax. Format this column to currency. Apply borders to each cell in the table. Insert an appropriate heading to the top of the table, centre it across the table, using font size 20, font Cambria and font colour blue. Centre the table vertically and horizontally on the page. Display formulaes and copy the table with the formulaes displayed to another worksheet labelled: Formulae. When finish, turned off display formaule in the sheet labelled Table. Create a column chart on a separate worksheet, labelled Chart, comparing the total number of visitors to each country over the five-year period. Label the chart appropriately.
INSTRUCTIONS Using spreadsheet software enter the following table below that shows the number of tourists visiting the following countries over a five-year period. Use Times New Roman and Font size 12. Name the worksheet Table. COUNTRIE S 2014 2015 2016 2017 2018 ‘000 ‘000 ‘000 ‘000 ‘000 Grenada 350 465 375 250 485 Antigua and Barbuda 153 160 155 149 256 Barbados 573 625 725 680 740 St. Kitts 347 515 538 178 384 St. Lucia 600 436 368 535 858 Trinidad and Tobago 379 563 475 415 563 Jamaica 416 200 500 300 475 Bahamas 300 450 550 460 470 Aruba 208 367 415 500 684 Dominica 135 317 279 350 465 Insert a column to the right of the table with the heading “Total Visitors”. In that same column compute the total number of tourists that visited each country over the years. Insert a row heading Maximum to show the maximum number of visitors for each given year. Sort the data in ascending order based on the Countries. Insert a row heading Minimum to show the minimum number of visitors for each given year. Display the years as vertical headings, using a different font style and bold. All other column headings should be horizontally centred and bold. Insert a column to the right, entitled Taxes. In this column calculate the total taxes each government would have earned over the five year period, if each visitor had to pay $1.25 as an entrance tax. Format this column to currency. Apply borders to each cell in the table. Insert an appropriate heading to the top of the table, centre it across the table, using font size 20, font Cambria and font colour blue. Centre the table vertically and horizontally on the page. Display formulaes and copy the table with the formulaes displayed to another worksheet labelled: Formulae. When finish, turned off display formaule in the sheet labelled Table. Create a column chart on a separate worksheet, labelled Chart, comparing the total number of visitors to each country over the five-year period. Label the chart appropriately.
Step by step
Solved in 3 steps with 12 images
