Unit IV Excel assignment

page” title=”Page 3
layoutArea
column

Unit IV Assignment

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.

Part 1: Worksheet & Workbook Management—Rename and organize the worksheets within the workbook and re-save the workbook itself by following the instructions below:

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—In this section you will assist the sales manager in categorizing the company’s revenue sources and how each one relates to each other. You will use formulas and functions to create totals and/or averages of the revenue data following the instructions below. Make sure you are in the Formulas&Functions active worksheet before you begin:

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.

layoutArea
column

CS 1010, Computer Essentials 3

page” title=”Page 4
layoutArea
column