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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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.

AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Knowledge Booster
Introduction to computer system
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education