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

Which equation best represents the line in the graph
Can anyone explain how to solve these problems?
This circle graph shows the results of a survey that asked 80 people which method of transportation they use to get to the city park How many people take the bu
How to cultivate land more effectively
What number needs to be added to 4 and 9 so that the ratio of the first number to the second becomes 2:3?
Which intensive pronoun would emphasize the subject band members in the sentence? himself itself theirselves themselves.
The DVD player has lost some popularity with the increase of streaming videos. In order to decrease their inventory of DVD players, a retail store puts their $8
what does cos mean in math?
What is the measure of angle DAB?
Identify the triangles that are similar by the AA similarity theorem. explain how you know that the triangles are similar.