Be on schedule.Score better.

support@savemydegree.com

Our Services

Get 15% Discount on your First Order

First, open the workbook you downloaded from Step 1. Next, save your workbook as Week2_Lab_YourLastName_YourFirstName.xlsx. The data contains the following

The data contains the following columns.

• Units A, B, and C
• Months
• Years

Step 3: Create Format and Formulas

1. Format the data for currency where needed.
2. Add a title to the data worksheet. Make it larger, bold, and centered over the data using the merge and center option on the home tab. You can also add color to the title.
4. In Column F under total costs, use the sum function to total all three units.
5. Add totals at the bottom of the data for all columns, using the sum function.
6. Add the average to each column by adding the function for average.
7. Screenshot or copy your file in a Microsoft Word document under a label that says Step 3.
8. Save both files.

Step 4: Sort and Filter

1. Select the data except for the total and the average.
2. Click the filter (funnel) on the data tab. You will see small drop-down arrows on all columns.
3. Sort the total cost ascending. Take a screenshot of your sort results. Paste the screenshot into your MS Word document under a label that says Step 4 – Part 1.
4. Click undo or clear filter at the bottom. Select all to turn check marks off and put a check mark in JAN. Take a screenshot of your filtered results and paste it into your MS Word document under the a label that says Step 4 – Part 2.
5. Click undo or uncheck JAN and select DEC. Take a screenshot of the sort results and paste it into your MS Word document under the a label that says Step 4 – Part 3.
6. Using your knowledge of Microsoft Excel, what can you ascertain about the data? Are there interesting insights that come to light as you analyze it using sorting and filtering? Please provide a short summary (50 to 100 words) under the last screenshot.
7. Save both files.

Step 5: Charting

1. Create a pie chart of the total units and the three types of units. You may need to use a different area of the worksheet to set up the pie chart labels and numbers with total cost.
2. Label and format the chart to make it look professional.
3. Screenshot or copy your file in a Microsoft Word document under a label that says Step 5.
4. Under the screenshot in the document, please summarize what you can see in this chart within 50 to 100 words.
5. Save both files.

Step 6: Reflection

1. Open your MS Word document with the sorting and filtering screen prints.
2. Write a short reflection of what you have learned doing this lab exercise. This should be between 100 to 200 words. Within your summary, consider what the data tells you in terms of which units costs more and what months are the highest costs.

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

The leadership paper should be no longer than 7 pages, double-spaced, APA 7th edition format. The paper is based on the following: You are to select and

The leadership paper should be no longer than 7 pages, double-spaced, APA 7th edition format. The paper is based on the following: You are to select and view ONE of the below movies or TV shows: 1. Darabont F. (1994). The Shawshank Redemption. Columbia Pictures 2. Osborne, M & Stevenson,

Deliverable: Final Course Project Submit your finalized Course Project in its entirety.Cover page (one page): Include the course name and number, who you

