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
Layla has a coin that has a 60%, percent chance of showing heads each time it is flipped. She is going to flip the coin 5 times.
Semenov [28]

Answer:

0.33696

Step-by-step explanation:

Given that:

Probability of showing up head (p) = 0.6

Number of flips = number of trials = 5

Probability of getting more than 3 heads

P(x = x) = nCx * p^x * (1 - p)^(n-x)

P(x> 3) = p(4) + p(5)

P(x = 4) = 5C4 * 0.6^4 * 0.4^1 = 0.2592

P(x = 5) = 5C5 * 0.6^5 * 0.4^0 = 0.07776

Hence,

0.2592 + 0.07776

= 0.33696

3 0
2 years ago
Read 2 more answers
3
crimeas [40]

Answer:

4

Step-by-step explanation:

Mr Gonzalez had 10 pound. Then Mr. Gonzalez gave away 6 pounds. Now Mr. Gonzalez has 4 pounds (10 pounds-6 pounds)

8 0
2 years ago
Select the correct answer.
givi [52]

Answer:

B

Step-by-step explanation:

The cube of twice a number =

{2m}^{3}

Decreased by 11 =

- 11

Hence, the cube of twice a number decreased by 11 =

{2m}^{3}  - 11

7 0
3 years ago
teresa repartee un chocolate entre sus hermanos. ella le dio 1/3 a miguel y 1/4 a diego. que parte de chocolate repartido teresa
jekas [21]

Answer:

Teresa tiene 1 chocolate.

Ella le da 1/3 del chocolate a Miguel, entonces ahora Teresa tendrá un chocolate menos un tercio de chocolate, es decir, ella tiene:

1 - 1/3 = 3/3 - 1/3 = 2/3 de un chocolate.

Ahora le da 1/4 a diego, entonces lo que le sobra va a ser:

2/3 - 1/4

recordar que tenemos que tener el mismo denominador en ambas fracciones, entonces podemos reescribir esto como:

(4/4)*(2/3) - (3/3)*(1/4)

(a cada fracción la multiplico y divido por el denominador de la otra)

8/12 - 3/12 = (8 - 3)/12 = 5/12

Es decir, Teresa finalmente tiene 5/12 del chocolate.

Entonces la parte de chocolate que repartió es lo que le falta, que se obtiene como:

1 - 5/12 = 12/12 - 5/12 = 7/12

Ella repartió 7/12 de su chocolate.

4 0
3 years ago
What is the equation of a line with a slope of 3 and contains<br> point (4.1)
cricket20 [7]

Answer:

y = 3x - 11

Step-by-step explanation:

y=mx+b

1=3(4)+b

1=12+b

b=-11

5 0
3 years ago
Read 2 more answers
Other questions:
  • Whitch equation is equivalent to -3x+y=5<br><br> y=5 - 3x<br><br> y=5+3x<br><br> y=-3x-5<br> y=3x+5
    5·1 answer
  • Next week your math teacher is giving a chapter test. the test will consist of 35 questions. some problems are worth 2 points in
    9·1 answer
  • Ryan wrote the prime factorization shown below. If he continues this pattern, what prime factorization will he show for the numb
    6·1 answer
  • Which answer shows 2.13786 x 10^4written in standard form?
    7·1 answer
  • HELP NOW EXTRAA 20 POINTS
    8·1 answer
  • On a loan of $4,500 for 2 1/2 years at 4% per year, how much do you wind up paying to pay off the loan?
    12·2 answers
  • FACTOR COMPLETELY<br><br> -5x^3 + 45x^2 - 90x
    5·1 answer
  • HELPP PLEASEEEEEE!!!!!
    13·2 answers
  • How do you simplify h + i + i
    9·2 answers
  • On average, Anna can drive 31 miles on every gallon of gasoline. If she fills up her tank for $2.19 per gallon, how much will it
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!