Spreadsheet Practice

1- Use a formula to calculate the numbers in the second column based on the numbers in the first column. In the first column the user inserts centimeters and the program calculates it in inches in the second column.

1 inch = 2.54 cm

2- Make a spreadsheet that converts Celsius degrees to Fahrenheit degrees. In the first column the user inserts Celsius and your program converts it to Fahrenheit in the second column.

^oF = 9/5(^oC)+32

3- Drawing charts

Make a table of the scores of 10 students in math, science, and reading and draw charts to

A- Compare the scores of individual students in math, science, and reading. (courses attached together, student names separate) see example1

B- Compare the performance of all students in math, science, and reading. (student names attached together, courses separate) see example 2

C- Compare the performance of male and female students in math, science and reading (genders attached together courses separate) see example 3

D- Compare the performance of male and female students in math, science and reading (courses attached together genders separate) see example 4

4- Use the attached table to calculate weighted average and letter grades. Homeworks are weighted 10%, quizzes 40%, and tests 50%. You may use the sample formulas at the end of this page.

5- (Optional) –

1- Use Excel to create an interactive chart like this. Please note what happens when you change the numbers. See attached my Interactive Excel. 2 extra points.

2- Visit the following list. Download a game template and make your own game. This is just for fun, no extra credit.

http://www.exceltrick.com/interesting/excel-games-free-download/

http://mashable.com/2014/08/27/microsoft-excel-games

*****For Help on Excel Click Here

Sample formula for weighted average

=(0.1*AVERAGE(B2,C2,E2,G2)+0.4*AVERAGE(D2,F2)+0.5*AVERAGE(H2,I2))

Sample formula to assign grade A,B,C,D, and F.

=IF(J2>=90,"A",IF(J2>=80,"B",IF(J2>=70,"C",IF(J2>=60,"D","F"))))