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
A population of a small town has a size of 6000 at time t=0, with t representing years. 1. if the population increases by 80 peo
Allushta [10]
F(t)=6000 +80t or
f(t)=p+80t
7 0
2 years ago
50 POINTS! By using shadows, Tatiana wants to find the height of a building. At a certain time of day, her shadow is 2.4 feet lo
vagabundo [1.1K]
The building is 16 feet tall
6 0
2 years ago
What is 54.77 rounded to the nearest tenth ?
k0ka [10]
54.8. Hope that helped :)
4 0
2 years ago
One day in December the temperature in Dublin was -3°C, in Salerno it was 7°C, while in Murmansk it was -10°C.
sukhopar [10]

Answer:

D

Step-by-step explanation:

-10° C is the lowest temperature and 7°C is the highest temperature.

6 0
3 years ago
Read 2 more answers
Solve:3m-2(m-3)=1 please help
mixer [17]

Answer:

3m - 2(m - 3) = 1 \\ 3m - 2m - 6 = 1 \\ m - 6 = 1 \\ m = 1 + 6 \\ m = 7

<h3><u>PLEASE</u><u> MARK</u><u> ME</u><u> BRAINLIEST</u></h3>
5 0
2 years ago
Read 2 more answers
Other questions:
  • How do you simplify exponent properties?
    8·1 answer
  • If f(x)= 2x^2 -4x and g(x) = 5 – 2x, evaluate f(x) – g(x) for x = 5
    6·1 answer
  • If c and d are supplementary, and the measure of d is 45 what is the measure of c?
    10·2 answers
  • Match the vocabulary (THE NUMBERS) with its definition or representation (LETTERS) WORDS. 1.Relation 2.slope 3.parallel lines 4.
    15·2 answers
  • Michael earns a base salary of $100.00 every week with an additional 9% commission on everything he sells. If Michael sold $4950
    8·2 answers
  • The amount of money collected by a toll booth is represented by the function A(m) = $2.50m where m stands for the number of minu
    13·1 answer
  • I need help with drawing one over two
    6·2 answers
  • True or False please ❗️
    13·2 answers
  • Need help ASAP! Directions and problem in picture;) <br><br> What is the value of ?
    9·1 answer
  • HELP ME I dont get ut
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!