What type of result does the MATCH function, when used on its own, return? It returns the lookup value located in a specific location. It returns a value that is the same as the lookup value. O It returns the cell reference of the lookup value. Olt returns the relative position of a lookup value, either as a row or column number, within the selected array

Why would a programmer use the logical operator and in an if statement? a: when an action is to be taken that requires both conditions to be falseb: when an action is to be taken that requires both conditions to be truec: when an action is to be taken that requires the first condition to be falsed: when an action is to be taken that requires the second condition to be truei took the test and the answer is b.