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

How do people in rural areas of East Africa make a living? Choose ALL answers that are correct. as tour guides as subsistence farmers by herding cattle by growi
A nurse is providing teaching to a client who has asthma about the use of a metered-dose inhaler.
can someone help me? i really need it :)
Can you just answer question 23!!! i need help!!!
Find x if ∠m1 = 2x + 10 and m∠2 = 3x - 6
what caused world war 2​
The reformers of the Anglican Church came to be calleda. Anabaptists. c. Amish. b. Puritans. d. Mennonites
help me please, i have no idea what im supposed to be doing and my teacher isnt much help so im hoping someone else can help me
LOTS OF POINTS AND BRAINLIEESTT Which factor contributed most to the U.S. acquisition of Florida in 1819? The defeat of Great Britain in the War of 1812 U.S. mi
Write the word 'MATHEMATICS' using line segments and observe the number of angles more than a right angle and number of angles less than a right angle​