Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with the formulas with this excel worksheet. payment to display as a negative number. In cell B 1 0 , enter a
I need help with the formulas with this excel worksheet.
payment to display as a negative number.
In cell B enter a formula to display the current date just the date, not the date
and time
Enter a formula in cell B to estimate the date of the last loan payment. Take the
number of years to pay cell B times and add that to the date of the first
loan payment cell B
Enter a formula in cell B to estimate the number of days until the loan is
Complete the Summary sheet information.
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.
Before finishing the project, check each worksheet for errors.
Save and close the workbook.
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