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 ________________ .
-
Fresh numbers from the U.S. Department of Transportation suggest that fewer lights in the U.S. arrive on time than before. The explanations offered for the lackluster performance are understaffed...
-
Imagine that Commodore has taken out a multimillion-dollar loan that must be repaid next year. How might the lender react if it learned that Commodore was using the book-and-hold method to make...
-
Farraway Company uses ABC to account for its chrome wheel manufacturing process. Company managers have identified four manufacturing activities that incur manufacturing overhead costs: materials...
-
Indicate whether each of the following costs for a moped manufacturer is a product or a period cost, a variable or a fixed cost, a value-adding or a nonvalue-adding cost, and, if it is a product...
-
The hybrid state of the Xe and shape of the XeF4 molecule are: 1. (a) sp and tetrahedral 2. (c) sp d and square planar (b) spd and tetrahedral (d) sp d and see saw Which of the following relation is...
-
1. If Bozena participates and the 401(k) earns 10 percent annually, how much will she have accumulated in 45 years (to age 67) even if her salary does not change? 2. If she does not participate and...
-
Express the following sum in closed form. 2 k 2 (4 + 3 - 4 ) = n k 1
-
You have been out of school and gainfully employed for 5 years. You have three alternatives available for investment with your own money. Each has some element of risk, although some are safer than...
-
The Federal Reserve has a listing of the nonconventional policy tools used for liquidity provision at https://www.federalreserve.gov/monetarypolicy/ expiredtools.htm. Of those tools, which one was...
-
Brenda Johnson is considering purchasing a new car for business purposes. She has narrowed her choice to three cars; the cost details are given below: Brenda estimates she will travel about 4,000...
-
It can be an interesting exercise to compare the purchasing power of the dollar over different periods in history. Go to https://www.bls.gov/data/inflation_ calculator.htm to find the inflation...
-
A new engineering building is to contain 400,000 square feet. The total cost of the building (TC) is given by a. Create a table that shows the total building cost, average cost per floor, and cost...
-
An e-commerce site allows customers to order products, based on availability. Customers fill out an online application form containing name, phone number, credit card information, and products they...
-
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 file ApplianceShipments.csv contains the series of quarterly shipments (in million dollars) of US household appliances between 1985 and 1989 (data courtesy of Ken Black). a. Create a...
-
Canadian Manufacturing Workers Workhours. The time plot in Figure 17.9 describes the average annual number of weekly hours spent by Canadian manufacturing workers (data are available in...
-
Shampoo Sales. The file ShampooSales.csv contains data on the monthly sales of a certain shampoo over a three-year period. [Source: Hyndman and Yang (2018). a. Create a well-formatted time plot of...
Study smarter with the SolutionInn App