Create a new Excel workbook on your PC (or flash drive) named18PR_excel_LastFirst, where LastFirst is your actual Lastname and Firstname(For example, if your name is Mary Smith, you will name the file18PR_excel_SmithMary)136.a.Enter the following datainto cell range A1:F7intoSheet1 worksheet of your empty, newly created Excelfileb.AutoFitthe column widthfor columns Athrough FNote: to AutoFit the columns, do not use the AutoFit Column Width menu option under Format. Instead, select the entire Sheet1 worksheet by clicking the diagonal down arrow1(left of column A) and simply position the mouse over the column line in the column headers, between any two columns so the cursor becomes a double headed arrow2and double-clickso all columns will AutoFit at the same time.Below is a sample of what your file should look like at this time237.Rename and Copy the worksheet as follows:a.Rename the Sheet1 worksheet to: Productsb.Right-click the Productsworksheet tab and selectMove or Copyfrom the worksheetmenu.c.The Move or Copy dialog box will appear. Under Before sheet: select (move to end)to place the worksheet to the right of the existing worksheet.d.Check the boxnext to Create a copy, then click OK.e.Rename the new worksheetto:Updated Products238.Inthe Updated Productsworksheet,addthe following column headings:a.In cell G1enter Profit per Unitb.In cell H1enter Possible Discountc.In cell I1enter Quantityd.In cell J1enter Net Income239.In cell G2, insert a formulato calculate the differencebetween the UnitPriceand the UnitCost. a.Use the fill handleto copythis formula down to row 7.NOTE: Verify formularesult with the image in step 48below240.In cell H2, insert an IFfunctionthat displays a value of"Y"(when true) or "N"(when false) ifthe UnitCost(E2) is greaterthan or equalto 100.a.Use the fill handleto copythis formula down to row 7.212 Page 11of 20StepsPart 3 -EXCEL Project InstructionsPointsNOTE: Verify function result with the image in step 48 below41.Enterthe following data:a.In cell I2enter 100b.In cell I3enter 150c.In cell I4enter200d.In cell I5enter 20e.In cell I6enter 10f.In cell I7enter 1g.In cell I9enter Discount:h.In cell I10enter Highest Value:i.In cell I11enter Lowest Value:j.In cell I12enter Sum:k.In cell I13enter Average:l.In cell J9enter 5NOTE: Verify data enteredwith the image in step 48 below242.Format as follows:a.AutofitColumn Width for column Ib.Format J9to CurrencyNumber Formatwith 2decimal placesc.Select row 1and Wrap Textwhich will display column headings in G1, H1 and J1as multiple lines within the cell.d.Selectthe column headings A1:J1and apply Cell Styleof Heading3.NOTE: Verify formattingwith the image in step 48 below243.In cell J2, insert anIFfunctionthat calculates the value forNet Incomeas follows:a.If the Possible Discount(H2) is equal to"Y", i)(true) The gross income is the (Profit per Unit-Discount)multipliedby the Quantity(G2-$J$9)*I2ii)(false) Or else, the gross income is the Profit per Unitmultipliedby the Quantity.b.Use the fill handleto copythis formula down to row 7.c.Format thecells in J2:J7to CurrencyNumber Formatwith 2decimal placesNOTE: Verify function result with the image in step 48 below244.Use appropriate functionsto do the following:a.In cell J10enter a function to display the highest valuefor the range J2:J7b.Incell J11enter a function to display the lowest valuefor the range J2:J7c.In cell J12enter a function to sumthe cells in therange J2:J7d.In cell J13enter a function to averagethe cells in therange J2:J7NOTE: Verify function results with the image instep 48below245.Inserta 3-D Clustered Columnchart(see image in step 48below)as follows:a.Simultaneously select the following data: B1:B7, D1:D7, E1:E7, G1:G7, I1:I7b.Insert a 3-D Clustered Columnchartc.Moveand resizethe pie chart so that it is located in cells B9:G23d.Change the Chart Title to Excel Projecte.Changethe Chart Styleto Style 6.2 Page 12of 20StepsPart 3 -EXCEL Project InstructionsPointsf.Remove the data labels as follows:i)On the Chart Tools Designtab, in the Chart Layoutsgroup, click Add Chart Element, click Data Labels, and select None.46.Change the Page Layoutof the Updated Productsworksheet so that it(see image in step 48below):a.Is set to Landscapeorientationandb.Will FIT to one Page, andc.Has a Customer Headerwith Your Namein the leftsection, Sheet Namein the centersection, and Current Dateon the rightsection, andd.Will print with Gridlines.e.Will print with Row and column headings247.When completed, the Updated Productsworksheet should look similar to the following:0 Page