| COMPUTER LITERACY TEST - SAMPLE DATASHEET PROBLEM |
| You will create a datasheet that will show your income sources
and expenses for a three-month period. You will also compute averages
for the three-month period, as well as totals for the income and
expenses for each month Finally, you will calculate the “profit/loss”
for each month. The “profit/loss” is calculated by subtracting
Total Expenses from Total Income. It should be a positive value
(profit) if you have more Income than Expenses and a negative
value (loss) if you have more Expenses than Income. You must use
formulas and/or functions to do the calculations where the question
marks are located. |
- 1. Set up datasheet as follows: See Datasheet Solution 1
Size & Style:
Datasheet title, column and row titles: Times, 10 pt. bold
Numbers - Times, 10-pt. plain.
Datasheet title, Income, Total Income, Expenses, Total Expenses,
Profit/ loss, Average and Total should be in all caps.
All other row and column titles should have only their first letter
capitalized.
Format monetary values to include commas, show dollar signs and
round amount to the nearest cent.
Align columns as follows: First column on left - align left. All
other columns - align right.
Adjust column width to accommodate required entries and fit on
one page in landscape orientation when row and column headings,
grid and formulas are shown.
Leave one blank row after datasheet title, Total Income and Total
Expenses.
Look over your work carefully to make sure you do not have any
spelling, typographical, formatting, punctuation, or spacing errors.
All cells with question marks must display correctly calculated
formulas used to obtain numbers.
Print, using one page only, without row headings, without column headings and with gridlines.
|
- 2. Sort the Income data alphabetically. See Datasheet Solution 2
Show all Expense records but only the Income records having a
Total value of more than $35.00.
Show only the Item, Average and Total columns (fields).
All cells with question marks must display numbers.
Print, using one page only, with row headings, with column headings and without gridlines.
|
- 3. Show all fields and all records. See Datasheet Solution 3
Create a column (clustered) chart showing Income in January, February and March of all the items (not Total Income).
The chart should be titled INCOME.
The x-axis (along the bottom) should be titled JOB and should
show Allowance, Babysitting and Gardening.
The y-axis (along the side) should be titled DOLLARS and should
show dollar amounts.
All three titles should be in all caps.
Print the chart.
|
| MY RECORD-KEEPING DATASHEET |
|
|
| INCOME |
January |
February |
March |
AVERAGE |
TOTAL |
| Gardening |
$10.27 |
$13.38 |
$8.65 |
? |
? |
| Allowance |
$12.74 |
$11.97 |
$10.55 |
? |
? |
| Babysitting |
$0.00 |
$22.75 |
$35.50 |
? |
? |
| TOTAL INCOME |
?
|
?
|
?
|
?
|
?
|
| M Color MM |
|
|
|
|
|
| EXPENSES |
January |
February |
March |
AVERAGE |
TOTAL |
| Movies |
$9.50 |
$21.75 |
$22.50 |
? |
? |
| Compact Discs |
$22.87 |
$0.00 |
$14.72 |
? |
? |
| Lunches |
$10.51 |
$6.49 |
$8.25 |
? |
? |
| TOTAL EXPENSES |
?
|
?
|
?
|
?
|
?
|
| TOTAL |
|
|
|
|
|
| PROFIT/LOSS |
?
|
?
|
?
|
?
|
?
|
|
| Sample Datasheet Solutions |
|