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 to simplify 7m-2m
how many ounces is in 1/2 of a gallon?
Which is an effective way to resist peer pressure to do something you're uncomfortable doing?
Whom did Thomas Jefferson call servants of the people? A) slaves B) delegates C) kings D) soldiers
What percent of 145 is 29
How many integers less than one billion are very round numbers
What are three variables that affect a living system?
Tommy is making a picture graph to show his friends favorite kind of music. he plans to use one musical note to represent 2 people How many notes will he use
Which of the following is not presented as a key component to understanding a memoir? a. supporting details b. theme c. key ideas d. setting
What is a difference between starch and glycogen? A.) Starch stores energy, and glycogen provides structural support. B.) Starch is found in plants, and glycoge