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

The human heart has two chambers. True False
ROMAN NUMERALS Directions: In Roman numerals write, answer the following: 1. The year 1996: 2. 250 plus 31- 3. 497 minus 312- 4. The year 1776: 5. The year 200
Mary finishes a marathon at a speed of 2 m/s. If her acceleration period is 4 seconds, then what is her average acceleration (in m/s?)?
Identify this structure. How did the architect use line when creating this structure?
martin luther and thomas more both were asked to recant and both refused why do you think their fates were different?
inside the human body how can people do backflips
How do u do this? pic is under
The surface area of the prism is ​
2x2 − 2z4 + y2 − x2 + z4 if x = −4, y = 3, and z = 2.
Evaluate. 4.2 - 6 divided by 2 + 3