solution

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.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"