Cal Rubine, chair of the Theatre Arts Division at Niagara Peninsula
College, has asked you to create charts from the grades analysis report
to present at a divisional meeting. After reviewing the grades, you
decide to create a line chart depicting the grades for all of the
courses and a pie chart summarizing the total grades.
Create a line chart in its own sheet that will display the A+ through F
grades for each course. Include an appropriate chart title. You
determine what other chart elements to include that will make the chart
easy to interpret.
Create a 3-d pie chart that will display the total of each grade as a
percentage of 100. (Hint: Select the ranges B4:G4 and B12:G12 before
starting the Chart Wizard.) Include an appropriate chart title. Place
the pie at the bottom of the Grades worksheet starting in Row 14.
Resize the chart to extend its width to the right edge of column H and
the height to the bottom boundary of row 30.
Draw an arrow pointing to the F slice in the pie chart. Create a text
box at the end of the arrow containing the text Lowest attrition since
1997!
If necessary, resize the arrow and text box.
Changes the font color of the text inside the text box to Red.
Change the line color of the border of the text box to Blue.
Computer Science Homework Solutions
#55640
Excel S3-P4
Cal Rubine, chair of the Theatre Arts Division at Niagara Peninsula College, has asked you to create charts from the grades analysis report to present at a divisional meeting. After reviewing the grades, you decide to create a line chart depicting the grades for all of the courses and a pie chart summarizing the total grades.
1. Create a line chart in its own sheet that will display the A+ through F grades for each course. Include an appropriate chart title. You determine what other chart elements to include that will make the chart easy to interpret.
2. Create a 3-d pie chart that will display the total of each grade as a percentage of 100. (Hint: Select the ranges B4:G4 and B12:G12 before starting the Chart Wizard.) Include an appropriate chart title. Place the pie at the bottom of the Grades worksheet starting in Row 14.
3. Resize the chart to extend its width to the right edge of column H and the height to the bottom boundary of row 30.
4. Draw an arrow pointing to the F slice in the pie chart. Create a text box at the end of the arrow containing the text Lowest attrition since 1997!
5. If necessary, resize the arrow and text box.
6. Changes the font color of the text inside the text box to Red.
7. Change the line color of the border of the text box to Blue.
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- ExcelS3-P4[1].xls.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- C++ using multidimensional dimensional array - A certain professor has a file containing a table of student grades, where the first line of the file contains the number of students and the number of scores in the table; each row of the table repre ...
- Using Multidimensional Arrays and Vectors, write a program that generates report from a table of student grades. - A certain professor has a file containing a table of student grades, where the first line of the file contains the number of students and the number of scores in the table; each row of the table repre ...
- Multidimensional Arrays and Vectors - I need the following in C++: A certain professor has a file containing a table of student grades, where the first line of the file contains the number of students and the number of scores in the ta ...
- Multidimensional Arrays and Vectors - A certain professor has a file containing a table of student grades, where the first line of the file contains the number of students and the number of scores in the table; each row of the table repre ...
- Internetworking Design - This week I am reading Network addressing and naming. I have several questions. They are attached. 1. How do I identify a broadcast address and a subnet ID if I am given 6.6.6.6 255.255.128.0 ...
