If you want to find the closest possible match, what do you enter in the Range_lookup text box in the Function Arguments dialog box?

All of the following statements are TRUE regarding the INDIRECT function EXCEPT:

A) The cell reference in the INDIRECT function reroutes to a new reference. B) The INDIRECT function has three arguments. C) The INDIRECT function can change a text string within a cell to a cell reference. D) The INDIRECT function's first argument is usually a cell reference or a text string.

The process of joining two strings string is called __________.

Fill in the blank(s) with the appropriate word(s).