Your CEO has tasked you with doing some research about data and and how to work with data. The reading and activities this week introduce data topics and explain how Microsoft Excel can help analyze the data. Your task is to create a Microsoft Excel file (workbook) and use the following Microsoft Excel skills

• Open sample data file, rename, and save.
• Create formulas for the data.
• Format cells, fonts, shading, and use bold and cell formats.
• Insert a pie chart and add a title.
• Filter and sort data.

First, download the BIAM110 Week 2 data file provided above. Next, save your workbook asWeek2_Lab_YourLastName_YourFirstName.xlsx.

The data contains the following columns.

• Units A, B, and C
• Months

• 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 month labels and the units.
• In Column E 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.

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?

• 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 screen print of your sort results. Paste the screen print into your MS Word document.
• Click undo or clear filter at the bottom. Sort the month column by JAN. Select all to turn check marks off and put a check mark in JAN. Take a screenprint of your sort results and paste it into your MS Word document.
• Click undo or uncheck JAN and select DEC and sort the month column by DEC. Take a screen print of the sort results and paste it into your MS Word document.
• 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.
• Open your MS Word document with the sorting and filtering screen prints.
• Below the screen prints,tell a brief story about what you noticed about the data. Summarize what the data tells you in terms of which units sell more and what months are the highest sales.