III. Tables and Graphs 28 Create a column chart using the data in Table A below.
ID: 3120555 • Letter: I
Question
III. Tables and Graphs 28 Create a column chart using the data in Table A below. Group similar assignments into 3 groups in this orders: Quizzes, Exams, and Projects.Fill the Quiz bars as follows: Quizzes = Red; Projects = Purple, and Exams = Navy Blue
Title the chart: Grades by Assignment Category.
Set the Y axis scale from 0 to 100 in 10s and bold the font.
The X axis should be grouped by assignment type, and bold the font.
Place graph on the next sheet. Table A Assignment Due Date Grade Quiz 1 Jan. 8 82 Quiz 2 Jan. 15 81 Quiz 3 Jan. 23 90 Quiz 4 Jan. 30 75 Quiz 5 Feb. 7 75 Quiz 6 Feb. 10 77 Project A Feb. 14 84 Project B Feb. 21 88 Midterm Feb. 25 72 Final Exam Feb. 28 70 Answer: Possible points = 5
Points you earned = 29 Table A:
Revenue by Department per Month
(in Thousands) Department: January February March April May June July August September October November December Accessories $18,943.43 $17,223.65 $21,945.78 $25,943.93 $28,520.55 $32,734.33 $29,543.21 $28,441.56 $23,910.52 $20,128.87 $35,912.39 $45,000.31 Clothing 16,302.03 19,443.43 21,884.73 17,990.69 18,396.49 19,449.40 20,471.99 24,110.85 26,551.07 19,337.63 21,023.45 28,945.66 Jewelry 35,944.34 32,680.64 41,640.64 49,226.84 54,116.70 62,112.77 56,057.84 53,966.80 45,369.23 38,192.88 68,143.02 85,387.50 The following two charts were created from the table above.
Which Excel function can change Graph I to Graph II with one key stroke? Answer: Possible points = 2
Points you earned = III. Tables and Graphs 28 Create a column chart using the data in Table A below. Group similar assignments into 3 groups in this orders: Quizzes, Exams, and Projects.
Fill the Quiz bars as follows: Quizzes = Red; Projects = Purple, and Exams = Navy Blue
Title the chart: Grades by Assignment Category.
Set the Y axis scale from 0 to 100 in 10s and bold the font.
The X axis should be grouped by assignment type, and bold the font.
Place graph on the next sheet. Table A Assignment Due Date Grade Quiz 1 Jan. 8 82 Quiz 2 Jan. 15 81 Quiz 3 Jan. 23 90 Quiz 4 Jan. 30 75 Quiz 5 Feb. 7 75 Quiz 6 Feb. 10 77 Project A Feb. 14 84 Project B Feb. 21 88 Midterm Feb. 25 72 Final Exam Feb. 28 70 Answer: Possible points = 5
Points you earned = 29 Table A:
Revenue by Department per Month
(in Thousands) Department: January February March April May June July August September October November December Accessories $18,943.43 $17,223.65 $21,945.78 $25,943.93 $28,520.55 $32,734.33 $29,543.21 $28,441.56 $23,910.52 $20,128.87 $35,912.39 $45,000.31 Clothing 16,302.03 19,443.43 21,884.73 17,990.69 18,396.49 19,449.40 20,471.99 24,110.85 26,551.07 19,337.63 21,023.45 28,945.66 Jewelry 35,944.34 32,680.64 41,640.64 49,226.84 54,116.70 62,112.77 56,057.84 53,966.80 45,369.23 38,192.88 68,143.02 85,387.50 The following two charts were created from the table above.
Which Excel function can change Graph I to Graph II with one key stroke? Answer: Possible points = 2
Points you earned =
Explanation / Answer
1) Part 1 answer is given below
2) Part 2 doesn't contains sufficient data: Graph isn't uploaded for answer the question.