Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 X Cut Peste copy Format Painter Clipboard Arial -10 A A BTV - BA- 2 Wrap Text . Merge & Center - Alignment General
1 X Cut Peste copy Format Painter Clipboard Arial -10 A A BTV - BA- 2 Wrap Text . Merge & Center - Alignment General $ -% Number Conditional Format as Formatting Table 8-98 6 Styles 011 .1 X -SUM(14:010) 1 Question 5 CHART and IF Function 3 Directions: Avl. Points: Your Points: 4 1) Change the font of the Student Grades in cel A15 to Times New Roman 5 2) Change the heading font type to Comic Sans MS size 16 for all headings in row 17 6 3) Bold face and Italicize Al Student Names in rows 18-23 74) Using the average function, calculate the test average for each student 8 5) Use an IF statement for the Honors column 9 If the average is greater than or equal to 90 Print YES otherwise Print NO 106) Create a bar chart of the student names and their averages Total: 15 Student Grades Test 1 Test 2 Test 3 Average Honors 67 17 Name 18 Allen 19 Borlin 20 Catin 21 Dorsey 22 Finerran 23 Greco 76 88 Question 1 Question 2 Question 3 Question 4 Question 5 TOTAL GRADE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started