22C:005 Problem Solving and Computing
NAME______________________
SECTION______________________
QUIZ 6 (October 20th )
1. What's a portfolio?
2. What numeric value will be displayed for the cells that contain the following
formulas? Assume spreadsheet cell values of: A1=10, B1=2, C1=5.
=A1+B1*C1 ________________
=A1/B1*C1 ________________
3. Indicate the result of copying the formula contained in cell D2 to cells D3 and
D4, using the fill-handle. (Write the formulas in cells D3 and D4)
A B C D
1Student Test1 Test2 Average
2 Costa, Frank 70 80 =(B2*$B$6)+(C2*$C$6)
3 Ford, Judd 70 85
4 Grauer, Jessica 90 80
5
6 Test Weights 40% 60%