Complete "Lab 2: Sales Analysis Worksheet” on pages EX 61 – EX 62. The lab begins at the top of page EX 61 and requires you to create a spreadsheet and a chart based on what you learned in Excel Chapter 1. To complete this assignment, it is recommended that you read Excel Chapter 1 – Creating a Worksheet and a Chart pages EX 1 – EX 54.  Perform the following tasks:

1. Go to page EX 61 and read the problem section of Lab 2: Sales Analysis Worksheet.  

 

1. Read the assignment instructions on page EX 62 and complete steps 1 through 6.
2. Change the document properties to include your name and the course number.
3. Make corrections to the figures in the spreadsheet for Package A sold in Louisiana (cell B7) to $151, 992.60 and Package B sold in Virginia (cell C11) to $183, 573.67.
4. Change the State in cell A11 to the State in which you were born. If your state is already listed in the spreadsheet, choose a different State.
5. Save the spreadsheet in the Week 4 folder you created in week 2 and name the file W4_last_name (replace last_name with your last name).
6. Submit the assignment as an Excel file (.xlsx) using W4 assignment submission link above. Click here to preview an example of the completed spreadsheet and chart. 

 

Package APackage BPackage CPackage DTotalFlorida882,159.71$139,388.08$282,893.78$521,907.12$1,826,348.69$Georgia424,831.57644,502.14378,930.88504,893.621,953,158.22Louisiana51,992.60402,543.65779,472.2084,159.191,318,167.64Mississippi917,288.79648,651.15493,499.41266,127.382,325,566.72North Carolina897,478.89653,663.92326,152.40290,625.292,167,920.49South Carolina374,888.19429,976.17455,069.28627,464.721,887,398.36Virginia791,763.66257,652.61384,759.74895,336.172,329,512.18Total4,340,403.42$3,176,377.72$3,100,777.67$3,190,513.50$13,808,072.30$CinCar SatelliteYearly SalesCells are formattedappropriatelyThe worksheet title and subtitle areentered and formattedThe worksheet name anda theme color are appliedto the sheet tabThe worksheet is printed inlandscape orientationThe totals row and column arecreated and SUM function is usedto determine totals as instructedThe worksheet shown in Figure1–77a is created using the datain Table 1–8Two corrections are madeState in cell A11 has beenchanged