Mt. Eden Computer Applications 1 |
||
Excel Warm-Up 8
INSTRUCTIONS:In Excel open a this workbook: My Transcript. Insert a new row to the top of your worksheet. In D1 type "My Transcript" set the type to Franklin Gothic Bold and 22 points. Select cells D1 through F1 and merge and center them. Color in that merged cell Aqua, Accent 5, Lighter 40%. Color cells A1 to C1 and G1 to I1 Orange, Accent 6, Darker 25%. In cell I2 type "Grade Points". Set all of the labels to Franklin Gothic Bold and 14 points. Set all of the grades in (the text in) column G to Bold, Right Justified and Orange, Accent 6, Darker 25%.
In cell I3 type this formula:
Distribute drag the formulas from the I3 to I43. In G44 type "TOTALS" set the type to Bold and Right Justified. In G45 type "GPA" set the type to Bold and Right Justified. Put the Total Class Units in cell H44, that is the SUM of the column H3 to H43. Put the Total Grade Points in cell I44, that is the SUM of the column I3 to I43. Put the GPA in cell I45, that is the Total Grade Points divided by the Total Class Units. Make a border to the under cells A2 through I2. Make a Double Border to the under of cells A43 through I43. In A45 type your name. In A46 type your period number.
Done!
WHEN YOU ARE DONE...Save your completed file in your folder in your Documents folder on your computer.TURN IN THE COMPLETED FILE THROUGH GOOGLE CLASSROM.
~~ This is worth 10 Participation points.~~ |
||
Back to Apps1 Main: CLICK HERE. |