You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet & Workbook Man

  Excel Assignment    Requirements: You will need Excel 2007, 2010, or 2013 to complete this project. You will also need the following file(s): 1010excel.xlsx.    Project Background: You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet & Workbook Management, Formulas & Functions, and Charts & Subtotals.         Should you need additional help for adding numbers in excel, using functions, formulas, subtotals, or charts please see the suggested further reading.          1. Click here to access and open 1010excel.xlsx.   2. Save the 1010excel.xlsx file as your ”student ID number_last name.xlsx” (ex: 12345_Jones.xlsx).   3. Rename Sheet 1 to Formulas&Functions.   4. Rename Sheet 2 to Chart.   5. Rename Sheet 3 to Subtotals.   6. Move the Chart worksheet to the right of the Subtotals worksheet.   7. Create a fourth worksheet using your student ID number as the name.   8. Save the file.  Part 2: Formulas & Functions    1. In cell B2, create a function that totals Jan through Dec sales for Online Reservations. 2. In cell B3, create a function that totals Jan through Dec sales for Telephone Reservations. 3. In cell B4, create a function that totals Jan through Dec sales for Sales Calls. 4. In cell B5, create a function that totals Jan through Dec sales for Activity Companies.      6. In cell C2, create a function that displays the average for online reservations from Jan through Dec. Repeat this for the other three categories of revenue.   7. Save the file.     Make sure the Chart worksheet is active before you begin.    1. Create a pie chart using the range A1 to B5.   2. Slightly detach the sales calls piece of the pie from the rest of the pie chart.   3. Save the file.    Make sure the Subtotals worksheet is active before you begin.    1. Sort the list by category.   2. Use the subtotals function in excel to display totals for the three categories on this worksheet (Activities, Hotels, and Retail) in blocks D26, D27, & D28   3. Save the file and submit for grading. 
The post You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet & Workbook Man appeared first on Homework Aider.

What Students Are Saying About Us

"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"