| Save document with specified file name. |
5 |
| Document not saved wth new name as directed (0) |
Document saved with new file name as directed (5) |
| Work in new document file |
2.5 |
| Work not completed in new file (0) |
Work completed in new file
(2.5) |
| Delete specified column |
2.5 |
| Specified column not deleted (0) |
Specified column deleted (2.5) |
| Insert blank row at specified point |
2.5 |
| Blank row not inserted as directed (0) |
Blank row inserted as directed (2.5) |
| Insert a function or formula as directed to obtain correct number |
10 |
| Function or formula not inserted as directed (0) Formula/function inserted as directed (5) |
Function or formula correctly inserted to obtain correct number (10) |
| Copy function or formula to new cell(s) |
2.5 |
| Function or formula not copied to new cell(s) as directed (0) |
Function or formula copied to new cell(s) as directed (2.5) |
| Merge and center specified cells |
5 |
| Cells not merged and centered as directed (0) |
Cells merged and centered as directed (5) |
| Make specific text bold |
2.5 |
| Specified text not bold (0) |
Specified text is bold (2.5) |
| Format outline borders around cell(s) |
2.5 |
| Outline borders not formatted as directed (0) |
Outline borders formatted around specified cell(s) as directed (2.5) |
| Adjust column and row heights and widths to fit contents |
2.5 |
| Column & row heights and widths not fitted contents as directed (0) |
Column & row heights and widths fitted contents as directed (2.5) |
| Use cell references to populate specified cells with data |
10 |
| Cell references not used to populate specificied cells with data
(0) |
Cell references used to populate specificied cells with data (10) |
| Insert function or formula as directed to obtain correct number |
10 |
| Incorrect numbers obtained, or correct numbers obtained without the use of formulas or functions (0) Correct numbers obtained using formulas or functions, but not as directed (5) |
Function or formula correctly inserted to obtain correct number (10) |
| Copy function or formula to new cell(s) as directed to obtain correct number(s) |
2.5 |
| Function or formula not copied to new cell(s) as directed to obtain correct number(s) (0) |
Function or formula copied to new cell(s) as directed to obtain correct number(s) (2.5) |
| Format cell(s) to include 1000s comma separator OR to set decimal places |
5 |
| Cell(s) not formatted to insert 1000s comma separator OR to set decimal places as directed (0) |
Cell(s) correctly formatted to include 1000s comma separator OR specified number of decimal places as directed (5) |
| Create the designated type of chart using specified data |
5 |
| Designated type of chart using specified data not created as directed (0) |
Designated type of chart using specified data created as directed (5) |
| Create chart title |
2.5 |
| Chart title not created as directed (0) |
Chart title created as directed (2.5) |
| Place chart |
2.5 |
| Chart not placed as directed (0) |
Chart placed as directed (2.5) |
| Place chart legend |
2.5 |
Legend not placed as directed (0) |
Legend placed as directed (2.5) |
| Label segments |
2.5 |
| Segments not labeled as directed (0) |
Segments labeled as directed (2.5) |
| Change page orientation |
5 |
| Page orientation not changed as directed (0) |
Page orientation changed as directed (5) |
| Scale document to fit on one page |
5 |
| Document not scaled to fit on 1 page (0) |
Document scaled to fit on 1 page (5) |
| Change margins |
2.5 |
| Margins not changed as directed (0) |
Margins changed as directed (2.5) |
| Insert specified header or footer |
5 |
| Header or footer not inserted as directed (0) |
Header or footer inserted as directed
(5) |
| Print worksheet |
2.5 |
| Worksheet not printed as directed (0) |
Worksheet printed as directed (2.5) |
| Proofread |
- |
| Subtract 0.5 point for each uncorrected error |
| Completed within 2 hrs |
- |
| Subtract one point for every minute over 2 hours |
| Total points |
100 |
| Scoring Rubric