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

PLEASE HELP! Questions in picture.
Someone help me with this
TO Rewrite the following equation in slope-intercept form. 5x + 4y = 3
* Which question is a statistical question? Select all that apply. (2 Points) Who is your teacher? What is your favorite movie? What is the age of each child cu
what is the area and circumference please help just tell only the answer
anyone know the answer??
Five angles of a hexagon measures 119, 129,104,139 and 95 degrees. What is the measure of the sixth angle?
The Railway TrainBy Emily DickinsonI like to see it lap the miles, And lick the valleys up, And stop to feed itself at tanks; And then, prodigious, step Around
What is the term for information that comes directly from your potential customers?a) Hearsayb) Secondhand information c) Secondary research d) Primary research
Demmert Manufacturing incurred the following expenditures during the current fiscal year: annual maintenance on its equipment, $5,400; remodeling of offices, $2