Your Task-Directions: Complete the following to re-create these charts. 1. Prepare a worksheet using the First...

Transcribed Image Text:

Your Task-Directions: Complete the following to re-create these charts. 1. Prepare a worksheet using the First Tee National Program data provided below. Format this data in your worksheet as shown. Did you check to make sure you entered in the data correctly? 2. Create the pie chart as illustrated below-matching closely the design, colors, borders, titles, chart elements, and all other formatting. Keep the chart on the same worksheet as your data. 3. Name the sheet tab: First Tee 4. Here are a few notes to use when building the chart: Legend 11 pt Leader Lines Enlarge font for pie Border with color and rounded corners; 3pt Numbers are percentages with no decimal places Dynamic Chart Title-this means if the chart title changes on your worksheet it will change on your chart. Pie slices all have same color intensity 60% font is much larger to draw emphasis to this statistic Font color of 60% matches color palette of pie slice. Evaluation-15 pts -2 pts. for each chart element or design component missing -2 pts. for each misspelling/typo 4 5 A B 1 First Tee National Program 234 2 PARTICIPATION BY ETHNICITY 3 2020 Category Participants 7,100 7 Latino or Hispanic 2,680 8 Black or African American 1,500 9 Asian 344 10 Multi-Racial 250 11 6 White or Caucasian PARTICIPATION BY ETHNICITY 3% 2% 13% 60% 22% White or Caucasian Latino or Hispanic Black or African American Asian Multi-Racial Your Task-Directions: Complete the following to re-create these charts. 1. Prepare a worksheet using the First Tee National Program data provided below. Format this data in your worksheet as shown. Did you check to make sure you entered in the data correctly? 2. Create the pie chart as illustrated below-matching closely the design, colors, borders, titles, chart elements, and all other formatting. Keep the chart on the same worksheet as your data. 3. Name the sheet tab: First Tee 4. Here are a few notes to use when building the chart: Legend 11 pt Leader Lines Enlarge font for pie Border with color and rounded corners; 3pt Numbers are percentages with no decimal places Dynamic Chart Title-this means if the chart title changes on your worksheet it will change on your chart. Pie slices all have same color intensity 60% font is much larger to draw emphasis to this statistic Font color of 60% matches color palette of pie slice. Evaluation-15 pts -2 pts. for each chart element or design component missing -2 pts. for each misspelling/typo 4 5 A B 1 First Tee National Program 234 2 PARTICIPATION BY ETHNICITY 3 2020 Category Participants 7,100 7 Latino or Hispanic 2,680 8 Black or African American 1,500 9 Asian 344 10 Multi-Racial 250 11 6 White or Caucasian PARTICIPATION BY ETHNICITY 3% 2% 13% 60% 22% White or Caucasian Latino or Hispanic Black or African American Asian Multi-Racial