Instruction
Rename Worksheet1 with your name, Worksheet2 to What-IF, Worksheet3 to Goal Seek, Worksheet4 to Charts and color the tabs.
• Use this current calendar year as your starting year
• Format the worksheet with colors, $ sign’s etc. to give it a professional look
• Ensure the current year and following 4 years appear as labels
• Have the $10,000 bonus cell show with a red background and the $5,000 bonus show a green
background. {Note: this shading needs to change if the bonus value changes}
• Use appropriate titles and legends for the Line and Pie charts. For the Pie Chart ‘explode’ the
slice for supplies and have the slices show just percentages.