"What part of an INDEX,MATCH,MATCH function needs only its columns locked?

A$.$ The lookup array of the first match functio

B$.$ The lookup value of the first match function

C$.$ The lookup value of the second match function

D$.$ The range of the index function"

"What parts of an INDEX,MATCH,MATCH function needs double$-$locked?

A$.$ The match types of the match functions

B$.$ The lookup values of the match functions

C$.$ Any multicell range$/$array

D$.$ None of the above"

"What part of an INDEX,MATCH,MATCH function needs only its rows locked?

A$.$ The lookup array of the first match function

B$.$ The lookup value of the first match function

C$.$ The lookup value of the second match function

D$.$ The range of the index function"

"What does a MATCH function do$?$

A$.$ Returns a cell that matches the lookup value

B$.$ Returns an array of cells only if it contains the lookup value

C$.$ Returns a $""$true$""$ or $""$false$""$ depending on whether two cells match or not

D$.$ Returns an integer that matches the position a lookup value has in a lookup array"