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?