berry_jenee_test3b - Make the chart title color red font...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Do the followings: Student 0 No 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 The finished chart will look like below, save and send the file to drop box. 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Choose File -> Save As, and name it as your lastname_firstname_test3b . Merge cells C1 to H1, set font size 24 , bold , color light yellow , fill in color brown . Make all the columns auto-fit the width of the content. Calculate the " Total " column as the sum of test1 and test2 for all the students. Calculate the " Average " of test1 and test2 of all the students. Find the " Max " score of test1 and test2 of all the students. Find the " Min " score of test1 and test2 of all the students. Apply AutoFormat " 3D Effects 1 " to the cells C2 to H35. Make a bar chart " Chart1 " of the last name, test1 and test2 of all the students in a new sheet, put proper titles for the title and X, Y axises
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: . Make the chart title color red , font size 24 . Make the last names in the chart alignment as 75 degree . ts Grades First Name Last Name Test1 Test2 Total Nancy Apple 50 84 Tara Bert 80 83 Ann Corp 85 87 Logan Denison 84 78 Jenny Elpon 83 47 Lee Frap 87 77 Wen Grape 78 66 Sarah Hill 98 55 Lauren Ingro 96 89 Courtney Japro 90 45 Young Kalla 92 78 Tim Loop 45 16 Shannon Macintosh 78 26 Amber Mathews 16 83 Peter Nobel 26 87 Mark Normal 56 78 Cathy Opera 89 89 Teresa Pearl 89 47 Britney Perez 78 77 Susan Quarter 56 66 Tom Roberts 47 55 Diana Roger 77 89 Austin Stand 66 83 Jessica Stranger 55 87 Patricia Taylor 89 78 Karen Urb 99 45 Justin Van 88 78 Linda Watson 100 16 Phil Yang 95 26 Jim Zebra 59 48 Average Max Min...
View Full Document

This note was uploaded on 04/14/2008 for the course CSCI 1401 taught by Professor Staff during the Spring '07 term at Texas Woman's University.

Page1 / 2

berry_jenee_test3b - Make the chart title color red font...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online