Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

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

  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.
  3. Add shading for the labels.
  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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Order Now

Related Questions

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To

DISCUSSION Most managers believe that while it is possible to connect logistics decisions to costs, the connection to revenue enhancement is difficult to impossible. Do you agree or disagree? Why? To earn full credit, post an initial response of 500 words that includes at least one APA citation and the

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, o

week 4 DISCUSSION “In today’s competitive business environment, effective logistics management is essential to maintaining operational efficiency and customer satisfaction. How do demand management, order management, customer service, inventory management, and facilities location interact to influence a company’s overall logistics performance?  Can you identify a real-world example where optimizing one

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Pa

WEEK 5 TO DO DISCUSSION The purpose of the discussion question is to allow you to demonstrate your understanding of the unit’s key learning points and how you might apply them in a given situation. Participating in the discussion question forum provides you with an opportunity to compare your ideas

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain

DISCUSSION Discuss whether corporate cultures are relevant to supply chain management. In your post, ensure to give concrete examples (you may use Starbucks as your example and assess its supply chain or you may use another company as an example). To earn full credit, post an initial response of 500

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of

Week 1 to do DISCUSSION Explain how technological advances have contributed to the increased importance of logistics. In your post, ensure to include at least two solid examples showing the impact of technology on your experience as a consumer.  To earn full credit, post an initial response of 500 words

Pick and clearly describe (in about a paragraph) a situation (preferably but not necessarily in business) that requires a decision necessitating a decision tree with at least two branches, each branch

Pick and clearly describe (in about a paragraph) a situation (preferably but not necessarily in business) that requires a decision necessitating a decision tree with at least two branches, each branch having at least two sub-branches. In another paragraph explain and justify the structure of the decision tree you are

Socio-Cultural Considerations Choose a city in another country (outside the United States). Research tourism in that country, and answer the following questions: Give a small synopsis on the history a

Socio-Cultural Considerations Choose a city in another country (outside the United States). Research tourism in that country, and answer the following questions: Give a small synopsis on the history and demographics of the country. What are the socio-cultural considerations for that country? What is the current climate of tourism in

Unit Outcomes: Describe occupational safety and health regulatory organizations such as OSHA.Describe the function and oversight of occupational safety and health organizations.BI100-5: Describe emplo

Unit Outcomes: Describe occupational safety and health regulatory organizations such as OSHA. Describe the function and oversight of occupational safety and health organizations. BI100-5: Describe employer role in addressing safety in the workplace. Purpose For this assignment, you will use the Reflection Template to provide a reflection on what the readings, learning activities,

Unit 9 Assignment: Addressing Workplace Safety ConcernsOutcomes addressed in this activity: Unit Outcomes: Apply lean safety measures to promote safety.Describe the employer’s role in addressing safet

Unit 9 Assignment: Addressing Workplace Safety ConcernsOutcomes addressed in this activity: Unit Outcomes: Apply lean safety measures to promote safety. Describe the employer’s role in addressing safety concerns in the workplace. Present the safety recommendations to address a safety concern. Use appropriate APA formatting and citations in scholarly writing. BI100-5: Describe

****** THIS ASSIGNMENT HAS 6 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** HUMANITIES COURSE **** PART 1- Module 6 – DISCUSSION A Comparable Development Pr

****** THIS ASSIGNMENT HAS 6 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** HUMANITIES COURSE **** PART 1- Module 6 – DISCUSSION A Comparable Development  Prompt: Pick one of the developments mentioned in The Renaissance or one of the developments mentioned in The Enlightenment. Then think of

Module 3 – SLPHarnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting

Module 3 – SLPHarnessing the Power of Operations and FinanceAssignment Overview Accounting and Finance Strategies We will address organizational performance from a money perspective. How do accounting and finance functions support a company’s goals and help it move forward according to plan? SLP 3 Resources Contribute to an Ethical Culture (2022) DEI

Module 3 – CaseHarnessing the Power of Operations and FinanceAssignment Overview Strategic Management As your final written case of class, it is time to complete all of the connections regarding how

Module 3 – CaseHarnessing the Power of Operations and FinanceAssignment Overview Strategic Management  As your final written case of class, it is time to complete all of the connections regarding how strategy is implemented in an organization and the roles of the stakeholders across functional areas. Case 3 Resources Corporate-Level

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles.Choose. Choose one WSJ article from the Business, Tech, or Markets section to summar

Wall Street Journal Article Analysis: You will be required to read and summarize Wall Street Journal (WSJ) articles. Choose. Choose one WSJ article from the Business, Tech, or Markets section to summarize. Insert the link to the article, before writing your analysis.  Write.  Write one paragraph on 1) What is the article about, 2)