Please help with ALL questions

What does a MATCH function do$?$

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

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

C$.$ Returns a "true" or $""\text{'}$false$"$ depending on whether two cellls match or not

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

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

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

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

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

D$.$ The range of the index function

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