________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field

Marking a word or phrase for indexing can only mark one instance of the word or phrase in the document

Indicate whether the statement is true or false

What type of match would the following function return when the lookup array is sorted in descending order?

=MATCH(A3,B7:B53,-1 ) A) The match would be the smallest value in the list without going over the value of A3. B) The match would be the greatest value in the list that is less than or equal to the value of A3. C) The match would be an exact match to A3. D) The match would be A3-1.