On the Summary sheet, in cell B$5,$ enter a simple formula to reference the

Cumulative GPA number from the GPA worksheet $($GPA worksheet, cell B$5).$

$21.$ Do the same for Total Units $($cell B$6),$ Total Cost $($cell B$9),$ and Total Debt $($cell B$3).$ For

Total Debt, reference the Amount Owed number from the Loan sheet.

$22.$ Compute the Average Cost Per Unit by dividing the Total Cost $($cell B$8)$ by the Total

Units $($cell B$6).$

$23.$ Compute Average Debt Per Unit in the same way.

$24.$ In cell B$14,$ enter a formula using a statistical function to calculate the most paid for

any semester. Reference cells B$17$ and B$23$ in the GPA sheet. Hint: You will need two

arguments.

$25.$ In cell B$16,$ enter a formula to calculate the average semester cost. Reference cells

B$17$ and B$23$ in the GPA sheet. Hint: You will need two arguments.

$26.$ In cell F$1,$ enter a formula using the IF function to determine if the student met her

GPA goal. Display "yes" if the goal was met and $"$no$"$ if it was not.

$27.$ In cell F$2,$ enter a formula using the IF function to determine if the student met her

unit goal. Display "yes" if the goal was met and $"$no$"$ if it was not.E$13$

$f_x$

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$],[1,$College Summary,,,GPA Goal Met?,$],[2,,,,$Unit Requirement Met?,$],[3],[4],[5,$GPA,,,,GPA goal,$3\mathrm{.}5],[6,$Total Units,,,# of units required,$125],[7],[8,$Total Cost,,,,,$],[9,$Total Debt,,,,,$],[10],[11,$Average Cost Per Unit,,,,,$],[12,$Average Debt Per Unit,,,,,$],[13],[14,$Most Expensive Semester Cost,,,,,$],[15],[16,$Average Semester Cost,,,,,$],[\{$

$\backslash$table$[[17],[18]]\}],[],[19,,,,,,]]$