COMPUTER LITERACY CHALLENGE EXAM
SAMPLE DATASHEET SOLUTIONS
|
Sample Datasheet Problem #1 Solution |
| INCOME |
January |
February |
March |
AVERAGE |
TOTAL |
| Gardening |
$10.27 |
$13.38 |
$8.65 |
=AVERAGE(B4:D4) |
=SUM(B4:D4) |
| Allowance |
$12.74 |
$11.97 |
$10.55 |
=AVERAGE(B5:D5) |
=SUM(B5:D5) |
| Babysitting |
$0.00 |
$22.75 |
$35.50 |
=AVERAGE(B6:D6) |
=SUM(B6:D6) |
| TOTAL INCOME |
=SUM(B4:B6) |
=SUM(C4:C6) |
=SUM(D4:D6) |
=SUM(E4:E6) |
=SUM(F4:F6) |
|
|
|
|
|
|
| EXPENSES |
January |
February |
March |
AVERAGE |
TOTAL |
| Movies |
$9.50 |
$21.75 |
$22.50 |
=AVERAGE(B10:D10) |
=SUM(B10:D10) |
| Compact Discs |
$22.87 |
$0.00 |
$14.72 |
=AVERAGE(B11:D11) |
=SUM(B11:D11) |
| Lunches |
$10.51 |
$6.49 |
$8.25 |
=AVERAGE(B12:D12) |
=SUM(B12:D12) |
| TOTAL EXPENSES |
=SUM(B10:B12) |
=SUM(C10:C12) |
=SUM(D10:D12) |
=SUM(E10:E12) |
=SUM(F10:F12) |
|
|
|
|
|
|
| PROFIT/LOSS |
=B7-B13 |
=C7-C13 |
=D7-D13 |
=E7-E13 |
=F7-F13 |
|
Sample Datasheet Problem #2 Solution |
|
A |
E |
F |
G |
| 1 |
MY RECORD-KEEPING SPREADSHEET |
| 2 |
|
|
|
|
| 3 |
INCOME |
AVERAGE |
TOTAL |
|
| 4 |
Allowance |
$11.75 |
$35.26 |
|
| 5 |
Babysitting |
$19.42 |
$58.25 |
|
| 7 |
TOTAL INCOME |
$41.94 |
$125.81 |
|
| 8 |
|
|
|
|
| 9 |
EXPENSES |
AVERAGE |
TOTAL |
|
| 10 |
Movies |
$17.92 |
$53.75 |
|
| 11 |
Compact Discs |
$12.53 |
$37.59 |
|
| 12 |
Lunches |
$8.42 |
$25.25 |
|
| 13 |
TOTAL EXPENSES |
$38.86 |
$116.59 |
|
| 14 |
|
|
|
|
| 15 |
PROFIT/LOSS |
$3.07 |
$9.22 |
|
|
Sample Datasheet Problem #3 Solution |
) |
|