EXCEL CLASS 1 SPREADSHEET TOUR COLUMN HEADINGS AIV –

Excel Class

Compute average for Quiz 1
=(b2+b3+b4)/3
Format B5
Copy cell B5 to cell C5
Note how formula was updated automatically
Instructor made an error in correcting the test
Update C2 to 88
Note how average updated as well
Compute average for Quiz 2
=sum(d2:d4)/3
Format using toolbar
Copy cell D5 to E5
Note how formula was updated automatically
Compute average for Quiz 3
=sum(f2:f4)/count(f2:f4)
Copy cell F5 to G5 and H5
Note how formula was updated automatically
Insert row above Row 1 for grading weight
Quiz 1 – 0.10
Test 1 – 0.25
Quiz 2 – 0.10
Test 2 – 0.25
Quiz 3 – 0.10
Final Exam – 0.15
Class Participation – 0.15

Highlight B1:H1
Format using Percentage with 0 decimal places
Compute the Final Grade for cell I3
=(b1*b3)+(c1*c3)+(d1*d3)+(e1*e3)+(f1*f3)+(g1*g3)+(h1*h3)
Copy cell I3 to cell I4
#VALUE! – explain
Fix cell I3 formula
=($b$1*b3)+($c$1*c3)+($d$1*d3)+($e$1*e3)+($f$1*f3)+($g$1*g3)+($h$1*h3)
Copy cell H6 to cell I6
Create a chart of the grades
Highlight I3:I6
Insert Chart…
Column type, Next
Click on Series tab
Click on Spreadsheet icon in Name field
Click on I2 (Final Grade)
Click on Spreadsheet icon in Name field again
Click on Spreadsheet icon in Categories (X) Axis Labels
Select A3:A6
Click on Spreadsheet icon in Categories (X) Axis Labels again
Next
Finish
http://helpdesk.rpi.edu/update.do?catcenterkey=88 or http://www.rpi.edu/dept/arc/web/software/excel/