| Check through each of these items
before
submitting spreadsheets. |
| Errors that cause an instant F |
| Never do the math yourself! Always create Excel
formula to calculate (If you do the math yourself, and then
the number on which the formula depends changes, the cell which
was manually
calculated will not change.) |
| Amounts that do not make sense; LARGE errors that manual check
should have caught |
| Submitted just a formula sheet (missing
formatted values sheet) |
| Submitted just a formatted values sheet (missing formula
sheet) |
| Errors that cause
loss of 10 points |
| Used + for adding more than 2 contiguous
(touching) numbers rather than the correct SUM |
| Incorrect (or missing) formula use - incorrect
table for VLOOKUP |
| Missing chart(s) or Printed just a chart, rather than sheet with chart) |
| Chart inappropriate (100% bar or Bar of pie). |
| Chart has totals |
| Errors that cause
loss of 5 points: |
| Things to remember TO DO |
Things to Avoid Doing |
| Put commas on numbers over 1,000 |
Type a changeable value (such as tax rate) into a formula
when it was already in a cell on the sheet or should have been |
| All like number should have a like number of decimals,
either .00 or none |
Spelling error that would have been caught by Spell Check |
Formatted currency with decimals (pennies) ONLY for:
 | values UNDER $100
|
| transfer of funds |
|
$ on other than the first and last value in a column |
| printing repetitive formula (where rows are
exactly the same) |
| Use of SUM only when totaling values |
Blank rows or columns for spacing (rather
than modify column width or row height) |
| Center Labels on top row |
Column too small so entire formula not visible |
| Explain Conditional formatting |
Chart title missing or incomplete |
| Formula sheet printed as a selection of just values and
formula, not charts |
Chart has a very dark background or
Chart too small (much unused blank paper available) |
| |
Explode more than 1 slice or none in a pie chart |
| Formatted values printed with Gridlines and Row and
Column
labels |
Formulas printed without Gridlines and Row
and column labels (Headings - check box on Page
Layout Ribbon) |
| Header has a title for the sheet, student's
name,CIS100-section and date & time |
Chart missing or incorrect x-value labels |
| Filename and path on Footer in a tiny font |
Labels very long -should be on 2 lines (using
Alt+Enter) or not centered |
