Grading Rubric – Excel 2007
Chapter 3, Make It Right
|
Class: |
CT 183 H20 |
|
Professor: |
Mrs. Lynn |
|
Filename: |
Make It Right 3-1 e-MusicPro.com Annual Projected Net Income Complete |
|
Description |
Pts |
Your Score |
|
The formula in cell C8 should be changed to an absolute cell reference (cell B9), then copied to cells C4 and C5 to correct those cells. (Use Fill Without Formatting to preserve the current formats for the copied cells) |
15 |
|
|
The IF function in cell D3 should be corrected and the corrected formula copied to cells D4 and D5. (Use Fill Without Formatting to preserve the current formats in the copied cells) |
15 |
|
|
The formula in cell E3 should be changed to an absolute cell reference (cell B11), then copied to E4 and E5. (Use Fill Without Formatting to preserve the current formats in the copied cells. |
15 |
|
|
Assumptions table is moved to A1:B4 (above the worksheet. Formulas that reference these moved cells should not be affected by this move.) |
10 |
|
|
Path & Filename code are correct |
10 |
|
|
TOTAL POSSIBLE POINTS: |
65 |
|
| YOUR SCORE: _______________ |