zachlawrence97
zachlawrence97 zachlawrence97
  • 02-12-2019
  • Computers and Technology
contestada

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

Respuesta :

l135134 l135134
  • 14-12-2019

Answer:

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.

Answer Link

Otras preguntas

will mark brainliest for correct answerr
How to convert 1/6 + 21/3
What is the answer to this?
4 Group the statements about lawmaking according to the branch of government they describe. Executive Both Legislative Vetoes bill to prevent it from becoming l
Solve each system by substitution. Show your work. 1) y = -3x - 1y = 3x - 72) y = 7x + 16y = 4x + 103) y = -3x - 5y = 8x + 174) y = -2x + 4y = x + 15) y = 6x +
what is the decimal value for the jump control?
Giving Brainliest and points if you help me answer this question correctly! Describe the shape that is formed by the cross section: A. an ellipse parallel to th
Which of the following is one reason that the election of 1860 resulted in a win for Abraham Lincoln? A. The Constitutional Union Party carried the West Coast
HAI PLEASE HELP!!!!!!!!!
Select the correct answer. Jessica wants to find more information about the effects of sports on the mental health of teenage girls. What would be a good primar