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

A ball is dropped out of a window and hits the ground at 14.5 m/s. How long did it take to fall to the ground?
w* [tex]\frac{5}{6}[/tex]
Scientific discoveries are often built on the previous findings of other scientists. Millikan’s oil drop experiment occurred after Thompson’s cathode ray tube e
Which of the following could be the side lengths of a right triangle?
solve the inequality 2(4x+1) < 3(2x-3)
Need help Four students answered the problem at the top of the table. The table shows their answers. Which student gave the correct answer? 7a² - 4 if a = 4 S
What would 2 different species in an ecosystem ultimately compete for
Can you guys help a guy out? :D
Question 10(Multiple Choice Worth 2 points) What function should you choose if you want to make a copy of a digital image file to back it up? Save Copy Save
the opposite of bass in french is