Rename and organize the worksheets within the workbook

Assignment Help Basic Computer Science
Reference no: EM131299430

COMPUTER ESSENTIALS

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. 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.

5. In cell B7, create a formula that adds the annual totals of all four categories using cells B2, B3, B4, and B5 which will give you the total annual revenue for the Bahamas Cruise Line.

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.

Part 3: Charts & Subtotals-Create a pie chart that compares each revenue source in the month of January and use the subtotals feature in excel to total three separate categories of revenue. Use the following instructions:

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.

Attachment:- 1010excel.xlsx

Reference no: EM131299430

Questions Cloud

Design a welding jig : MFG 343 Manufacturing Tool Design Project. For the part show in the following drawing you are to design a welding jig sufficient to locate and clamp the part for the necessary welding operations
How did the attacker gain access to the system : How did the attacker gain access to the system? Provide as much detail as possible about the attack, the tool used, etc. What IP address or addresses did the attacker use?
What are strategies behind implementing cloud computing : What are some of the major strategies and risks behind implementing cloud computing programs in today's technology filled world?
Create an analogy or metaphor : Create an analogy or metaphor that explains how banks create and destroy money-one that would be understood by someone with absolutely no background in economics.
Rename and organize the worksheets within the workbook : Worksheet & Workbook Management- Rename and organize the worksheets within the workbook and re-save the workbook itself by following the instructions below: Access and open 1010excel.xlsx.
What role do banks play in process : Explain how the Fed can increase the money supply by engaging in open-market operations. What role do banks play in this process?
Computer users do to practice green computing : How responsible should consumers be for energy conservation in relation to electronic use? In your opinion, what, if anything, should all computer users do to practice green computing?
Terms of government loanable funds : Given the current market situation, what would you expect in terms of government loanable funds?
Unpleasant options to restore long run balance : What is the key long-run problem of both Social Security and Medicare? What are some of the unpleasant options to restore long -run balance to both Social Security and Medicare?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Documentation in chicago format

Using purely C language create a GUI based application for getting the static voltage of a calculator and write a 6 pages documentation in Chicago format.

  Is it guaranteed to be conflict-serializable

SQL-92 supports four isolation-levels and two access-modes, for a total of eight combinations of isolation-level and access-mode. Each combination implicitly defines a class of transactions; the following questions refer to these eight classes.

  Write the equation in standard form

Can some should me a step by step on how to solve this problem? Complete the square and write the equation in standard form. Then give the center and radius of the circle.

  What is the output of this code sequence

What is the output of this code sequence?

  Describe an instance where you not have experience with gui

Describe an instance where you did not have an intuitive experience with a GUI. Recommend the key areas that could have been improved.

  Write a function that displays the prompt string

Write a function that displays the prompt string, followed by a space, reads a floating point number in, and returns it.

  Write a complete c++ program that reworks your cellular bill

Write a complete C++ program that reworks your Cellular Bill calculation program from Chapter 4. Give your source file a meaningful name, such as CellBillFun.cpp.

  Perform insert using binomial queues

Give an algorithm to build a binomial queue of N elements, using at most N - 1 comparisons between elements.  Propose an algorithm to insert M nodes into a binomial queue of N elements in O(M + log N) worst-case time. Prove your bound. Write an ef?ci..

  Define the tf-idf scheme of determining the weight

Define the TF-IDF scheme of determining the weight of a keyword in a document.

  Features of windows and linux operating systems

Compare the Security features of windows and Linux operating systems?

  Create a flowchart and a storyboard

Use the information below to create a storyboard (which can be a text based description for solving the problems) and a flowchart (using flowchart symbols to illustrate how you would program) to solve each problem. You may use Microsoft Word® for you..

  Health insurance portability and accountability act

The case described in the Introduction is not atypical, even with as much emphasis as there is on information security; it is a good example of where an organization has violated the HIPAA and/or state laws.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd