Purpose: To demonstrate the ability to build a worksheet, format a worksheet, embed a Pie chart,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Purpose: To demonstrate the ability to build a worksheet, format a worksheet, embed a Pie chart, print a worksheet, and save a 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 EIA- 1. Instructions: Perform the tasks below to design and create the Vacation Package Analysis Workbook. Use the data provided in Table EIA - 1. 1. 2. 3. 4. 5. Microsoft Excel - Lab 1 Creating an Analysis Worksheet 6. 7. 8. Using the data in Table E1A-1, create the worksheet shown in Figure EIA - 1. Use the Metropolitan Theme. 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 I style, and centered across columns A through F. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and currency style) to format the remaining cells so the worksheet displays as shown in Figure EIA-2. Add the 3-D Pie chart shown on the worksheet in Figure E1A-2. Apply the Style 8 chart style to the chart. Name the worksheet Vacation. Color the tab blue. Edit the document properties according to the instructions from your instructor. Save the workbook on your disk using the file name, Yourname - Excel Chapter 1 - Lab Test A, where Yourname is your own last name. 9. 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 Plus in Hawaii to 3,208. The vacation spot totals will be: Hawaii - $13,241.00, Aruba-$11,248,00, Cancun-$14,450.00, and Alaska-$20,563.00. 10. Save as the worksheet containing the new values on your disk using the file name: Yourname - Excel Chapter 1 - Lab Test A_New_Value. VACATION PACKAGE ANALYSIS Aruba $8.084.00 $ 6,489.00 3,589.00 3,125.00 1,250.00 975.00 699.00 659.00 5-Day Packages Hawaii All Inclusive Tours Plus Hotel Only Cruise Totals Page 1 Cancun $ 7,251.00 4,683.00 2,153.00 729.00 Alaska $ 5,254.00 8,561.00 3,515.00 1,949.00 Totals FILE Paste F15 Clipboard G NENN28563633=3* 13 1 2 3 All Inclusive 4 Tours Plus 15 5 Hotel Only 6 Cruise 7 Totals 8 17 S 19 HOME 21 READY Arial 10 BIU- A A 4456 INSERT PAGE LAYOUT Font 1 x 8 5-Day Packages Hawaii ER G Alignment G Se Alaska Table E1A-1 Excel Chapter 1-Lab Test A- Excel DATA REVIEW VIEW Conditional Formatting Format as Table Cell Styles Vacation Sheet2 FORMULAS Sheet3 General $ %. 28 Number Cancun D DESTINATION COMPARISON Styles VACATION PACKAGE ANALYSIS Aruba Cancun Alaska $ 8,084.00 $ 6,489.00 $ 7,251.00 $ 5,254.00 $27,078.00 3,589.00 3,125.00 4,683.00 8,561.00 19,958.00 1,250.00 975.00 2,153.00 3,515.00 7,893.00 699.00 659.00 729.00 1,949.00 4,036.00 $ 13,622.00 $ 11,248.00 $14,816.00 $19,279.00 $ 58,965.00 Figure E1A-2 E Hawa Aruba Cells ? M Insert Delete - Formate Totals Σ... -M- Eating Sign in DX G 100% D Purpose: To demonstrate the ability to build a worksheet, format a worksheet, embed a Pie chart, print a worksheet, and save a 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 EIA- 1. Instructions: Perform the tasks below to design and create the Vacation Package Analysis Workbook. Use the data provided in Table EIA - 1. 1. 2. 3. 4. 5. Microsoft Excel - Lab 1 Creating an Analysis Worksheet 6. 7. 8. Using the data in Table E1A-1, create the worksheet shown in Figure EIA - 1. Use the Metropolitan Theme. 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 I style, and centered across columns A through F. Format the range A2:F8 using the Heading 3 cell style. Use appropriate styles (comma style and currency style) to format the remaining cells so the worksheet displays as shown in Figure EIA-2. Add the 3-D Pie chart shown on the worksheet in Figure E1A-2. Apply the Style 8 chart style to the chart. Name the worksheet Vacation. Color the tab blue. Edit the document properties according to the instructions from your instructor. Save the workbook on your disk using the file name, Yourname - Excel Chapter 1 - Lab Test A, where Yourname is your own last name. 9. 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 Plus in Hawaii to 3,208. The vacation spot totals will be: Hawaii - $13,241.00, Aruba-$11,248,00, Cancun-$14,450.00, and Alaska-$20,563.00. 10. Save as the worksheet containing the new values on your disk using the file name: Yourname - Excel Chapter 1 - Lab Test A_New_Value. VACATION PACKAGE ANALYSIS Aruba $8.084.00 $ 6,489.00 3,589.00 3,125.00 1,250.00 975.00 699.00 659.00 5-Day Packages Hawaii All Inclusive Tours Plus Hotel Only Cruise Totals Page 1 Cancun $ 7,251.00 4,683.00 2,153.00 729.00 Alaska $ 5,254.00 8,561.00 3,515.00 1,949.00 Totals FILE Paste F15 Clipboard G NENN28563633=3* 13 1 2 3 All Inclusive 4 Tours Plus 15 5 Hotel Only 6 Cruise 7 Totals 8 17 S 19 HOME 21 READY Arial 10 BIU- A A 4456 INSERT PAGE LAYOUT Font 1 x 8 5-Day Packages Hawaii ER G Alignment G Se Alaska Table E1A-1 Excel Chapter 1-Lab Test A- Excel DATA REVIEW VIEW Conditional Formatting Format as Table Cell Styles Vacation Sheet2 FORMULAS Sheet3 General $ %. 28 Number Cancun D DESTINATION COMPARISON Styles VACATION PACKAGE ANALYSIS Aruba Cancun Alaska $ 8,084.00 $ 6,489.00 $ 7,251.00 $ 5,254.00 $27,078.00 3,589.00 3,125.00 4,683.00 8,561.00 19,958.00 1,250.00 975.00 2,153.00 3,515.00 7,893.00 699.00 659.00 729.00 1,949.00 4,036.00 $ 13,622.00 $ 11,248.00 $14,816.00 $19,279.00 $ 58,965.00 Figure E1A-2 E Hawa Aruba Cells ? M Insert Delete - Formate Totals Σ... -M- Eating Sign in DX G 100% D
Expert Answer:
Answer rating: 100% (QA)
Open your excel now On the Page Layout tab in the Themes gro... View the full answer
Related Book For
Supply Chain Network Design Applying Optimization and Analytics to the Global Supply Chain
ISBN: 978-0133017373
1st edition
Authors: Michael Watson, Sara Lewis, Peter Cacioppi, Jay Jayaraman
Posted Date:
Students also viewed these computer network questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1. Create a new database to store the two tables related to the electronics store. Call the database, HaveMore Electronics, 2. Create the sales representatives table using the structure shown in...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Marketing efforts to produce, promote, and reclaim environmentally sensitive products are called ________________ .
-
Camden Biotechnology began operations in September 2013. The following selected transactions relate to liabilities of the company for September 2013 through March 2014. Camden's fiscal year ends on...
-
A soil element is shown in Figure 10.33. Determine the following: a. Maximum and minimum principal stresses b. Normal and shear stresses on plane AB Use Eqs. (10.3), (10.4), (10.6), and (10.7). 128...
-
What steps to take in planning the litigation?
-
The comparative balance sheets for Goltra Company show these changes in noncash current asset accounts: accounts receivable decrease $80,000, prepaid expenses increase $28,000, and inventories...
-
How important it is to consider process automation (RPA and BPMS) in the long-term business process improvement practices. And is automation one of the solutions for business process problems/issues,...
-
Lombard Ltd has been offered a contract for which there is available production capacity. The contract is for 20,000 identical items, manufactured by an intricate assembly operation, to be produced...
-
Using the following information: a. Beginning cash balance on March 1, $72,000. b. Cash receipts from sales, $302,000. c. Cash payments for direct materials, $133,000. d. Cash payments for direct...
-
How often should performance appraisals be conducted?
-
What is the difference between the $t$ distribution and the normal distribution?
-
Explain why your university is considered a system. Give examples of other systems that you know.
-
Imagine you are working for a company that sells teleconferencing equipment. Draft a value proposition for selling your equipment to a sales manager who has ten salespeople traveling two weeks a...
-
Think of a time you were talking with someone and felt yourself getting angry. How did you handle it? What steps would you take to keep from getting angry with a customer who was being unreasonable?
-
4. Yusuf only cares about utility and has a utility of income given by U(I) = I/2. (I/2 is the square root of I.) (17 points total) a. Fill out the following chart by calculating his utility from...
-
1. Firms may hold financial assets to earn returns. How the firm would classify financial assets? What treatment will such financial assets get in the financial statements in accordance with US GAAP...
-
A producer of dog food is trying to decide whether they should change the number and locations of their warehouses to better meet projected demand over the next three years. They do a study and...
-
If your baseline models costs are 20% lower than the actual costs, under what conditions could this still be a valid baseline?
-
If the planners of Logistica had been lucky enough for their first calculation to have picked an existing city, why should they still analyze other cities?
-
The financial management process is important for auditors because of its role in helping to form expectations about financial statement results. To illustrate this concept, explain how an...
-
Consider Manny Corp., our military outfitting operation from Chapter 10. Its financial data is reprinted here for convenience. a. If you were the auditor assigned to perform substantive analytical...
-
Following are some routine procedures for the audit of payroll (discussed in the Appendix). For each procedure, (1) state whether it is a test of controls or a substantive test, (2) state which...
Study smarter with the SolutionInn App