QUESTION $12$

If you had to look up a FICO credit rating from a cell in an Excel sheet, then compare a that credit rating to credit ratings in a table. Let's say that the credit ratings are listed in increasing order in the first column of the table with their corresponding interest rates in the second column of the table. The output of your function would be the interest rate of the FICO credit rating that you looked up originally. What function would you use?

SUM Function

PMT Function

CONCATENATE Function

VLOOKUP Function

IF Function

QUESTION $13$

One of the parts $($next to last$)$ of the Excel assignment consisted of creating a $$ table, which is basically an interactive table that enables you to qu group and summarize large amounts of data.