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 happens to energy over the course of a reaction?
Who would have been MOST LIKELY to support and help poor women in major urban areas?
Write a rule using numbers to find the number of squares in any figure in the pattern
Which regions were annexed by hitler as england and france practiced their policy of appeasement? select all that apply.
(x+y^–2xy)(2x^2–y^2+xy)
Use ratio language to describe the relationship between 2 dogs and 1 cat
Which event preceded the revolutions of 1989? solidarity candidates were elected in poland. hungary implemented a free market economy. communist rule ended in c
In the triangle below, what ratio is tan θ? 12 over 13 5 over 13 5 over 12 13 over 5
1377/8 in simplest form Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
NEED HELP QUICK PLZ! 51 Points!