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

How did the Jews of Poland differ from those in Germany and the rest of Western Europe
what is the average height of a person
How did Hitler intend to cut the sea lines between the United States and Europe? A. by concentrating the German forces near Midway B. by having German U-boats p
A 2.74 g coin, which has zero potential energy at the surface, is dropped into a 12.2 m well. After the coin comes to a stop in the mud, what is its potential e
A chemist makes 240. mL of zinc nitrate (Zn(NO) working solution by adding distilled water to 70.0 mL of a 2.50stock solution of zinc nitrate in water. Calculat
Given no other restrictions what are the domain and range of the following function f(x)=x^2-2x+2
What body part do cnidarians use to trap food? endoderm ectoderm polyp nematocyst
What is the least common multiple of 2x3x5x7 and 2x3x3x5
A students grade goes from a 95 to a 60 in 3 weeks. Calculate the students rate of grade change.
[tex]4b + 3 = - 9[/tex]​