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

8. Determine the molar mass of each of these compounds: a) carbon monoxide, CO(g) b) glucose, C6H1206(s) c) magnesium hydroxide, Mg(OH)2(s)
At the outbreak of the Civil War in 1861, pro-Union sentiment was strong in western Virginia, eastern Tennessee, and western North Carolina primarily because A
I need help Please help me
why sleeping is important for students???​
adjectives in tiny Natale quietly snuck through the empty hall way
Johnny is tapping his foot softly on the ground. When Melanie is standing up, she can barely hear his foot tapping. But if she puts her ear on the floor, the so
How to become a software tester?
Give two or more solutions to x< 29. Show why each value is a solution.
What minus 236 equals 358?
4. A network has N subscribers. Each subscriber is connected directly to all other subscribers. (a) What is the total number of lines L in the network? (b) Wh