Answer:
The answer is "number of the column containing the return value".
Explanation:
In Excel, the "VLOOKUP" method is used to perform the vertical search by looking for both the value during the user table and retrieving the number of the index number location in the same row. It is a built-in function, which is classified as a Lookup or Reference worksheet function, and the following function can be defined as follows:
- In the 1st parameter, it is used to watch the value for the match.
- In the 2nd parameter, it is used to search the table.
- In the 3rd parameter, it is used as the column number representing the return value.
- In the 4th parameter, it is used to return only if the same match is found.
Answer: The amount of interest to be paid is $972
Explanation: This is gotten by firstly getting the amount of money to return per year without the interest which is $114400/10(years)= 11440
11440 is to be paid per year without interest. To get amount of interest is $11440*8.5/100 = $972 this is the amount of interest to be paid per year including in year 2.
Therefore, total amount of money together with interest to be paid each year and in year 2 = $11440+$972=12412.
Answer:
If this is a true or false I guess my answer is true?
Explanation:
