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

Whats the answer for 0.4r When r=6 the problem is evaluate expressions? Please asap
There is 27 campers. This is nine times as many as the number of counselors. how many counselors are there?
please I need help on 2 multiple choice question about a book Angela's Ashes. 1—In Angela's Ashes what sort of treatment does Frank receive for his typhoid feve
Where are slides placed on a microscope?
The area of a rectangle is 24,396 square centimeters. if the width is 38 centimeters, what is the length. explain please I don't get it
Why can't you use the Zero-Product Property to solve (x-1)(x+3)=1?
Is 119 a prime or composite number? If is composite, what prime numbers are factors of 119?
What did African Americans gain during WWII?
The scientific notation of 2500?
How to solve. -3(4r-8)= -36