Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On the Summary sheet, in cell B 5 , enter a simple formula to reference the Cumulative GPA number from the GPA worksheet ( GPA
On the Summary sheet, in cell B enter a simple formula to reference the
Cumulative GPA number from the GPA worksheet GPA worksheet, cell B
Do the same for Total Units cell B Total Cost cell B and Total Debt cell B For
Total Debt, reference the Amount Owed number from the Loan sheet.
Compute the Average Cost Per Unit by dividing the Total Cost cell B by the Total
Units cell B
Compute Average Debt Per Unit in the same way.
In cell B enter a formula using a statistical function to calculate the most paid for
any semester. Reference cells B and B in the GPA sheet. Hint: You will need two
arguments.
In cell B enter a formula to calculate the average semester cost. Reference cells
B and B in the GPA sheet. Hint: You will need two arguments.
In cell F 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.
In cell F 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
tableABCDEFCollege Summary,,,GPA Goal Met?,Unit Requirement Met?,GPA,,,,GPA goal,Total Units,,,# of units required,Total Cost,,,,,Total Debt,,,,,Average Cost Per Unit,,,,,Average Debt Per Unit,,,,,Most Expensive Semester Cost,,,,,Average Semester Cost,,,,,
table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started