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

I need Single Power Point Slide that looks like a large poster – My topic is The Security Challenges/threat vectors associated with Port Security It is a single PowerPoint slide that depicts a resear

I need Single Power Point Slide that looks like a large poster – My topic is The Security Challenges/threat vectors associated with Port Security  It is a single PowerPoint slide that depicts a research question, hypothesis, Introduction/background, Literature Review Summary, Methodology (i.e., Content Analysis/Historical Perspective/ thematic Analysis, etc.), your analysis,

DISCUSSION Question: You are a business executive responsible for expanding your company into a new international market. What key factors would influence your decision-making process regarding marke

DISCUSSION Question:  You are a business executive responsible for expanding your company into a new international market. What key factors would influence your decision-making process regarding market entry strategy, organizational structure, and policy compliance? How would you balance standardization with local adaptation? In your response to your peers, explore the

️ A MESSAGE TO ACADEMIC WRITERS Many writers today are frustrated by platforms with poor support, delayed payments, limited communication, unfair commission structures, and sudden account restrictions

️ A MESSAGE TO ACADEMIC WRITERS Many writers today are frustrated by platforms with poor support, delayed payments, limited communication, unfair commission structures, and sudden account restrictions that affect their earnings and growth. That’s why we built StudyAce.net — a modern academic marketplace designed to support writers, protect their earnings,

WEEK 5 TO DO DISCUSSSION Question: Imagine your company is expanding into a new country with significantly different cultural norms and business ethics than your home country. What steps would you tak

WEEK 5 TO DO DISCUSSSION Question: Imagine your company is expanding into a new country with significantly different cultural norms and business ethics than your home country. What steps would you take to ensure your business respects the local culture and ethical expectations while maintaining your company’s core values?” To earn

WEEK 3 TO DO Questions: Tesla’s Entry into China When Tesla entered the Chinese market, it faced institutional barriers such as strict government regulations on foreign automakers and resource-based

WEEK 3 TO DO Questions: Tesla’s Entry into China When Tesla entered the Chinese market, it faced institutional barriers such as strict government regulations on foreign automakers and resource-based challenges like supply chain localization. However, Tesla mitigated its liability of foreignness by: ·       Partnering with local suppliers to establish a Gigafactory

WEEK 4 TO DO Question: Global Integration and the Auto Industry Scenario: Japan’s Toyota and Germany’s Volkswagen expand production in the United States, creating thousands of jobs while introducing

WEEK 4 TO DO Question: Global Integration and the Auto Industry Scenario: Japan’s Toyota and Germany’s Volkswagen expand production in the United States, creating thousands of jobs while introducing new technologies and efficient manufacturing practices. The U.S. benefits from increased employment, while Toyota and Volkswagen gain access to a large consumer

WEEK 2 TO DO Question: A global technology company based in Atlantis has been heavily reliant on imports of raw materials and components from foreign suppliers. However, the government has recently im

WEEK 2 TO DO Question: A global technology company based in Atlantis has been heavily reliant on imports of raw materials and components from foreign suppliers. However, the government has recently imposed higher tariffs and stricter import quotas to protect local manufacturers. While this policy aims to boost domestic production,

WEEK 1 TO DO Question: A U.S.-based technology company is expanding its operations into multiple international markets, including China, Brazil, and the European Union. However, the company faces

WEEK 1 TO DO Question:  A U.S.-based technology company is expanding its operations into multiple international markets, including China, Brazil, and the European Union. However, the company faces several challenges: In China, strict data localization laws and government regulations create barriers to digital operations. In Brazil, unpredictable regulatory changes and

Forecasting and Capacity Management Using AI Select a company (real or hypothetical) in an industry where forecasting and capacity planning are critical (e.g., retail, manufacturing, health care, airl

Forecasting and Capacity Management Using AI Select a company (real or hypothetical) in an industry where forecasting and capacity planning are critical (e.g., retail, manufacturing, health care, airlines, or logistics). Define the company’s long-range (2–5 years) planning objectives. Use an AI tool (e.g., ChatGPT, Perplexity, Gemini, CoPilot, etc.) to generate demand forecasts

Week 4 Writing Assignment After reading the Week 4 material, we know that change in the fire service is inevitable. Without change, people and organizations would become stale and unresponsive. Th

Week 4 Writing Assignment After reading the Week 4 material, we know that change in the fire service is inevitable.  Without change, people and organizations would become stale and unresponsive.  The challenge is to learn how to steer through the transition as easily and creatively as possible.  To successfully navigate the

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