1. Using the data in Table E1A - 1, create the worksheet shown in Figure ElA - 1. 2. Use the Metropolitan Theme (Or any theme you like). 3. Use the Sum button to ereate the total revemue for each of the four vacation spots and the totals for each of the four vacation packages. 4. Format the worksheet title, VACATION PACKAGE ANALYSIS, as Heading 1 style, and centered across columns A through F. 5. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and curency style) to forrmat the remaining cells so the worksheet displays as shown in Figure ElA - 2. 6. Add the 3-D Pie chart shown on the worksheet in Figure ElA - 2. Apply the Style 8 chart style to the chart. 7. Name the worksheet Vacation. Color the tab blue. 8. Edit the document properties according to the instructions from your instructor. Save the workbook on your disk using the file name, Yourmame -Excel Chapter 1- Lab Test A, where Yourname is your own last name. 9. Leave the worksheet open for evaluation. 10. Change the amount for the All Inelusive package for Alaska to 6,538. Decrease the amount for Hotel Only in Cancun to 1,787 and the amount for Tours Phas in Hawaii to 3,208. The vacation spot totals will be: Hawaii - $13,241.00, Anuba – 1,248.00, Cancun -S14,450.00, and Alaska – 520,563.00.
1. Using the data in Table E1A - 1, create the worksheet shown in Figure ElA - 1. 2. Use the Metropolitan Theme (Or any theme you like). 3. Use the Sum button to ereate the total revemue for each of the four vacation spots and the totals for each of the four vacation packages. 4. Format the worksheet title, VACATION PACKAGE ANALYSIS, as Heading 1 style, and centered across columns A through F. 5. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and curency style) to forrmat the remaining cells so the worksheet displays as shown in Figure ElA - 2. 6. Add the 3-D Pie chart shown on the worksheet in Figure ElA - 2. Apply the Style 8 chart style to the chart. 7. Name the worksheet Vacation. Color the tab blue. 8. Edit the document properties according to the instructions from your instructor. Save the workbook on your disk using the file name, Yourmame -Excel Chapter 1- Lab Test A, where Yourname is your own last name. 9. Leave the worksheet open for evaluation. 10. Change the amount for the All Inelusive package for Alaska to 6,538. Decrease the amount for Hotel Only in Cancun to 1,787 and the amount for Tours Phas in Hawaii to 3,208. The vacation spot totals will be: Hawaii - $13,241.00, Anuba – 1,248.00, Cancun -S14,450.00, and Alaska – 520,563.00.
Principles Of Marketing
17th Edition
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Kotler, Philip, Armstrong, Gary (gary M.)
Chapter1: Marketing: Creating Customer Value And Engagement
Section: Chapter Questions
Problem 1.1DQ
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:
9780134149530
Author:
Gary Armstrong, Philip Kotler
Publisher:
PEARSON
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning