Package deal
WGU C268 Spreadsheets Bundle
WGU C268 Spreadsheets Bundle
[Show more]WGU C268 Spreadsheets Bundle
[Show more]Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20-C67 in the "Payment" column are populated with the payment amount from cell C15. [34 Points] - answer =PMT(C13/12,C12,C11) 
 
...
Preview 2 out of 11 pages
Add to cartCalculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20-C67 in the "Payment" column are populated with the payment amount from cell C15. [34 Points] - answer =PMT(C13/12,C12,C11) 
 
...
Adds the individual numbers or the numbers included in the range(s). - answer SUM() 
 
Counts the number of cells in a range of cells that contain numbers. - answer COUNT() 
 
Counts the number of cells in a range of cells that are not blank - answer COUNTA() 
 
Calculates the simple average of a se...
Preview 2 out of 7 pages
Add to cartAdds the individual numbers or the numbers included in the range(s). - answer SUM() 
 
Counts the number of cells in a range of cells that contain numbers. - answer COUNT() 
 
Counts the number of cells in a range of cells that are not blank - answer COUNTA() 
 
Calculates the simple average of a se...
Relative Cell Reference - answer Cell reference that automatically updates when a formula is pasted into a new cell 
 
Absolute Cell Refernce - answer Cell reference that remains constant when a formula is pasted into a new cell 
 
$ - answer Used to make a cell absolute. Goes in front of the part y...
Preview 2 out of 5 pages
Add to cartRelative Cell Reference - answer Cell reference that automatically updates when a formula is pasted into a new cell 
 
Absolute Cell Refernce - answer Cell reference that remains constant when a formula is pasted into a new cell 
 
$ - answer Used to make a cell absolute. Goes in front of the part y...
what are the arguments for the FV function - answer the interest rate charged or earned on the investment (rate), the number of payments to be paid or earned (nper), and the payment amount (PMT). 
 
which function is used to calculate the future value for a loan or investment after all of the paymen...
Preview 1 out of 3 pages
Add to cartwhat are the arguments for the FV function - answer the interest rate charged or earned on the investment (rate), the number of payments to be paid or earned (nper), and the payment amount (PMT). 
 
which function is used to calculate the future value for a loan or investment after all of the paymen...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller BillRanker. Stuvia facilitates payment to the seller.
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
80467 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now