Spreadsheets I Exercise: Marking Scheme

Topic Criteria Marks
File management and identification
  • file named excel1.xls
  • your name appears
  • the date appears
3
Formulas
  • total assets uses sum
  • total liabilities uses sum
  • total quarters uses sum
  • balance row uses differences
  • total balance is 190,000
5
Number formatting
  • all numbers formatted as currencies
  • no decimal places
2
Title formatting
  • titled Balance Sheet
  • title merged and centered
  • larger and different font
3
Other formatting
  • column A bold
  • column A wide enough to see all text
  • balance row highlighted in yellow
  • 1-4 and Total centered 
  • date formatted as a date
5
Other
  • no other additions or deletions
  • correct case, punctuation, spacing, etc.
2
Total 20