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

Make the following conversion. can someone please explain how to do this 56.32 kL = _____ L 0.056320 0.56320 5,632 56,320
One-celled organisms, such as bacteria, can reproduce very quickly using the process called _____. a. budding b. binary fussion c. cytokinesis d. duplicatio
Which of the following was the main spoil in the spoils system?
Which is most likely a molecule in a wall-filling material? C6H6 Na6Ba6 NeNa HC
What are the levels of organization from smallest to largest?
On one of the day you went to the gym, the ratio of men to women was 3 : 2. If 120 men used the gym, how many women were there?
How do i do this please help
Why did the French invade the German industrial region of the Ruhr in 1923
When you display food in ice, the food must:?
Stuart is buying a pair of jeans that regularly cost $40. They are on sale for 20% off. If the tax rate is 8%, what is the sale price of the jeans including tax