Homework Help is Here – Start Your Trial Now!
Business
Marketing
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
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
See similar textbooks
icon
Related questions
Question
100%
workbook. Problem: You are working for a travel agency. You want to track and compare the prices for four of your customers' favorite destinations using the popular 5-Day Packages. Your worksheet will show the packages in the first column and the package prices for the four destinations in the other columns, as shown in Table E1A - 1. Instructions: Perform the tasks below to design and create the Vacation Package Analysis Workbook. Use the data provided in Table E1A - 1. 1. Using the data in Table ElA - 1, create the worksheet shown in Figure E1A - 1. 2. Use the Metropolitan Theme (Or any theme you like). 3. Use the Sum button to create the total revenue for each of the four vacation spots and the totals for each of the four vacation packages. Format the worksheet title, VACATION PACKAGE ANALYSIS, as Heading 1 style, and centered across columns A through F. 4. 5. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and curreney style) to format 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 Inclusive package for Alaska to 6,538. Decrease the amount for Hotel Only in Cancun to 1,787 and the amount for Tours Phus in Hawaii to 3,208. The vacation spot totals will be: Hawaii – $13,241.00, Aruba – $11,248.00, Cancun - S14,450.00, and Alaska – $20,563.00. 11. S lin Eleame: 12. Upload the completed worksheet for evaluation. VACATION PACKAGE ANALYSIS | 5-Day Packages Hawaii Aruba Cancun Alaska Totals $ 6,489.00 $ 7,251.00 $ 5,254.00 All Inclusive $8,084.00 Tours Plus 3,589.00 3,125.00 4,683.00 8,561.00 Hotel Only 1,250.00 975.00 2,153.00 3,515.00 Cruise 699.00 659.00 729.00 1,949.00 Totals Table E1A - 1 Excel Chapter 1 - Lab Test A - Excel ? E - C x Sign in P E- r FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 10 - ==- Conditional Fomatting insert- Arial General BIU- AA === - $- % * Delete- - - Format as Table- Paste O. A- Cell Styles Format Clipboard Font Alignment G NumberG Styles Cells Editing F15 A в D F G 1 VACATION PACKAGE ANALYSIS Aruba 2 5-Day Packages Hawaii 3 All Inclusive Cancun Alaska Totals $ 8,084. 00 $ 6,489.00 $ 7,251.00 $ 5,254.00 $ 27,078.00 4 Tours Plus 3,589.00 3,125.00 4,683.00 8,561.00 19,958.00 5 Hotel Only 1,250.00 975.00 2,153.00 3,515.00 7,893.00 6 Cruise 699.00 659.00 729.00 1,949.00 4,036.00 7 Totals $ 13,622.00 $ 11,248.00 $ 14,816.00 $ 19,279.00 $ 58,965.00 10 DESTINATION COMPARISON 11 12 13 Hawai 14 Alaska 15 16 17 18 19 20 21 Aruba 22 23 24 Cancun 25
Transcribed Image Text:workbook. Problem: You are working for a travel agency. You want to track and compare the prices for four of your customers' favorite destinations using the popular 5-Day Packages. Your worksheet will show the packages in the first column and the package prices for the four destinations in the other columns, as shown in Table E1A - 1. Instructions: Perform the tasks below to design and create the Vacation Package Analysis Workbook. Use the data provided in Table E1A - 1. 1. Using the data in Table ElA - 1, create the worksheet shown in Figure E1A - 1. 2. Use the Metropolitan Theme (Or any theme you like). 3. Use the Sum button to create the total revenue for each of the four vacation spots and the totals for each of the four vacation packages. Format the worksheet title, VACATION PACKAGE ANALYSIS, as Heading 1 style, and centered across columns A through F. 4. 5. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and curreney style) to format 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 Inclusive package for Alaska to 6,538. Decrease the amount for Hotel Only in Cancun to 1,787 and the amount for Tours Phus in Hawaii to 3,208. The vacation spot totals will be: Hawaii – $13,241.00, Aruba – $11,248.00, Cancun - S14,450.00, and Alaska – $20,563.00. 11. S lin Eleame: 12. Upload the completed worksheet for evaluation. VACATION PACKAGE ANALYSIS | 5-Day Packages Hawaii Aruba Cancun Alaska Totals $ 6,489.00 $ 7,251.00 $ 5,254.00 All Inclusive $8,084.00 Tours Plus 3,589.00 3,125.00 4,683.00 8,561.00 Hotel Only 1,250.00 975.00 2,153.00 3,515.00 Cruise 699.00 659.00 729.00 1,949.00 Totals Table E1A - 1 Excel Chapter 1 - Lab Test A - Excel ? E - C x Sign in P E- r FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - 10 - ==- Conditional Fomatting insert- Arial General BIU- AA === - $- % * Delete- - - Format as Table- Paste O. A- Cell Styles Format Clipboard Font Alignment G NumberG Styles Cells Editing F15 A в D F G 1 VACATION PACKAGE ANALYSIS Aruba 2 5-Day Packages Hawaii 3 All Inclusive Cancun Alaska Totals $ 8,084. 00 $ 6,489.00 $ 7,251.00 $ 5,254.00 $ 27,078.00 4 Tours Plus 3,589.00 3,125.00 4,683.00 8,561.00 19,958.00 5 Hotel Only 1,250.00 975.00 2,153.00 3,515.00 7,893.00 6 Cruise 699.00 659.00 729.00 1,949.00 4,036.00 7 Totals $ 13,622.00 $ 11,248.00 $ 14,816.00 $ 19,279.00 $ 58,965.00 10 DESTINATION COMPARISON 11 12 13 Hawai 14 Alaska 15 16 17 18 19 20 21 Aruba 22 23 24 Cancun 25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Principles Of Marketing
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
Marketing
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
Foundations of Business (MindTap Course List)
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: An Introduction (13th Edition)
Marketing
ISBN:
9780134149530
Author:
Gary Armstrong, Philip Kotler
Publisher:
PEARSON
MKTG 12:STUDENT ED.-TEXT
MKTG 12:STUDENT ED.-TEXT
Marketing
ISBN:
9781337407595
Author:
Lamb
Publisher:
Cengage
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS