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

Match the vocabulary word with its meaning. 1. Etymology Old Stone Age 2. Sedentary Middle Stone Age 3. Paleolithic the process of settling down in one lo
Look at the image and state how you will set up to take a photograph like this. Mention how you would set up the camera support equipment. Describe what precaut
How do you simplify 7/37
How do you answer this ?
What dose 2/6 + 3/6 =
una oracion con suscitar
Explain how to use proportional reasoning to determine the whole if you know that 21 is 60% of the whole
Factor this polynomial expression. X^2 + 8x + 16
What is the difference of the fractions? 4/7 - 10/7
Each of the items below must be considered in preparing a statement of cash flows for Baskerville Co. for the year ended December 31, 2020. For each item, state