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 is 3x-4y=4 in linear equations
Which emotional force played a large role in the unification of Italy and Germany? A. expressionism B. pacifism C. dualism D. nationalism
Which type of joint allows your legs and arms to swing in almost any direction
-z2-z-19 Z=-7 what is the answer please
what is a perimeter, but each unit is 1 centimeter
On Monday, it took Helen 3 hours to do a page of science homework exercises. The next day she did the same number of exercises in 2 hours. If her average rate o
Which of the following electromagnetic waves are listed in the correct order from longest wavelength to shortest wavelength? A. infrared, ultraviolet, visibl
How do you do X over 4 =-8?
Jenny spent 35 minutes doing research on the Internet. She finished at 7:10p.m. At which time did Jenny start her research?
In the 1850s, the North and South strongly disagreed about the production of cotton. the growth of commerce. the diversification of industries. the spread of sl