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 |