INSTRUCTIONS Using spreadsheet software enter the following table below that shows thenumber of tourists visiting the following countries over a five-year period. UseTimes New Roman and Font size 12. Name the worksheet Table. COUNTRIEsS 2014 2015 2016 2017 2018‘000 ‘000 ‘000 ‘000 ‘000Grenada 350 465 375 250 485Antigua andBarbuda 153 160 155 149 256Barbados 573 625 725 680 740St. Kitts 347 515 538 178 384St. Lucia 600 436 368 535 858Trinidad andTobago 379 563 475 415 563Jamaica 416 200 500 300 475Bahamas 300 450 550 460 470Aruba 208 367 415 500 684Dominica 135 317 279 350 465 Insert a column to the right of the table with the heading “Total Visitors”. Inthat same column compute the total number of tourists that visited eachcountry over the years. Insert a row heading Maximum to show the maximum number of visitors foreach given year. Sort the data in ascending order based on the Countries. Insert a row heading Minimum to show the minimum number of visitors foreach given year. Display the years as vertical headings, using a different font style and bold. Allother column headings should be horizontally centred and bold. Insert a column to the right, entitled Taxes. In this column calculate the totaltaxes each government would have earned over the five year period, if eachvisitor 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 anotherworksheet labelled: Formulae. When finish, turned off display formaule in thesheet labelled Table. Create a column chart on a separate worksheet, labelled Chart, comparing thetotal number of visitors to each country over the five-year period. Label thechart 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.
COUNTRIEs
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.
Unlock instant AI solutions
Tap the button
to generate a solution