First, open the workbook you downloaded from Step 1. Next, save your workbook as Week2_Lab_YourLastName_YourFirstName.xlsx. The data contains the following columns. Units A, B, and CMonthsYearsStep 3:

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

The data contains the following columns.

Units A, B, and C
Months
Years

Step 3: Create Format and Formulas

Format the data for currency where needed.
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.
Add shading for the labels.
In Column F under total costs, use the sum function to total all three units.
Add totals at the bottom of the data for all columns, using the sum function.
Add the average to each column by adding the function for average.
Screenshot or copy your file in a Microsoft Word document under a label that says Step 3.
Save both files.

Step 4: Sort and Filter

Select the data except for the total and the average.
Click the filter (funnel) on the data tab. You will see small drop-down arrows on all columns.
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.
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.
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.
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.
Save both files.

Step 5: Charting

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.
Label and format the chart to make it look professional.
Screenshot or copy your file in a Microsoft Word document under a label that says Step 5.
Under the screenshot in the document, please summarize what you can see in this chart within 50 to 100 words.
Save both files.

Step 6: Reflection

Open your MS Word document with the sorting and filtering screen prints.
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.

Share This Post

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

Related Questions

MBA 687 Module Five Report Guidelines and RubricOverview The leadership of the Singaporean-headquartered software solutions organization is concerned about issues arising from communication and coordi

MBA 687 Module Five Report Guidelines and RubricOverview The leadership of the Singaporean-headquartered software solutions organization is concerned about issues arising from communication and coordination challenges between employees at the U.S. branch and the Singaporean headquarters. The VP of the U.S. branch tasks you, as an HR consultant, with developing

HIM 500 Guidelines and RubricOverview You will submit an analysis of how the company in the case study is noncompliant and the strategies (general, not specifics) to move it toward compliance. Speci

HIM 500 Guidelines and RubricOverview You will submit an analysis of how the company in the case study is noncompliant and the strategies (general, not specifics) to move it toward compliance. Specifically the following critical elements must be addressed: Health Regulations and Laws Ramifications: In this section of your final

Home county USA Japan is chosen country 2 pages Describe at least two management positions that will require training for in-country positions. The description must include the identification of cultu

Home county USA Japan is chosen country 2 pages Describe at least two management positions that will require training for in-country positions. The description must include the identification of cultural, linguistics and specialized skills needed for the positions. Culturally, describe differences, such as management styles between the workforce in the

Reflect on what you have learned in this unit and explain various paths for repatriating employees of a corporation to the United States, and focus on how to best use the talents and experience gained

Reflect on what you have learned in this unit and explain various paths for repatriating employees of a corporation to the United States, and focus on how to best use the talents and experience gained by the employees during their posting overseas. Be sure to address the differences between retirees,

MBA 687 Module Four Presentation Guidelines and RubricOverview In Milestone One, as an HR consultant, you submitted a change readiness report. While you were performing your change readiness assessmen

MBA 687 Module Four Presentation Guidelines and RubricOverview In Milestone One, as an HR consultant, you submitted a change readiness report. While you were performing your change readiness assessment, five employees from the U.S. call center quit as a group, along with the well-liked team lead. Top management is very

ETHICAL LEADERSHIP-C206 TASK ONE Introduction Leadership is often defined as the ability to influence people. An effective ethical leader guides an organization and its employees to accomplish org

ETHICAL LEADERSHIP-C206 TASK ONE Introduction Leadership is often defined as the ability to influence people. An effective ethical leader guides an organization and its employees to accomplish organizational goals. In the same vein, an unethical leader can guide an organization and its employees to act unethically, harming both the organization

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist adopting new tools. This resistance stems from

Module 4 – CaseManaging ChangeAssignment OverviewChange Management Rapid technology changes in workplaces can cause stress, prompting employees to resist adopting new tools. This resistance stems from fear of obsolescence, disrupted routines, and perceived tool complexity. Addressing these anxieties through effective communication and training is crucial for smooth technological transitions. **Complete

HIM 500 Rubric Overview Imagine you have been contracted to consult on the recent developments at the Featherfall Medical Center. Featherfall has been struggling of late; it has had a series of proble

HIM 500 Rubric Overview Imagine you have been contracted to consult on the recent developments at the Featherfall Medical Center. Featherfall has been struggling of late; it has had a series of problems that have prompted your hiring. It has faced the following issues: Featherfall has recently violated several government

MBA 687 Guidelines and Rubric Scenario You have been contracted as an HR consultant by a U.S. LLC in Wilmington, Delaware, to solve their internal issues. This U.S. LLC is a branch of a Singaporean s

MBA 687 Guidelines and Rubric Scenario You have been contracted as an HR consultant by a U.S. LLC in Wilmington, Delaware, to solve their internal issues. This U.S. LLC is a branch of a Singaporean software solutions provider with 140 employees and $20M revenue per year. The CEO of the

MBA 645 Guidelines and Rubric Overview You are the regional marketing director of a theme park in the southeastern United States that is part of a global brand. The chief marketing officer (CMO) of g

MBA 645 Guidelines and Rubric Overview You are the regional marketing director of a theme park in the southeastern United States that is part of a global brand. The chief marketing officer (CMO) of global operations has called upon you to help coordinate the marketing tasks related to rolling out

Purpose: This assignment is designed to help you create connections between the course material we have learned throughout Modules 2-4. Specifically, using an adaptive leadership approach, you will

Purpose: This assignment is designed to help you create connections between the course material we have learned throughout Modules 2-4. Specifically, using an adaptive leadership approach, you will pick an adaptive challenge that you want to/already are working on. You will then demonstrate your understanding of the course material by

Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking about an ethic

Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking about an ethical dilemma in one of your systems. You will apply Kidder’s nine checkpoints to the ethical dilemma of your choosing

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typicall

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they

Part I: Choose two American international companies. The selection must be an intercultural organizations doing business in at least one foreign country. Not Cuba, North Korea, etc… In your submi

Part I: Choose two American international companies. The selection must be an intercultural organizations doing business in at least one foreign country. Not Cuba, North Korea, etc… In your submission, provide a review and arguments for and against each of the two organizations. In the conclusion of your submission, recommend which

MBA 645 Module Two Communication Plan Guidelines and RubricOverview Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typicall

MBA 687 Module Two Memo Guidelines and RubricScenario As the HR consultant contracted to resolve issues related to miscommunication and workforce discontent at the U.S. branch of the Singaporean softw

MBA 687 Module Two Memo Guidelines and RubricScenario As the HR consultant contracted to resolve issues related to miscommunication and workforce discontent at the U.S. branch of the Singaporean software solutions provider, you are expected to present a change readiness report and then submit a change management plan. You have

Purpose: Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking abo

Purpose: Now that you understand the importance of recognizing ethical dilemmas when doing the work of leadership, and how essential it is to separate them from moral temptations, start thinking about an ethical dilemma in one of your systems. You will apply Kidder’s nine checkpoints to the ethical dilemma of your

VAL- UP TO 6/6/2025- *** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED* **** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHE

VAL- UP TO 6/6/2025- ***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI IT WILL BE SCANNED***** ****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** PART 1- Module 1- DISCUSSION- (VAL)- HRM (HUMAN RESOURCES MANAGEMENT) Opinion Research two