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

Sixteen students in a drama club want to attend a play.The ticket price is $35 for each student,and the transportation and meals for everyone will cost $960.To
what is the nth term for the following 7, 14, 23, 34,47, 62, 79
Is Darwin's Legacy Justified?
Read the excerpt from "A Modest Proposal" and the summary that follows. A very worthy person, a true lover of his country, and whose virtues I highly esteem, wa
Which graph does not represent
Kaylee's grandmother lives in europe and likes to read bedtime stories to her grandchildren when she visits. kaylee is almost 6, but her grandmother has not see
Simplify 2x 2 - y for x = 3 and y = -2. 20 14 16 10 i need help please
This type of power, generated from a non–renewable resource, has less of an impact on the environment then some of the other non–renewable resources used to gen
Calculate dy/dxif y = 4x3 + 3x2 + 2.
someone please help me me me