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

a business employs 50 workers at the start of the year, but then some employees quit or are fired. after that, the business has 24 employees
Janine is considering buying a water filter and a reusable water bottle rather than buying bottled water. Will doing so save her money? How much water does Jani
3(a+9/12)=3(a+7/12)+ (?)
A(n) __________ is a classic example of a first-degree burn.
why did the public lose trust in the federal government
What is the most important reason for citing a source when quoting it directly?
Which is a warning sign that a person may be an alcoholic? A. The person drinks alone. B. The person promises to quit but does not. C. The person has blackout p
This is the repeating structural unit that forms RNA and DNA.
During which phase is the dna duplicated
Which global wind is responsible for most of the weather in the united states?