1answer.
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
shtirl [24]
3 years ago
14

In Microsoft Excel, you have data that has been entered into cell A1. You need a function that looks up this value from A1 in a

table of values in E1 through F10. You need to have the value from the second column (F) be displayed in the cell in which you are writing this formula. Also, A1 will precisely match one of the values in the first column (E). What formula would you write to look up this information?
Mathematics
1 answer:
bazaltina [42]3 years ago
6 0

I'm going to assume that there is something in A1 but the way you are describing the problem, you could just as easily write a constant in the formula you are using in cells E1 to E10 and F1 to F10

The trick is to refer to A1 as $A$1 which means that E1 to E10 isn't going to get creative and start looking for things in a1 to a10.

Here is an actual table made from what I think you mean

1 113 114

2 114 116

3 115 118

4 116 120

5 117 122

6 118 124

7 119 126

8 120 128

9 121 130

10 122 132

1 to 10 on the left is in column  D

A1 contains 112

In column E the enteries from 1 to 10 simply take = $A$1 + d1

Column F uses $A$1 and adds 2*d to 112

Here is the chart shown in formula form.

1 =D1+$A$1 =$A$1 + 2*D1

2 =D2+$A$1 =$A$1 + 2*D2

3 =D3+$A$1 =$A$1 + 2*D3

4 =D4+$A$1 =$A$1 + 2*D4

5 =D5+$A$1 =$A$1 + 2*D5

6 =D6+$A$1 =$A$1 + 2*D6

7 =D7+$A$1 =$A$1 + 2*D7

8 =D8+$A$1 =$A$1 + 2*D8

9 =D9+$A$1 =$A$1 + 2*D9

10 =D10+$A$1 =$A$1 + 2*D10

Remember that 1 to 10 is in d1 to d10

You might be interested in
The team won eight games and lost three. What is the ratio of wins to total games?
jonny [76]

Answer:

The answer is 8:11 !

Step-by-step explanation:

The team won 8 , and lost three if you want the total number of games then add 8 and 3 together and get 11. .....so the ratio would be 8:11 .....Hope this helps !!!!!!!

3 0
3 years ago
What is the first step in solving this system of equations by Substitution?
pickupchik [31]

Answer:

x=x+2

Step-by-step explanation:

6 0
3 years ago
You are a delivery manager at MN Company, a wholesale lollipop. The
Nady [450]

For the new expectation, 3 drivers and 2 vans are needed.

To determine, for the new expectation, how many drivers and vans do you need, the following calculation must be performed:

  • 8500 x 1.5 = 12750
  • 5000 x 3 = 15000

Therefore, for the new expectation, 3 drivers and 2 vans are needed.

Learn more about maths in brainly.com/question/26173296

3 0
2 years ago
A single fair die is rolled. What if event A stays the same, i.e., A={2,4} but B={2,4,5}. Event A is independent with event B. T
den301095 [7]

Answer:

False.

Event A and event B are not independent.

Step-by-step explanation:

We know that event A and event B are

A= {2,4} and B= {2,4,5}.

If the following condition satisfies then event A and event B are independent:

P( A and B)= P(A)*P(B).

Now A and B=?

A and B=A∩B= {2,4} ∩ {2,4,5}

A and B=A∩B={2,4}

The single fair die results in 6 outcomes so, the sample space will contain 6 elements.

Thus,

P(A∩B)=2/6=1/3

P(A)=2/6=1/3

P(B)=3/6=1/2

P(A)*P(B)=1/3*1/2=1/6

As,

P(A∩B)≠P(A)*P(B)

1/3≠1/6

Thus, events A and event B are dependent.

5 0
3 years ago
CAN SOMEONE PLEASE HELP ME????
lakkis [162]

Answer and Step-by-step explanation:

Greetings!

I'm~Isabelle~Williams~and~I~will~be~answering~your~question!

The~answer~to~your~question~is~option~``C".

\boxed{~y=0.026-0.05~}

I~have~already~given~you~an~explanation~in~your~other~question.~

Hope~my~answer~helps~you!~and~have~a~great~day!

-Isabelle~Williams

3 0
3 years ago
Other questions:
  • A marble is randomly selected from a bag. The probability of selecting a marble with dots on it is 0.2. The probability of selec
    11·1 answer
  • How do you answer this
    10·1 answer
  • Triangle XYZ has been dilated to form triangle LMN. What is the least amount of information needed to prove the two triangles ar
    11·1 answer
  • I'LL FRIEND IF YOU ANSWER THIS what is 32(14+17x)/4-12 simplified
    7·2 answers
  • 2 divided by 5/12 ? <br> quq
    7·1 answer
  • Given the following functions f(x)
    10·1 answer
  • What is the value of the expression 10(n-6) when 4=14
    5·2 answers
  • Help plz and thx for your help
    9·1 answer
  • What is -4 - (8) More text
    14·2 answers
  • Open the cpt manual to the page that contains code 40490. what section of the cpt coding manual is this code listed in?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!