Deliverable: Final Course Project Submit your finalized Course Project in its entirety. Cover page (one page): Include the course name and number, who you prepared the paper for, your name, and the date as well as the title of your paper. Table of contents (one page) Body of paper (5–8

http://coursematerials.net/emh220/index.html#/lessons/pmIeSRMytIHhy35_v4sIvtX1pLsnwwWj Overview:  Public Health is the Health and Medical Lead for

Overview:  Public Health is the Health and Medical Lead for coordination ESF-8 functions in a jurisdiction. This includes mass fatality incidents. Review the Unit 8 Emergency Support Function 8 (ESF-8) Scenario and responses from the Unit 7 Assessment.   Instructions:  Provide detailed responses to the following questions based on the

Identifying a static balance between security and liberty fails to consider that the threat environment drives the public’s tolerance for one over the

Identifying a static balance between security and liberty fails to consider that the threat environment drives the public’s tolerance for one over the other. In responding to a crisis, the government will amass greater power as seen with the Patriot Act and those powers will be curtailed as the threat

What substantive theory have you chosen to help you answer your research question? Please take this opportunity to practice discussing your theory in detail by explaining why you think it’s a good fit for the research project, the level of analysis it operates at, and the variables it acknowledges — including

Describe how the Christian Identity movement twists one of the world’s major religions into a right-wing tool of extremism. Provide a specific example of

Describe how the Christian Identity movement twists one of the world’s major religions into a right-wing tool of extremism. Provide a specific example of how radicals use the Bible as justification for their theology of hate (such as the 2 seeds doctrine). Also describe at least one example of a

Overview Many project managers employ an earned value system to monitor their projects. In Project Management: The Managerial Process, Larson and Gray

Overview Many project managers employ an earned value system to monitor their projects. In Project Management: The Managerial Process, Larson and Gray (2017) define the earned value of a project as “the percent complete times its original budget. Stated differently, EV is the percent of the original budget that has

Unit 3 Research for Strategic Development Assignment v1.0 13/02/23 For: ATHE Level 7 Diploma in Strategic Management ATHE Level 7 Extended Diploma in

Unit 3 Research for Strategic Development Assignment v1.0 13/02/23 For: ATHE Level 7 Diploma in Strategic Management ATHE Level 7 Extended Diploma in Strategic Management Unit 3 Research for Strategic Development Assignment Assignment Scenario Your research must be related to a topic associated with strategic business development. To achieve the

Unit 3 Research for Strategic Development Assignment v1.0 13/02/23 For: ATHE Level 7 Diploma in Strategic Management ATHE Level 7 Extended Diploma in

Unit 3 Research for Strategic Development Assignment v1.0 13/02/23 For: ATHE Level 7 Diploma in Strategic Management ATHE Level 7 Extended Diploma in Strategic Management Unit 3 Research for Strategic Development Assignment Assignment Scenario Your research must be related to a topic associated with strategic business development. To achieve the

1) Create an introduction and detailed outline of your research topic paper( the topic should be any topic related to reverse logistics). List at least

1) Create an introduction and detailed outline of your research topic paper( the topic should be any topic related to reverse logistics). List at least four references, using library articles. The This outline can follow the following format as far as section headings. You can add more sections. But there

Overview As part of the contingency planning for your organization’s exit strategy, you have researched and analyzed a potential alternative buyer. As the

Overview As part of the contingency planning for your organization’s exit strategy, you have researched and analyzed a potential alternative buyer. As the possibility increases that the original buyer will withdraw from the deal, your VP has asked you to create a short investor pitch to help convince the alternative

An action plan is a written strategy used to achieve outlined goals. For the purposes of this assignment, you will create an action plan. An action plan

An action plan is a written strategy used to achieve outlined goals. For the purposes of this assignment, you will create an action plan. An action plan should include the steps needed to accomplish a goal. Include the components listed below in your essay. The goal for this action plan

Financial Analysis Project Length: 5-6 pages Description: Evaluate a sample budget from a long-term care facility. Identify areas for improvement and

Financial Analysis Project  Length: 5-6 pages Description: Evaluate a sample budget from a long-term care facility. Identify areas for improvement and propose financial strategies. Criteria: Accuracy of financial analysis, practicality of recommendations, clarity of presentation.

Overview:  Review the Emergency Support Function 8 (ESF-8) Scenario. You will watch and listen as a mass fatality incident unfolds. You represent Emergency

Overview:  Review the Emergency Support Function 8 (ESF-8) Scenario. You will watch and listen as a mass fatality incident unfolds. You represent Emergency Support Function 8 (ESF8) and will need your mass fatality plan (see written web resources) as a resource to assist you.  / Instructions:  As you move through

Overview In your role as a business development manager involved in preparing an exit strategy for the life science organization, you learned that employee

Overview In your role as a business development manager involved in preparing an exit strategy for the life science organization, you learned that employee attrition is one of the key risks to the proposed acquisition. In Milestone Two, you analyzed the employee data to evaluate this attrition risk and suggest

Using the CDC Shelter Assessment Tool listed below, list at least three of the assessments in sections III-XII that you find most critical for operating a

Using the CDC Shelter Assessment Tool listed below, list at least three of the assessments in sections III-XII that you find most critical for operating a safe and healthy shelter. Describe why you picked these three assessments.   Centers for Disease Control and Prevention. (n.d.). Environmental health assessment form for shelters.

Overview For the final project in the course (in five weeks), you will analyze the case study Value-Driven Project and Portfolio Management in the

Overview For the final project in the course (in five weeks), you will analyze the case study Value-Driven Project and Portfolio Management in the Pharmaceutical Industry and additional course resources to create a program performance report for a hypothetical organization. The completion of this assessment will allow you to demonstrate your knowledge