Spreadsheets II Exercise: Marking Scheme

Topic Criteria Marks
File management and identification
  • file named excel2.xls
  • your name and the date appears
2
Formulas
  • totals column 
  • commission column 23,947.07
  • totals row 379,216
  • average row 63,203
  • high and low rows 78,167 and 48,305
  • range row 29,862
6
Cell formatting
  • row 5 highlighted and bold
  • A13:A19 highlighted and bold
  • A1 bold and larger
  • border around the table
4
Number formatting
  • formats: numbers=currencies, commissions=currencies, rates=percents
  • decimal places: commissions=2, rates=1, other numbers=0
3
Sorting and changes
  • sorted descending by commission; order of names correctly sorted (Mann to Taylor)
  • commission rate of Crown changed to 6%
2
Summary sheets
  • February sheet increases 1% over January (total 383,008)
  • March sheet increases 1% over February (total 386,838)
  • Totals sheet adds January to March (total 1,149,062)
3
Total 20