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

At the supermarket you can fill your own gummy bear container. A customer buys 12 oz of gummy bears for $5.40. How much does bears cost per ounce?
the equation of a straight line is 3x-2y+8=0. find the y-intercept of the line
Rachel took a two day road trip last weekend. She drove 65 miles less on Sunday than she did on Saturday. If twice the miles was driven on Sunday is 373 more th
The area of a triangle abc is 4√2 m²
Cellular reperation occurs within the what of a cell
9. Jamie ha ahorrado $ 42 del dinero de su asignación para comprar libros. Si compra 5 libros a d dólares por libro, le quedarán 42 5d de su asignación. ¿Cuánto
Why did some Americans have a strong economic interest in Cuba ?
select all the coordinate pairs that are solutions to y= 2x^2 +3x +1
how are immigrants leaving Pakistan what mode if transport are they taking
what is the equation to this pattern