Step 13 Record your grade #'s.

Record your Grades

Your're Done!!!!!

Excel
Step 9.

Is Blank Rule

Watch the video
or
follow the
Step by Step
Instructions.

Change the cell color of Blank Cells to White.

2:24 mi

Excel gives Blanks cells a zero value, therefore,
you need to add an Is Blank formula so that the cell that
Is Blank will be white.

Click for the Step by Step Instructions.

Excel
Step 10

Conditional Formatting

Watch the video

or
follow the
Step by Step
Instructions.

Step 10)

Select the whole chart and input the
Conditional Formating
for the GPA Ranges.

Step by Step Instructions

One more step in Part 2 to complete.
Scroll down to Step 10.

Tell Ms. Church that you are ready for Part 2 to be graded.

4. Edit ALL Formulas to include Row 12.

Step by Step to....

Edit the formula to include the new row.

1. Put a Number in Cell B12 then Click on cell B13.

2. See below for the example.
Put your cursor in the B3:B11 area of the formula.
Once you click the Column will be highlighted.

3. Now drag down the "Skinny Blue +" to include the cell in your formula.

4. Press Enter

5. Click Hold Drag the "Skinny Green +"in Cell J13 to the left
to copy the formula into the other cells in the row.

6. Press Enter

7. Repeat Steps 1-5 for Cell J3 and the rest of Column J

5. Edit ALL Conditional Formatting to include Row 12.

Tell Ms. Church that you are ready for for your 4 G.P.A. Charts to be graded.
GPA Part 1 GPA Part 2 GPA Part 3