Question: 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

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. The following is the necessary information to complete this lab assignment. Deliverables The deliverable for this lab is a Microsoft Excel Workbook, including Steps 16 results and a Microsoft Word document. Required Software This lab will use the following Lab Resources. Virtual Lab Citrix (MS Excel 2016 or 2019 & MS Word 2016 or 2019) Use a personal copy of the software or access the Lab Resources (Citrix) located in the Course Resources page. Step 1: Lab Preparation Resources for this lab are located in Citrix or on your personal computer, using Microsoft Excel. There are 27 videos located in spreadsheets, reading, and resources. Use these videos to learn about the spreadsheet skills you will need for the CEO. The spreadsheet you will be working with is BIAM110_Week2_Data.xlsx. Please review the videos that you need to complete the different steps below

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!