Ask Question
29 March, 06:05

What does C4 refer to in the function = MATCH (C4, earnings,-1) ?

A. The search row

B. The named range

C. The lookup value

D. The match type

+3
Answers (1)
  1. 29 March, 06:08
    0
    The match type

    Explanation:

    This command is used to find the smallest value from lookyp array that is larger than look up value. lookup value in lookup array.

    This command is look like:

    =Match (Lookup Value, lookup array, match type)

    in given example

    lookup value is C4, Lookup Array is earnings and - 1 is match type.

    due to - 1,

    this function find the value from earnings that is smallest in array but larger than C4.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “What does C4 refer to in the function = MATCH (C4, earnings,-1) ? A. The search row B. The named range C. The lookup value D. The match type ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers