1. Copy data from Sales Workbook into a new workbook, in the Sheet 1 and name this new workbook as Assignment 2. (Hint: use paste special (Paste Values Value and Source Formatting), adjust size of column using autofit). 2. In the sheet 1, insert Line Sparkline in the G7:G10 3. Use Style Gold Sparkline Style Accent 4 in Sheet 1 for cell range G7:G10 4. Use Marker color Red for High Point 5. Copy data from Sales Workbook into a new sheet i.e. Sheet 2 of the Assignment 2 workbook. 6. In the sheet 2, insert column Sparkline in the G7:G10 7. Use Style Grey Sparkline Style Accent 3 in Sheet 2 for cell range G7:G10 8. Use Marker color Red for High Point in Sheet 2 for cell range G7:G10 9. Copy data from Sales Workbook into a new (Assignment 2) workbook in Sheet 3. 10. In the sheet 3, insert Win-loss Sparkline in the G7:G10 11. In the sheet 3 Style Dark Blue Sparkline Style Accent 1 for cell range G7:G10 12. Use Marker color Red for High Point in Sheet 3 for cell range G7:G10 13. Copy data from Sales Workbook into a new workbook (Assignment 2) in Sheet 4. 14. Remove conditional formatting 15. Copy data from Sales Workbook into a new workbook in Sheet 4. 16. Use conditional formatting Gradient Fill Green Data Bar for cell range B7:E10 17. Copy data from Sales Workbook into a new workbook (Assignment 2) in Sheet 5. 18. Use conditional formatting Color Scale Red White Blue for cell range B7:E10 19. Copy data from Sales Workbook into a new workbook (Assignment 2) in Sheet 6. 20. Remove conditional formatting in the sheet 6 and apply new rule Format only cell that contain cell value greater than $9000 use color green for the font.