Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create a new column in the Purchase_Orders_Range for PO Amount, and copy it down the column (keep in mind that the columns are in a different order than they were in the first dataset). 2. Create a new column in the Purchase _Orders_Table for PO Amount, and ensure it copies down automatically Ask the Question: What is the best format to work with the data? Master the Data: The 4-1 Alt Data is purchasing data rather than sales, so instead of working with Sales_Order_Quantity_Sold, you will work with Quantity_Purchased, and instead of working with Products, you will work with Raw_Materials. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 4-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 4-1 Alternate in the text for instructions and Lab 4-1 steps for each the of lab parts. Share the Story: You have now worked with data in Excel in Ranges and in Tables and learned how Excel interacts differently with data depending on the format in which it is stored. Part 1: Upload Your Files Part 2: Assessment 19 Required: 1. How many transactions have Supplier_ID 3 on them? O 18 0 1 07 O 98 2. One of the benefits of a table format is O it is the default format once you enter data into Excel. O it automatically creates grand totals at the end of each column. O it automatically provides an absolute reference for formulas you enter manually. O it defaults to providing a filter button for each column. 3. What is the sum of the Purchase Order_Amount column? O 344 O 10,358 O 1,568 O 54 4. What is the sum of the Raw_Material_Purchase_Price column for only Supplier_ID 1? O 579.87 O 116 O 1,567.65 0 54 5. What is the average of the Purchase Order_Amount column? 3,722.26 199.19 206.79 O 10,357.76