6000 Updated 10242016 1 Office 2016 myitlabgrader

6000 updated 10242016 1 office 2016 myitlabgrader

This preview shows page 1 - 3 out of 3 pages.

6.000 Updated: 10/24/2016 1 Current_Instruction.docx
Image of page 1
Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible 11 On 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 [0] cell style, to the range B5:F7. 5.000 12 On the Summary sheet, in cell H2 type 10,000 in cell H3, type Bonus In cell H4, enter an IF function that will display the value 275 if 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 [0] cell style to the result in cell H4. AutoFill cell H4 down through cell H7. 6.000 13 On 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.500 14 Group the worksheets. Make cell A1 the active cell. Find any occurrence of Hardware and replace it with Appliance . In the grouped worksheets correct any spelling errors. Ungroup the worksheets. 1.750 15 On the Summary sheet, in cell A10, insert the TODAY function. Apply the date format 14-Mar-12. 4.000 16 On the Summary sheet, in B4:E7 apply the Gradient Fill Blue Data Bar conditional formatting. 3.000 17 On the Summary sheet, create a 2-D Clustered Column chart using the range A3:E7. Move the chart to a new sheet and rename the sheet Sales Chart . Change the layout to Layout 2. Apply chart Style 4.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture