answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
8_murik_8 [283]
2 years ago
14

Excel:In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns

the value in column 2, and specifies an exact match.
Mathematics
1 answer:
sp2606 [1]2 years ago
8 0

Answer:

=Vlookup'B13' A11' 7'false

Press enter.

Step-by-step explanation:

Vlookup is a technique in excel which enables users to search for criterion values. It is vertical lookup function in excel which return a value from a different column. The formula for Vlookup function is:

=Vlookup'select cell you want to look up in' select cell you want to lookup from' select column index number' true/false.

where true is approximate match and false is exact match.

You might be interested in
The length of a swimming pool is 8m longer than its width and the area is 105m2
Debora [2.8K]
width : w \\ length : \ l = w + 8 \\ A = 105 \ m^2 \\ \\A= w \cdot l \\ \\w(w+l)=105 \\ \\w^2+w = 105 \\ \\w^2+w-105 =0 \\ \\(w+15)(w-7)=0 \\ \\w+15 =0 \ \ or \ \ w-7 = 0 \\ \\w = -15 \ \ or \ \ w=7 \\ \\ width \ cant \ be \ negative, \ so \\ \\ w = 7 \ and \ l = w+8 = 7 +8 =15 \\ \\chek : \\ \\ A=w\cdot l \\ \\A=7\cdot 15=105 \ m^2
8 0
1 year ago
Read 2 more answers
While measuring specimens of nylon yarn taken from two spinning machines, it was found that 9 specimens from the first machine h
stepladder [879]

kaaaaaaaaaaaaaaaaabbbichaStep-by-step explanation:

8 0
1 year ago
Alana and two of her friends evenly split the cost of a meal. They determine that each person owes $14.68. How much was the enti
AlekseyPX

Answer:

44.04 bucks

Step-by-step explanation:

14.68 times 3 because 1 plus 2 is 3 friends. And 14.68 is how much they EACH paid.

6 0
1 year ago
Read 2 more answers
At the movies, a couple bought 2 medium drinks and a large popcorn for $13.85. At the same theater, a family bought 3 medium dri
m_a_m_a [10]

Answer:

a) the cost of one medium drink be $3.80

b) the cost of a large popcorn be $6.25

Step-by-step explanation:

Let the cost of one medium drink be $x

and the cost of a large popcorn be $y

According to question,

A couple bought 2 medium drinks and a large popcorn for $13.85.

2x + y = 13.85      ..............(1)

A family bought 3 medium drinks and 2 large popcorn for a total of $23.90

3x + 2y = 23.90      ..............(2)

Using Elimination method to solve the system of equation,

Multiply equation (1) by 2 , we get,

4x + 2y = 27.70      ..............(3)

Now, subtract equation (2) from (3), we get,

4x + 2y-(3x + 2y) = 27.70 - 23.90

4x + 2y-3x - 2y = 3.80

4x -3x = 3.80

x = 3.80

Substitute, x = 3.8 in (1) ,

2(3.80) + y = 13.85  

7.60 +y = 13.85

y = 6.25

Therefore, the cost of one medium drink be $3.80

and the cost of a large popcorn be $6.25



7 0
1 year ago
Read 2 more answers
Which equations represent the data in the table? Check all that apply.
kipiarov [429]

Answer:

a,d,e

Step-by-step explanation:

7 0
2 years ago
Read 2 more answers
Other questions:
  • The number sentence 4x6=6x4 is an example of what property
    15·1 answer
  • Tina went to the hardware store to buy a door knob and a towel bar, and while she was in the checkout line, she also threw some
    11·2 answers
  • Why wouldn't the man stand in line to step on the scale ? <br><br> answer ?
    10·1 answer
  • For what values of m does the graph of y = 3x^2 + 7x + m have two x-intercepts? a) m&gt;12/49 b) m&lt;12/49 c) m&lt;49/12 d) m&g
    14·1 answer
  • A baseball has a diameter of 5.1 inches. Find the volume of the baseball. Round your answer to the nearest tenth. Use 3.14 for p
    15·1 answer
  • While grading her students' most recent quiz on equation solving, Mrs. Jones calculated that approximately forty percent of her
    8·2 answers
  • [Q71 Suppose that the height, in inches, of a 25-year-old man is a normal random variable with parameters g = 71 inch and 02 = 6
    11·1 answer
  • A system of equations is given below. y = negative 2 x + one-fourth and y = negative 2 x minus one-fourth Which of the following
    12·1 answer
  • Given the graph below, find GH.
    15·1 answer
  • A falcon flying 55 mph crosses a lake in 1 minute. How long would it take a hummingbird flying 45 mph to cross the same lake?
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!