Spreadsheet Practice!

If you don't know the answers, try these in Excel!

	A	B	C

1	100	50	=$A$1+B1

2	200	100

3	300	150

Assume the formula in cell C1 is entered into cells C2 and C3.
What will be the new formula in cell C3?  What will be the new
value in cell C3?


      	A       B       C

1     Name	Score

2     David     100

3     Ngoc	90

4     Alice	80

5     Ralph      0

6

Assume we want to calculate an average in cell B6.  What would
the formula be?  Will Ralph's score be included?  What if we
had left Ralph's score blank?


What cells would we select to sort this spreadsheet?

If we wanted to put "warning" in column C for any student whose
score was below 60 and "OK" otherwise, what formula would go in
cell C2?