$41.$ If we need to retrieve data from a particular record using an unique identifier we should use

$2.$ When pulling a number from a text string using the LEFT function, the result will be stored as a $?$

$3.$ Identify the correct implementation of an INDEX MATCH MATCH set of functions that can be copied down without error?

$4.$ If you only need to retrieve data from one column, which INDEX MATCH structure could you use without error?

$5.$ If you omitted the match type $=0$ from a MATCH function, Excel defaults to

$6.$ A MATCH function will only allow which of the following type of array

$7.$ The match type $=0$ in a MATCH function indicates

$8.$ What is one limitation of the VLOOKUP function

$9.$ What function should you use to change a number stored as a text value into a number?

$10.$ What function should you use to check to see if a data value is stored as a number or a text value?