Excel File Lab 4 1 Data xlsx Sales Transactions Range Sales Order Date Sales Employee ID Customer ID Product Code Sales Order Quantity Sold Product Sale Price 11 22 2019 1007 2001 2004 12 105 12 27 2019 1007 2001 2005 8 85 3 4 2020 1007 2001 2004 5 105 4 28 2020 1007 2001 2002 6 120 12 20 2019 1006 2002 2001 5 95 2 11 2020 1007 2002 2004 2 105 2 11 2020 1006 2004 2004 8 105 2 11 2020 1006 2004 2003 11 100 11 2 2019 1006 2005 2004 3 105 1 16 2020 1006 2006 2003 7 100 12 25 2019 1006 2007 2003 3 100 1 13 2020 1006 2007 2001 1 95 1 7 2020 1007 2008 2005 8 85 2 4 2020 1007 2008 2005 7 85 3 24 2020 1006 2008 2006 9 90 3 24 2020 1006 2008 2002 2 120 11 4 2019 1006 2009 2005 1 85 4 8 2020 1006 2009 2005 6 85 4 8 2020 1006 2009 2004 2 105 4 19 2020 1007 2009 2004 6 105 1 22 2020 1006 2010 2005 5 85 1 22 2020 1007 2010 2004 11 105 11 1 2019 1006 2011 2006 8 90 1 19 2020 1007 2011 2004 2 105 1 22 2020 1007 2011 2005 10 85 11 1 2019 1006 2012 2006 9 90 11 1 2019 1006 2012 2001 8 95 12 1 2019 1006 2012 2002 10 120 11 12 2019 1007 2013 2003 1 100 1 10 2020 1007 2013 2006 12 90 1 10 2020 1007 2013 2005 12 85 2 22 2020 1006 2013 2005 6 85 3 7 2020 1007 2013 2003 9 100 12 4 2019 1007 2014 2003 9 100 3 14 2020 1006 2016 2006 12 90 4 20 2020 1006 2016 2003 3 100 1 29 2020 1006 2017 2006 1 90 3 10 2020 1007 2017 2005 4 85 12 25 2019 1007 2019 2006 12 90 1 14 2020 1006 2019 2001 9 95 3 3 2020 1006 2020 2001 12 95 11 21 2019 1006 2021 2003 8 100 11 29 2019 1007 2021 2001 11 95 2 10 2020 1007 2021 2005 3 85 2 10 2020 1007 2021 2001 4 95 2 10 2020 1007 2021 2004 6 105 2 12 2020 1006 2021 2003 4 100 11 12 2019 1006 2022 2002 4 120 1 13 2020 1006 2022 2001 1 95 1 15 2020 1006 2022 2002 6 120 1 27 2020 1006 2022 2004 5 105 3 25 2020 1007 2022 2004 4 105 3 25 2020 1006 2022 2003 1 100 1 27 2020 1006 2023 2004 1 105 3 9 2020 1006 2024 2003 1 100 3 9 2020 1006 2024 2006 3 90 3 29 2020 1007 2025 2003 6 100 4 13 2020 1007 2025 2001 10 95 1 12 2020 1007 2026 2004 4 105 2 11 2020 1007 2027 2004 9 105 2 11 2020 1007 2027 2005 9 85 1 14 2020 1006 2028 2001 2 95 3 18 2020 1007 2028 2006 4 90 3 2 2020 1007 2029 2006 11 90 3 28 2020 1006 2029 2004 8 105 12 12 2019 1006 2031 2005 10 85 4 8 2020 1006 2031 2004 5 105 11 7 2019 1006 2032 2003 6 100 11 8 2019 1007 2033 2004 11 105 11 22 2019 1006 2034 2003 4 100 1 1 2020 1006 2034 2002 10 120 1 1 2020 1006 2034 2001 7 95 1 24 2020 1006 2034 2004 5 105 11 20 2019 1006 2035 2004 2 105 11 30 2019 1006 2035 2005 11 85 1 8 2020 1006 2035 2005 7 85 12 30 2019 1006 2036 2004 6 105 3 25 2020 1007 2036 2006 3 90 4 8 2020 1007 2036 2005 4 85 11 14 2019 1007 2037 2003 2 100 12 4 2019 1007 2037 2003 4 100 1 31 2020 1007 2037 2006 4 90 2 17 2020 1007 2037 2006 11 90 3 4 2020 1007 2037 2003 10 100 11 4 2019 1007 2038 2003 2 100 11 4 2019 1007 2038 2002 4 120 12 1 2019 1007 2038 2005 10 85 11 20 2019 1007 2039 2004 11 105 3 19 2020 1007 2039 2001 3 95 4 13 2020 1006 2039 2002 11 120 1 30 2020 1006 2040 2006 4 90 1 30 2020 1006 2040 2001 7 95 3 3 2020 1007 2040 2001 7 95 3 9 2020 1006 2040 2004 4 105 3 13 2020 1006 2040 2003 2 100 12 19 2019 1007 2041 2006 4 90 12 20 2019 1007 2042 2004 9 105 4 25 2020 1007 2042 2004 11 105 11 7 2019 1006 2043 2001 1 95 11 16 2019 1006 2043 2005 12 85 1 7 2020 1007 2043 2003 12 100 1 7 2020 1007 2043 2004 10 105 3 26 2020 1006 2043 2001 10 95 3 27 2020 1007 2043 2004 2 105 4 21 2020 1007 2043 2003 1 100 3 10 2020 1006 2044 2004 9 105 3 10 2020 1006 2044 2006 12 90 2 27 2020 1006 2045 2005 8 85 4 19 2020 1007 2045 2003 6 100 2 13 2020 1007 2046 2004 2 105 3 24 2020 1007 2046 2003 9 100 2 29 2020 1007 2047 2003 11 100 12 7 2019 1006 2048 2004 1 105 12 16 2019 1006 2048 2004 6 105 12 16 2019 1006 2048 2005 9 85 1 12 2020 1007 2048 2003 11 100 12 22 2019 1007 2049 2004 8 105 4 14 2020 1007 2049 2001 8 95 1 31 2020 1006 2050 2002 7 120 2 1 2020 1007 2050 2003 2 100 3 16 2020 1006 2050 2004 10 105 3 27 2020 1006 2050 2003 6 100 1 26 2020 1007 2051 2005 12 85 11 8 2019 1007 2052 2005 2 85 11 24 2019 1007 2052 2004 9 105 1 22 2020 1006 2053 2004 8 105 4 19 2020 1006 2053 2004 10 105 11 13 2019 1007 2054 2004 3 105 11 13 2019 1007 2054 2005 3 85 11 1 2019 1006 2056 2001 10 95 12 18 2019 1006 2056 2003 10 100 12 23 2019 1006 2056 2003 8 100 3 19 2020 1007 2056 2003 1 100 1 25 2020 1006 2057 2003 6 100 4 8 2020 1006 2057 2003 10 100 12 2 2019 1007 2058 2002 1 120 2 15 2020 1006 2058 2003 7 100 12 15 2019 1007 2059 2004 11 105 11 22 2019 1006 2060 2005 6 85 12 5 2019 1006 2060 2003 7 100 1 28 2020 1007 2060 2005 11 85 4 7 2020 1006 2060 2003 3 100 4 17 2020 1007 2060 2003 11 100 1 6 2020 1007 2061 2004 12 105 1 19 2020 1006 2061 2004 3 105 3 26 2020 1007 2061 2003 11 100 3 19 2020 1007 2062 2003 10 100 4 10 2020 1006 2062 2005 6 85 4 10 2020 1006 2062 2004 2 105 Sales Transactions Table Sales Order ID Sales Order Date Sales Employee ID Customer ID Product Code Sales Order Quantity Sold Product Sale Price 20062 11 22 2019 1007 2001 2004 12 105 20168 12 27 2019 1007 2001 2005 8 85 20383 3 4 2020 1007 2001 2004 5 105 20564 4 28 2020 1007 2001 2002 6 120 20140 12 20 2019 1006 2002 2001 5 95 20310 2 11 2020 1007 2002 2004 2 105 20308 2 11 2020 1006 2004 2004 8 105 20308 2 11 2020 1006 2004 2003 11 100 20009 11 2 2019 1006 2005 2004 3 105 20233 1 16 2020 1006 2006 2003 7 100 20163 12 25 2019 1006 2007 2003 3 100 20224 1 13 2020 1006 2007 2001 1 95 20199 1 7 2020 1007 2008 2005 8 85 20291 2 4 2020 1007 2008 2005 7 85 20451 3 24 2020 1006 2008 2006 9 90 20451 3 24 2020 1006 2008 2002 2 120 20012 11 4 2019 1006 2009 2005 1 85 20494 4 8 2020 1006 2009 2005 6 85 20494 4 8 2020 1006 2009 2004 2 105 20537 4 19 2020 1007 2009 2004 6 105 20250 1 22 2020 1006 2010 2005 5 85 20251 1 22 2020 1007 2010 2004 11 105 20003 11 1 2019 1006 2011 2006 8 90 20241 1 19 2020 1007 2011 2004 2 105 20253 1 22 2020 1007 2011 2005 10 85 20005 11 1 2019 1006 2012 2006 9 90 20005 11 1 2019 1006 2012 2001 8 95 20090 12 1 2019 1006 2012 2002 10 120 20033 11 12 2019 1007 2013 2003 1 100 20211 1 10 2020 1007 2013 2006 12 90 20211 1 10 2020 1007 2013 2005 12 85 20338 2 22 2020 1006 2013 2005 6 85 20393 3 7 2020 1007 2013 2003 9 100 20097 12 4 2019 1007 2014 2003 9 100 20418 3 14 2020 1006 2016 2006 12 90 20543 4 20 2020 1006 2016 2003 3 100 20277 1 29 2020 1006 2017 2006 1 90 20406 3 10 2020 1007 2017 2005 4 85 20161 12 25 2019 1007 2019 2006 12 90 20229 1 14 2020 1006 2019 2001 9 95 20379 3 3 2020 1006 2020 2001 12 95 20056 11 21 2019 1006 2021 2003 8 100 20080 11 29 2019 1007 2021 2001 11 95 20305 2 10 2020 1007 2021 2005 3 85 20305 2 10 2020 1007 2021 2001 4 95 20305 2 10 2020 1007 2021 2004 6 105 20312 2 12 2020 1006 2021 2003 4 100 20031 11 12 2019 1006 2022 2002 4 120 20223 1 13 2020 1006 2022 2001 1 95 20230 1 15 2020 1006 2022 2002 6 120 20266 1 27 2020 1006 2022 2004 5 105 20452 3 25 2020 1007 2022 2004 4 105 20454 3 25 2020 1006 2022 2003 1 100 20265 1 27 2020 1006 2023 2004 1 105 20404 3 9 2020 1006 2024 2003 1 100 20404 3 9 2020 1006 2024 2006 3 90 20471 3 29 2020 1007 2025 2003 6 100 20513 4 13 2020 1007 2025 2001 10 95 20218 1 12 2020 1007 2026 2004 4 105 20307 2 11 2020 1007 2027 2004 9 105 20307 2 11 2020 1007 2027 2005 9 85 20227 1 14 2020 1006 2028 2001 2 95 20438 3 18 2020 1007 2028 2006 4 90 20375 3 2 2020 1007 2029 2006 11 90 20465 3 28 2020 1006 2029 2004 8 105 20120 12 12 2019 1006 2031 2005 10 85 20496 4 8 2020 1006 2031 2004 5 105 20020 11 7 2019 1006 2032 2003 6 100 20024 11 8 2019 1007 2033 2004 11 105 20063 11 22 2019 1006 2034 2003 4 100 20183 1 1 2020 1006 2034 2002 10 120 20183 1 1 2020 1006 2034 2001 7 95 20256 1 24 2020 1006 2034 2004 5 105 20053 11 20 2019 1006 2035 2004 2 105 20086 11 30 2019 1006 2035 2005 11 85 20202 1 8 2020 1006 2035 2005 7 85 20179 12 30 2019 1006 2036 2004 6 105 20453 3 25 2020 1007 2036 2006 3 90 20495 4 8 2020 1007 2036 2005 4 85 20040 11 14 2019 1007 2037 2003 2 100 20098 12 4 2019 1007 2037 2003 4 100 20283 1 31 2020 1007 2037 2006 4 90 20328 2 17 2020 1007 2037 2006 11 90 20384 3 4 2020 1007 2037 2003 10 100 20013 11 4 2019 1007 2038 2003 2 100 20013 11 4 2019 1007 2038 2002 4 120 20089 12 1 2019 1007 2038 2005 10 85 20055 11 20 2019 1007 2039 2004 11 105 20440 3 19 2020 1007 2039 2001 3 95 20516 4 13 2020 1006 2039 2002 11 120 20280 1 30 2020 1006 2040 2006 4 90 20280 1 30 2020 1006 2040 2001 7 95 20378 3 3 2020 1007 2040 2001 7 95 20403 3 9 2020 1006 2040 2004 4 105 20416 3 13 2020 1006 2040 2003 2 100 20138 12 19 2019 1007 2041 2006 4 90 20142 12 20 2019 1007 2042 2004 9 105 20559 4 25 2020 1007 2042 2004 11 105 20017 11 7 2019 1006 2043 2001 1 95 20043 11 16 2019 1006 2043 2005 12 85 20200 1 7 2020 1007 2043 2003 12 100 20200 1 7 2020 1007 2043 2004 10 105 20457 3 26 2020 1006 2043 2001 10 95 20461 3 27 2020 1007 2043 2004 2 105 20545 4 21 2020 1007 2043 2003 1 100 20407 3 10 2020 1006 2044 2004 9 105 20407 3 10 2020 1006 2044 2006 12 90 20357 2 27 2020 1006 2045 2005 8 85 20535 4 19 2020 1007 2045 2003 6 100 20314 2 13 2020 1007 2046 2004 2 105 20450 3 24 2020 1007 2046 2003 9 100 20368 2 29 2020 1007 2047 2003 11 100 20106 12 7 2019 1006 2048 2004 1 105 20126 12 16 2019 1006 2048 2004 6 105 20126 12 16 2019 1006 2048 2005 9 85 20217 1 12 2020 1007 2048 2003 11 100 20151 12 22 2019 1007 2049 2004 8 105 20518 4 14 2020 1007 2049 2001 8 95 20282 1 31 2020 1006 2050 2002 7 120 20285 2 1 2020 1007 2050 2003 2 100 20424 3 16 2020 1006 2050 2004 10 105 20460 3 27 2020 1006 2050 2003 6 100 20262 1 26 2020 1007 2051 2005 12 85 20023 11 8 2019 1007 2052 2005 2 85 20068 11 24 2019 1007 2052 2004 9 105 20249 1 22 2020 1006 2053 2004 8 105 20539 4 19 2020 1006 2053 2004 10 105 20037 11 13 2019 1007 2054 2004 3 105 20037 11 13 2019 1007 2054 2005 3 85 20001 11 1 2019 1006 2056 2001 10 95 20137 12 18 2019 1006 2056 2003 10 100 20155 12 23 2019 1006 2056 2003 8 100 20439 3 19 2020 1007 2056 2003 1 100 20261 1 25 2020 1006 2057 2003 6 100 20492 4 8 2020 1006 2057 2003 10 100 20093 12 2 2019 1007 2058 2002 1 120 20325 2 15 2020 1006 2058 2003 7 100 20124 12 15 2019 1007 2059 2004 11 105 20059 11 22 2019 1006 2060 2005 6 85 20103 12 5 2019 1006 2060 2003 7 100 20271 1 28 2020 1007 2060 2005 11 85 20491 4 7 2020 1006 2060 2003 3 100 20532 4 17 2020 1007 2060 2003 11 100 20192 1 6 2020 1007 2061 2004 12 105 20242 1 19 2020 1006 2061 2004 3 105 20458 3 26 2020 1007 2061 2003 11 100 20441 3 19 2020 1007 2062 2003 10 100 20503 4 10 2020 1006 2062 2005 6 85 20503 4 10 2020 1006 2062 2004 2 105 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 Explore how and why to work with data in range and table formats Ask the Question What is the best format to work with the data Master the Data The dataset contains information about sales transactions to different customers There are 132 unique transactions, but 149 rows this is because some of the transactions had multiple products on them This data is similar to the data used in several of the labs in Chapter 3 however, in Chapter 3, the data had already been transformed In this lab, we will work with only the data that belongs in the Sales Transactions table Software needed Excel Screen capture tool (Windows Snipping Tool Mac Cmd Shift 4) Data Excel File Lab 4 1 Data xIsx Perform the Analysis Refer to Lab 4 1 In the text for instructions and 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 Upload one Word or PDF document containing all of your screenshots for this Lab using the button below 1 Return to the Sales Transactions Range spreadsheet, and take a screenshot of the data Including the new column for Invoice Amount Label it Lab 4 1 Submission 1 2 Return to the Sales Transactions Table spreadsheet, and take a screenshot of the data including the new column for Invoice Amount Label it Lab 4 1 Submission 2 File Home Insert Page Layout Formulas Data Review View Add ins Help Comments Share X Cut AutoSum Calibri v 11 A A ab Wrap Text General AY O Paste A Copy Fill Analyze BIUT Y E $ 9 Conditional Format as Cell Insert Delete Format Sort Find Solver E Merge Center Formatting Table Styles Clear Format Painter Filter Select Data Font Alignment Number Styles Cells Editing Analysis Solver Clipboard K15 X v fx B C D E F G H K L M N O Sales Order Dateales Employee 10 Customer ID Product Code Order Quantity Product Sale Price 11 22 2019 1007 2001 2004 12 105 1 A W N 12 27 2019 1007 2001 2005 85 3 4 2020 1007 2001 2004 105 4 28 2020 1007 2001 2002 120 12 20 2019 1006 2002 2001 95 6 0O V O UT 2 11 2020 1007 2002 2004 2 105 2 11 2020 1006 2004 2004 8 105 2 11 2020 1006 2004 2003 11 100 10 11 2 2019 1006 2005 2004 105 11 1 16 2020 1006 2006 2003 100 12 12 25 2019 1006 2007 2003 100 13 1 13 2020 1006 2007 2001 95 14 1 7 2020 1007 2008 2005 85 15 2 4 2020 1007 2008 2005 85 16 3 24 2020 1006 2008 2006 U O N O H N D V OO H W V W 90 17 3 24 2020 1006 2008 2002 120 18 11 4 2019 1006 2009 2005 85 19 4 8 2020 1006 2009 2005 85 20 4 8 2020 1006 2009 2004 105 21 4 19 2020 1007 2009 2004 105 22 1 22 2020 1006 2010 2005 85 23 1 22 2020 1007 2004 11 105 24 11 1 2019 1006 2011 2006 8 90 25 1 19 2020 1007 2011 2004 105 26 1 22 2020 1007 2011 2005 10 35 27 11 1 2019 1006 2012 2006 9 90 28 11 1 2019 1006 2012 2001 8 95 29 12 1 2019 1006 2012 2002 10 120 Sales Transactions Range Sales Transactions Table ( ) 2 Accessibility Good to go 100 ReadyComments File Home Insert Page Layout Formulas Data Review View Add ins Help Share AutoSum X Cut Calibri v 11 AA ab Wrap Text General AY O Fill Copy Conditional Format as Cell Insert Delete Format Sort Find Analyze Solver Paste BIUMVA E Merge Center $ 9 08 28 Formatting Table Styles Clear Filter Select Data Format Painter Number Styles Cells Editing Analysis Solver Clipboard Font Alignment K15 X V F G H J K L M N O P Q R A B C D E Sales Order ID Sales Order Date ales Employer Customer Product C Order Quant Product Sale Pr 20062 11 22 2019 1007 2001 2004 12 105 20168 12 27 2019 1007 2001 2005 8 85 AWN 20383 3 4 2020 1007 2001 2004 5 105 20564 4 28 2020 1007 2001 2002 6 120 20140 12 20 2019 1006 2002 2001 5 95 20310 2 11 2020 1007 2002 2004 2 105 20308 2 11 2020 1006 2004 2004 8 105 20308 2 11 2020 1006 2004 2003 11 100 10 20009 11 2 2019 1006 2005 2004 3 105 11 20233 1 16 2020 1006 2006 2003 7 100 12 20163 12 25 2019 1006 2007 2003 100 PW 13 20224 1 13 2020 1006 2007 2001 95 14 20199 1 7 2020 1007 2008 2005 85 15 20291 2 4 2020 1007 2008 2005 85 16 20451 3 24 2020 1006 2008 2006 90 17 20451 3 24 2020 1006 2008 2002 120 18 20012 11 4 2019 1006 2009 2005 85 NOUN 19 20494 4 8 2020 1006 2009 2005 85 20 20494 4 8 2020 1006 2009 2004 105 21 20537 4 19 2020 1007 2009 2004 105 22 20250 1 22 2020 1006 2010 2005 5 35 23 20251 1 22 2020 1007 2010 2004 11 105 24 20003 11 1 2019 1006 2011 2006 8 90 25 20241 1 19 2020 1007 2011 2004 2 105 26 20253 1 22 2020 1007 2011 2005 10 85 27 20005 11 1 2019 1006 2012 2006 9 90 28 20005 11 1 2019 1006 2012 2001 8 95 29 20090 12 1 2019 1006 2012 2002 10 120 Sales Transactions Range Sales Transactions Table ( 100 Ready Accessibility Good to go

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Nov 15, 2024

Excel File Lab 4-1 Data.xlsx . Sales_Transactions_Range Sales_Order_Date Sales_Employee_ID Customer_ID Product_Code Sales_Order_Quantity_Sold Product_Sale_Price 11/22/2019 1007 2001 2004 12 105 12/27/2019 1007 2001 2005 8 85

Excel File Lab 4-1 Data.xlsx.

Sales_Transactions_Range

Sales_Order_Date	Sales_Employee_ID	Customer_ID	Product_Code	Sales_Order_Quantity_Sold	Product_Sale_Price
11/22/2019	1007	2001	2004	12	105
12/27/2019	1007	2001	2005	8	85
3/4/2020	1007	2001	2004	5	105
4/28/2020	1007	2001	2002	6	120
12/20/2019	1006	2002	2001	5	95
2/11/2020	1007	2002	2004	2	105
2/11/2020	1006	2004	2004	8	105
2/11/2020	1006	2004	2003	11	100
11/2/2019	1006	2005	2004	3	105
1/16/2020	1006	2006	2003	7	100
12/25/2019	1006	2007	2003	3	100
1/13/2020	1006	2007	2001	1	95
1/7/2020	1007	2008	2005	8	85
2/4/2020	1007	2008	2005	7	85
3/24/2020	1006	2008	2006	9	90
3/24/2020	1006	2008	2002	2	120
11/4/2019	1006	2009	2005	1	85
4/8/2020	1006	2009	2005	6	85
4/8/2020	1006	2009	2004	2	105
4/19/2020	1007	2009	2004	6	105
1/22/2020	1006	2010	2005	5	85
1/22/2020	1007	2010	2004	11	105
11/1/2019	1006	2011	2006	8	90
1/19/2020	1007	2011	2004	2	105
1/22/2020	1007	2011	2005	10	85
11/1/2019	1006	2012	2006	9	90
11/1/2019	1006	2012	2001	8	95
12/1/2019	1006	2012	2002	10	120
11/12/2019	1007	2013	2003	1	100
1/10/2020	1007	2013	2006	12	90
1/10/2020	1007	2013	2005	12	85
2/22/2020	1006	2013	2005	6	85
3/7/2020	1007	2013	2003	9	100
12/4/2019	1007	2014	2003	9	100
3/14/2020	1006	2016	2006	12	90
4/20/2020	1006	2016	2003	3	100
1/29/2020	1006	2017	2006	1	90
3/10/2020	1007	2017	2005	4	85
12/25/2019	1007	2019	2006	12	90
1/14/2020	1006	2019	2001	9	95
3/3/2020	1006	2020	2001	12	95
11/21/2019	1006	2021	2003	8	100
11/29/2019	1007	2021	2001	11	95
2/10/2020	1007	2021	2005	3	85
2/10/2020	1007	2021	2001	4	95
2/10/2020	1007	2021	2004	6	105
2/12/2020	1006	2021	2003	4	100
11/12/2019	1006	2022	2002	4	120
1/13/2020	1006	2022	2001	1	95
1/15/2020	1006	2022	2002	6	120
1/27/2020	1006	2022	2004	5	105
3/25/2020	1007	2022	2004	4	105
3/25/2020	1006	2022	2003	1	100
1/27/2020	1006	2023	2004	1	105
3/9/2020	1006	2024	2003	1	100
3/9/2020	1006	2024	2006	3	90
3/29/2020	1007	2025	2003	6	100
4/13/2020	1007	2025	2001	10	95
1/12/2020	1007	2026	2004	4	105
2/11/2020	1007	2027	2004	9	105
2/11/2020	1007	2027	2005	9	85
1/14/2020	1006	2028	2001	2	95
3/18/2020	1007	2028	2006	4	90
3/2/2020	1007	2029	2006	11	90
3/28/2020	1006	2029	2004	8	105
12/12/2019	1006	2031	2005	10	85
4/8/2020	1006	2031	2004	5	105
11/7/2019	1006	2032	2003	6	100
11/8/2019	1007	2033	2004	11	105
11/22/2019	1006	2034	2003	4	100
1/1/2020	1006	2034	2002	10	120
1/1/2020	1006	2034	2001	7	95
1/24/2020	1006	2034	2004	5	105
11/20/2019	1006	2035	2004	2	105
11/30/2019	1006	2035	2005	11	85
1/8/2020	1006	2035	2005	7	85
12/30/2019	1006	2036	2004	6	105
3/25/2020	1007	2036	2006	3	90
4/8/2020	1007	2036	2005	4	85
11/14/2019	1007	2037	2003	2	100
12/4/2019	1007	2037	2003	4	100
1/31/2020	1007	2037	2006	4	90
2/17/2020	1007	2037	2006	11	90
3/4/2020	1007	2037	2003	10	100
11/4/2019	1007	2038	2003	2	100
11/4/2019	1007	2038	2002	4	120
12/1/2019	1007	2038	2005	10	85
11/20/2019	1007	2039	2004	11	105
3/19/2020	1007	2039	2001	3	95
4/13/2020	1006	2039	2002	11	120
1/30/2020	1006	2040	2006	4	90
1/30/2020	1006	2040	2001	7	95
3/3/2020	1007	2040	2001	7	95
3/9/2020	1006	2040	2004	4	105
3/13/2020	1006	2040	2003	2	100
12/19/2019	1007	2041	2006	4	90
12/20/2019	1007	2042	2004	9	105
4/25/2020	1007	2042	2004	11	105
11/7/2019	1006	2043	2001	1	95
11/16/2019	1006	2043	2005	12	85
1/7/2020	1007	2043	2003	12	100
1/7/2020	1007	2043	2004	10	105
3/26/2020	1006	2043	2001	10	95
3/27/2020	1007	2043	2004	2	105
4/21/2020	1007	2043	2003	1	100
3/10/2020	1006	2044	2004	9	105
3/10/2020	1006	2044	2006	12	90
2/27/2020	1006	2045	2005	8	85
4/19/2020	1007	2045	2003	6	100
2/13/2020	1007	2046	2004	2	105
3/24/2020	1007	2046	2003	9	100
2/29/2020	1007	2047	2003	11	100
12/7/2019	1006	2048	2004	1	105
12/16/2019	1006	2048	2004	6	105
12/16/2019	1006	2048	2005	9	85
1/12/2020	1007	2048	2003	11	100
12/22/2019	1007	2049	2004	8	105
4/14/2020	1007	2049	2001	8	95
1/31/2020	1006	2050	2002	7	120
2/1/2020	1007	2050	2003	2	100
3/16/2020	1006	2050	2004	10	105
3/27/2020	1006	2050	2003	6	100
1/26/2020	1007	2051	2005	12	85
11/8/2019	1007	2052	2005	2	85
11/24/2019	1007	2052	2004	9	105
1/22/2020	1006	2053	2004	8	105
4/19/2020	1006	2053	2004	10	105
11/13/2019	1007	2054	2004	3	105
11/13/2019	1007	2054	2005	3	85
11/1/2019	1006	2056	2001	10	95
12/18/2019	1006	2056	2003	10	100
12/23/2019	1006	2056	2003	8	100
3/19/2020	1007	2056	2003	1	100
1/25/2020	1006	2057	2003	6	100
4/8/2020	1006	2057	2003	10	100
12/2/2019	1007	2058	2002	1	120
2/15/2020	1006	2058	2003	7	100
12/15/2019	1007	2059	2004	11	105
11/22/2019	1006	2060	2005	6	85
12/5/2019	1006	2060	2003	7	100
1/28/2020	1007	2060	2005	11	85
4/7/2020	1006	2060	2003	3	100
4/17/2020	1007	2060	2003	11	100
1/6/2020	1007	2061	2004	12	105
1/19/2020	1006	2061	2004	3	105
3/26/2020	1007	2061	2003	11	100
3/19/2020	1007	2062	2003	10	100
4/10/2020	1006	2062	2005	6	85
4/10/2020	1006	2062	2004	2	105

Sales_Transactions_Table

Sales_Order_ID	Sales_Order_Date	Sales_Employee_ID	Customer_ID	Product_Code	Sales_Order_Quantity_Sold	Product_Sale_Price
20062	11/22/2019	1007	2001	2004	12	105
20168	12/27/2019	1007	2001	2005	8	85
20383	3/4/2020	1007	2001	2004	5	105
20564	4/28/2020	1007	2001	2002	6	120
20140	12/20/2019	1006	2002	2001	5	95
20310	2/11/2020	1007	2002	2004	2	105
20308	2/11/2020	1006	2004	2004	8	105
20308	2/11/2020	1006	2004	2003	11	100
20009	11/2/2019	1006	2005	2004	3	105
20233	1/16/2020	1006	2006	2003	7	100
20163	12/25/2019	1006	2007	2003	3	100
20224	1/13/2020	1006	2007	2001	1	95
20199	1/7/2020	1007	2008	2005	8	85
20291	2/4/2020	1007	2008	2005	7	85
20451	3/24/2020	1006	2008	2006	9	90
20451	3/24/2020	1006	2008	2002	2	120
20012	11/4/2019	1006	2009	2005	1	85
20494	4/8/2020	1006	2009	2005	6	85
20494	4/8/2020	1006	2009	2004	2	105
20537	4/19/2020	1007	2009	2004	6	105
20250	1/22/2020	1006	2010	2005	5	85
20251	1/22/2020	1007	2010	2004	11	105
20003	11/1/2019	1006	2011	2006	8	90
20241	1/19/2020	1007	2011	2004	2	105
20253	1/22/2020	1007	2011	2005	10	85
20005	11/1/2019	1006	2012	2006	9	90
20005	11/1/2019	1006	2012	2001	8	95
20090	12/1/2019	1006	2012	2002	10	120
20033	11/12/2019	1007	2013	2003	1	100
20211	1/10/2020	1007	2013	2006	12	90
20211	1/10/2020	1007	2013	2005	12	85
20338	2/22/2020	1006	2013	2005	6	85
20393	3/7/2020	1007	2013	2003	9	100
20097	12/4/2019	1007	2014	2003	9	100
20418	3/14/2020	1006	2016	2006	12	90
20543	4/20/2020	1006	2016	2003	3	100
20277	1/29/2020	1006	2017	2006	1	90
20406	3/10/2020	1007	2017	2005	4	85
20161	12/25/2019	1007	2019	2006	12	90
20229	1/14/2020	1006	2019	2001	9	95
20379	3/3/2020	1006	2020	2001	12	95
20056	11/21/2019	1006	2021	2003	8	100
20080	11/29/2019	1007	2021	2001	11	95
20305	2/10/2020	1007	2021	2005	3	85
20305	2/10/2020	1007	2021	2001	4	95
20305	2/10/2020	1007	2021	2004	6	105
20312	2/12/2020	1006	2021	2003	4	100
20031	11/12/2019	1006	2022	2002	4	120
20223	1/13/2020	1006	2022	2001	1	95
20230	1/15/2020	1006	2022	2002	6	120
20266	1/27/2020	1006	2022	2004	5	105
20452	3/25/2020	1007	2022	2004	4	105
20454	3/25/2020	1006	2022	2003	1	100
20265	1/27/2020	1006	2023	2004	1	105
20404	3/9/2020	1006	2024	2003	1	100
20404	3/9/2020	1006	2024	2006	3	90
20471	3/29/2020	1007	2025	2003	6	100
20513	4/13/2020	1007	2025	2001	10	95
20218	1/12/2020	1007	2026	2004	4	105
20307	2/11/2020	1007	2027	2004	9	105
20307	2/11/2020	1007	2027	2005	9	85
20227	1/14/2020	1006	2028	2001	2	95
20438	3/18/2020	1007	2028	2006	4	90
20375	3/2/2020	1007	2029	2006	11	90
20465	3/28/2020	1006	2029	2004	8	105
20120	12/12/2019	1006	2031	2005	10	85
20496	4/8/2020	1006	2031	2004	5	105
20020	11/7/2019	1006	2032	2003	6	100
20024	11/8/2019	1007	2033	2004	11	105
20063	11/22/2019	1006	2034	2003	4	100
20183	1/1/2020	1006	2034	2002	10	120
20183	1/1/2020	1006	2034	2001	7	95
20256	1/24/2020	1006	2034	2004	5	105
20053	11/20/2019	1006	2035	2004	2	105
20086	11/30/2019	1006	2035	2005	11	85
20202	1/8/2020	1006	2035	2005	7	85
20179	12/30/2019	1006	2036	2004	6	105
20453	3/25/2020	1007	2036	2006	3	90
20495	4/8/2020	1007	2036	2005	4	85
20040	11/14/2019	1007	2037	2003	2	100
20098	12/4/2019	1007	2037	2003	4	100
20283	1/31/2020	1007	2037	2006	4	90
20328	2/17/2020	1007	2037	2006	11	90
20384	3/4/2020	1007	2037	2003	10	100
20013	11/4/2019	1007	2038	2003	2	100
20013	11/4/2019	1007	2038	2002	4	120
20089	12/1/2019	1007	2038	2005	10	85
20055	11/20/2019	1007	2039	2004	11	105
20440	3/19/2020	1007	2039	2001	3	95
20516	4/13/2020	1006	2039	2002	11	120
20280	1/30/2020	1006	2040	2006	4	90
20280	1/30/2020	1006	2040	2001	7	95
20378	3/3/2020	1007	2040	2001	7	95
20403	3/9/2020	1006	2040	2004	4	105
20416	3/13/2020	1006	2040	2003	2	100
20138	12/19/2019	1007	2041	2006	4	90
20142	12/20/2019	1007	2042	2004	9	105
20559	4/25/2020	1007	2042	2004	11	105
20017	11/7/2019	1006	2043	2001	1	95
20043	11/16/2019	1006	2043	2005	12	85
20200	1/7/2020	1007	2043	2003	12	100
20200	1/7/2020	1007	2043	2004	10	105
20457	3/26/2020	1006	2043	2001	10	95
20461	3/27/2020	1007	2043	2004	2	105
20545	4/21/2020	1007	2043	2003	1	100
20407	3/10/2020	1006	2044	2004	9	105
20407	3/10/2020	1006	2044	2006	12	90
20357	2/27/2020	1006	2045	2005	8	85
20535	4/19/2020	1007	2045	2003	6	100
20314	2/13/2020	1007	2046	2004	2	105
20450	3/24/2020	1007	2046	2003	9	100
20368	2/29/2020	1007	2047	2003	11	100
20106	12/7/2019	1006	2048	2004	1	105
20126	12/16/2019	1006	2048	2004	6	105
20126	12/16/2019	1006	2048	2005	9	85
20217	1/12/2020	1007	2048	2003	11	100
20151	12/22/2019	1007	2049	2004	8	105
20518	4/14/2020	1007	2049	2001	8	95
20282	1/31/2020	1006	2050	2002	7	120
20285	2/1/2020	1007	2050	2003	2	100
20424	3/16/2020	1006	2050	2004	10	105
20460	3/27/2020	1006	2050	2003	6	100
20262	1/26/2020	1007	2051	2005	12	85
20023	11/8/2019	1007	2052	2005	2	85
20068	11/24/2019	1007	2052	2004	9	105
20249	1/22/2020	1006	2053	2004	8	105
20539	4/19/2020	1006	2053	2004	10	105
20037	11/13/2019	1007	2054	2004	3	105
20037	11/13/2019	1007	2054	2005	3	85
20001	11/1/2019	1006	2056	2001	10	95
20137	12/18/2019	1006	2056	2003	10	100
20155	12/23/2019	1006	2056	2003	8	100
20439	3/19/2020	1007	2056	2003	1	100
20261	1/25/2020	1006	2057	2003	6	100
20492	4/8/2020	1006	2057	2003	10	100
20093	12/2/2019	1007	2058	2002	1	120
20325	2/15/2020	1006	2058	2003	7	100
20124	12/15/2019	1007	2059	2004	11	105
20059	11/22/2019	1006	2060	2005	6	85
20103	12/5/2019	1006	2060	2003	7	100
20271	1/28/2020	1007	2060	2005	11	85
20491	4/7/2020	1006	2060	2003	3	100
20532	4/17/2020	1007	2060	2003	11	100
20192	1/6/2020	1007	2061	2004	12	105
20242	1/19/2020	1006	2061	2004	3	105
20458	3/26/2020	1007	2061	2003	11	100
20441	3/19/2020	1007	2062	2003	10	100
20503	4/10/2020	1006	2062	2005	6	85
20503	4/10/2020	1006	2062	2004	2	105

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: Explore how and why to work with data in range and table formats. Ask the Question: What is the best format to work with the data? Master the Data: The dataset contains information about sales transactions to different customers. There are 132 unique transactions, but 149 rows-this is because some of the transactions had multiple products on them. This data is similar to the data used in several of the labs in Chapter 3; however, in Chapter 3, the data had already been transformed. In this lab, we will work with only the data that belongs in the Sales_Transactions table. Software needed . Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 4-1 Data.xIsx. Perform the Analysis: Refer to Lab 4-1 In the text for instructions and 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. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. 1. Return to the Sales_Transactions_Range spreadsheet, and take a screenshot of the data Including the new column for Invoice Amount. Label it "Lab 4-1 Submission 1." 2. Return to the Sales_Transactions_Table spreadsheet, and take a screenshot of the data including the new column for Invoice Amount. Label it "Lab 4-1 Submission 2."File Home Insert Page Layout Formulas Data Review View Add-ins Help Comments Share X Cut AutoSum Calibri v 11 A A ab Wrap Text General AY O Paste [A Copy Fill Analyze BIUT Y E $ ~ % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Solver E Merge & Center Formatting Table Styles Clear Format Painter Filter ~ Select Data Font Alignment Number Styles Cells Editing Analysis Solver Clipboard K15 X v fx B C D E F G H K L M N O Sales_Order_Dateales_Employee_10 Customer_ID Product_Code _Order_Quantity_Product_Sale_Price 11/22/2019 1007 2001 2004 12 105 1 A W N - 12/27/2019 1007 2001 2005 85 3/4/2020 1007 2001 2004 105 4/28/2020 1007 2001 2002 120 12/20/2019 1006 2002 2001 95 6 0O V O UT 2/11/2020 1007 2002 2004 2 105 2/11/2020 1006 2004 2004 8 105 2/11/2020 1006 2004 2003 11 100 10 11/2/2019 1006 2005 2004 105 11 1/16/2020 1006 2006 2003 100 12 12/25/2019 1006 2007 2003 100 13 1/13/2020 1006 2007 2001 95 14 1/7/2020 1007 2008 2005 85 15 2/4/2020 1007 2008 2005 85 16 3/24/2020 1006 2008 2006 U O N O H N D V OO H W V W 90 17 3/24/2020 1006 2008 2002 120 18 11/4/2019 1006 2009 2005 85 19 4/8/2020 1006 2009 2005 85 20 4/8/2020 1006 2009 2004 105 21 4/19/2020 1007 2009 2004 105 22 1/22/2020 1006 2010 2005 85 23 1/22/2020 1007 2004 11 105 24 11/1/2019 1006 2011 2006 8 90 25 1/19/2020 1007 2011 2004 105 26 1/22/2020 1007 2011 2005 10 35 27 11/1/2019 1006 2012 2006 9 90 28 11/1/2019 1006 2012 2001 8 95 29 12/1/2019 1006 2012 2002 10 120 Sales_Transactions_Range Sales_Transactions_Table (+) 2 Accessibility: Good to go + 100% ReadyComments File Home Insert Page Layout Formulas Data Review View Add-ins Help Share AutoSum X Cut Calibri v 11 AA ab Wrap Text General AY O Fill Copy Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Solver Paste BIUMVA E Merge & Center ~ $ ~ % 9 08 28 Formatting * Table Styles Clear Filter ~ Select Data Format Painter Number Styles Cells Editing Analysis Solver Clipboard Font Alignment K15 X V F G H J K L M N O P Q R A B C D E Sales_Order_ID Sales_Order_Date ales_Employer Customer_Product_C . Order_Quant * Product_Sale_Pr 20062 11/22/2019 1007 2001 2004 12 105 20168 12/27/2019 1007 2001 2005 8 85 AWN 20383 3/4/2020 1007 2001 2004 5 105 20564 4/28/2020 1007 2001 2002 6 120 20140 12/20/2019 1006 2002 2001 5 95 20310 2/11/2020 1007 2002 2004 2 105 20308 2/11/2020 1006 2004 2004 8 105 20308 2/11/2020 1006 2004 2003 11 100 10 20009 11/2/2019 1006 2005 2004 3 105 11 20233 1/16/2020 1006 2006 2003 7 100 12 20163 12/25/2019 1006 2007 2003 100 PW 13 20224 1/13/2020 1006 2007 2001 95 14 20199 1/7/2020 1007 2008 2005 85 15 20291 2/4/2020 1007 2008 2005 85 16 20451 3/24/2020 1006 2008 2006 90 17 20451 3/24/2020 1006 2008 2002 120 18 20012 11/4/2019 1006 2009 2005 85 NOUN 19 20494 4/8/2020 1006 2009 2005 85 20 20494 4/8/2020 1006 2009 2004 105 21 20537 4/19/2020 1007 2009 2004 105 22 20250 1/22/2020 1006 2010 2005 5 35 23 20251 1/22/2020 1007 2010 2004 11 105 24 20003 11/1/2019 1006 2011 2006 8 90 25 20241 1/19/2020 1007 2011 2004 2 105 26 20253 1/22/2020 1007 2011 2005 10 85 27 20005 11/1/2019 1006 2012 2006 9 90 28 20005 11/1/2019 1006 2012 2001 8 95 29 20090 12/1/2019 1006 2012 2002 10 120 Sales_Transactions_Range Sales_Transactions_Table (+ # + 100% Ready Accessibility: Good to go