50%(2)1 out of 2 people found this document helpful
This preview shows page 1 - 3 out of 3 pages.
Office 2016 – myitlab:grader – InstructionsExcel ProjectStepInstructionsPointsPossible11On the Summary sheet, insert a function in the Total Sales row to sum each column. Apply the Total Cell style to the Total Sales results. Apply the Comma  cell style, to the range B5:F7.5.00012On the Summary sheet, in cell H2 type 10,000in cell H3, type BonusIn cell H4, enter an IF function that will display the value 275if the value in cell F4 is greater than the value in H2. Otherwise, the function will return the value 25. In the function, use an absolute cell reference to H2. Apply the Currency  cell style to the result in cell H4. AutoFill cell H4 down through cell H7.6.00013On the Summary sheet, in the range G4:G7 insert Line Sparkline to represent the location data for each quarter. Show the High point for each Sparkline.5.50014Group the worksheets. Make cell A1 the active cell. Find any occurrence of Hardwareand replace it with Appliance. In the grouped worksheets correct any spelling errors. Ungroup the worksheets.1.75015On the Summary sheet, in cell A10, insert the TODAY function. Apply the date format 14-Mar-12.4.00016On the Summary sheet, in B4:E7 apply the Gradient Fill Blue Data Bar conditional formatting.3.00017On the Summary sheet, create a 2-D Clustered Column chart using the range A3:E7. Move the chart to anew sheet and rename the sheet Sales Chart. Change the layout to Layout 2. Apply chart Style 4.