Cell F3:

Using the AVERAGE function, create a formula to determine the average GPA of the first student (assume that all four years are wieghted equally).

Use the Fill command to put similar formulas in cells F4 - F22.

Cell G3:

Add an IF/THEN (conditional) statement to determine if the first student will graduate.

=IF(F3>=1,"Graduation", "No Graduation")

If the number in cell F3 is greater or equal to 1, then Graduation will be displayed in cell F3. If the number is less than 1, then No Graduation will be displayed.

Use the Fill command to put similar formulas in cells G4 - G22.

There are three parts of an Excel IF/THEN statement:

1. What is being checked.
2. What to show if true.
3. What to show if false.

For example: =IF(A1>25, "Bigger than 25", "Not Bigger than 25")

If the number in cell A1 is larger than 25 then Bigger than 25 will be displayed in the cell. If the number is not larger than 25 then Not Bigger than 25 will be displayed in the cell.

Cell H3:

Add an IF/THEN (conditional) statement to determine if the first student will be allowed to walk in the graduation ceremony. A GPA of 2.0 is required for this.

The formula will be very similar to the one used in G3.

Cells A1 - H1: Merge & Center

Format: Calibri, 24 pt., bold, dark fill color, light text color.

Cells A2 - H2:

Format: Calibri, 12 pt., bold, dark fill color, light text color, wrap text, center alignment, middle alignment.

Resize the columns as necessary so no text is chopped off.

Cells A3 - H22:

Format: Fill the cells with alternating light fill colors, leave the text black.

Cells B3 - H22:

Format: Calibri, 11 pt., center alignment

Cells A3 - A22:

Format: Calibri, 11 pt., bold.

Cells B3 - F22:

Use the Increase Decimal / Decrease Decimal buttons to format all the numbers to two decimals.

Cells A1 - H22:

Add an "All Borders" border.

[Insert Tab]

Select cells A2 - A22.

Press and hold the <CTRL> key.

Select cells F2 - F22.

Both columns of cells should be selected. If they are not, reselect the cells.

Create a "Clustered Column" graph.

Delete the "Total GPA" legend on the right.

Position the chart so the corners are in cells A23, H23, A40 & H40

[Chart Tools / Design Tab]

Select a Chart Style of your choice.

Select the chart area by clicking on the blank area near an edge, or on the edge of the chart itself.

Change the font to Calibri, 12 pt., bold.

When you are done the document should look similar to the example on the right:

Save your spreadsheet in your Excel folder as Excel Project 12