excel ch 4 review

Match it! Select the correct answer from the pull down...Good luck!

Which function allows you to search for a value, find it in a table array, then return information about that value

to arrange items in a table (or spreadsheet) according to alphabet (a to z), number (highest to lowest), or by key (multiple levels)

which of the following functions would be used to calculate a monthly loan payment?

text or graphic that, when clicked, displays related information elsewhere in the worksheet or in another file

which of the following arguments in PMT represents the amount you are borrowing?

if you wanted to find out how additional years of schooling can affect your income, you might want to make a _____________ that lists several years that will replace the column/row input value

which tab allows you to put a hyperlink in your excel spreadsheet?

Which of the following can be found under the Data tab, what if button?