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

What was one of the basic features of early civilizations
Simon makes 8 towers of 10 blocks each. Ron makes 9 towers of 10 blocks each. How many blocks did they use?
Can someone help me with questions 38, 40 and 42? please and thank you :)
Divide using base ten blocks 195divided by 13
a baseball pitcher has pitched 12 2/3 innings
1,000 kilograms equals 1 _______?
Do animal cells have cell walls?
Order the numbers from greatest to least 6.002 6.200 6.020
samuel needs to estimate the product of 23 * 395. explain two different methods Samuel can use to estimate.
4. is the number written in scientific notation? if not, explain. 5.1 x 10^-8 a) yes; the number is written in scientific notation b) no; the first factor is no