TrueBones do not change position
It could be D.all of the above because alcohol could possibly do that to anyone
The formula that uses relative cell references is F18+F19/2.
A relative cell reference will adjust as a formula is copied because it is actually working by calculating what the formula is in relation to the cell where the formula is. For example, if you copied this formula down one row it would adjust to F19+F20/2. This is opposite of an absolute cell reference like you see in the first example. The cell will always reference cell A10, regardless of where it is copied to.
Answer:
We need to find the monthly payment.
Hence, we need to make a Loan Worksheet, and in cell c9 we need to enter a PMT function for calculating the monthly payout required for the Altamonte Springs 2018 Loan facilities. We also need to make sure that the function gives us a positive answer.
And the B5 and B6 are considered as the absolute references. The interest rate is 4.5%, and the payment numbers are 12. And the Altamonte facilities cost is $16450.95
And hence the formula will be:
=-PMT($B$5,$B$6,B7)
Explanation:
Please check the answer section, and attachment.
