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
What is the value of x?<br> O 40<br> O 70<br> O 140<br> O 160
kodGreya [7K]
The answer is 70 degrees
4 0
3 years ago
Read 2 more answers
Can you help me do this Q please :)
goldenfox [79]

Answer:

i didnt get it

Step-by-step explanation:

can you explain

3 0
2 years ago
Bryan's monthly Netflix subscription costs $10. If he charges it
sergij07 [2.7K]

Answer:

$50

Step-by-step explanation:

If he pays $10 every month, and he pays for 5 months, it would be 10 x 5, which means he would be $50 in debt.

4 0
2 years ago
9( 2k + 3 ) + 2 = 11 ( k- y )
Mashcka [7]
9(2k+3)+2=11 (k-y) 
k=-11/7 y+ -29/7
8 0
3 years ago
Read 2 more answers
Select the choice that translates the following verbal phrase correctly to algebra:
Anestetic [448]
" the product " means multiply

km <== ur expression...which means k * m
4 0
3 years ago
Read 2 more answers
Other questions:
  • What is the maximum height of h(t)=-16t^2+16t+480
    6·1 answer
  • Can irrational numbers also be integers/ True or False
    13·1 answer
  • determine whether this statement is true or false. if two lines have the same slope, their equations describe the same line.
    11·1 answer
  • (2x^3 z^2)^3 / x^3 y^4 z^2 * x^-4 z^3
    10·1 answer
  • Solve for angle S ? Please help
    15·2 answers
  • 24 Hour Fitness charges svara spatee plus so per months to poun thensyn time has podszes por s gym membership so farHow many mon
    14·1 answer
  • What is the solution to the system of equations?
    10·1 answer
  • Dana takes a sheet of paper and cuts from one corner to the opposite corner, making two triangles. If the piece of paper is 8 in
    6·1 answer
  • One side of a triangle is 7 feet longer than the second side. The third side is 2 feet longer than the second side. The perimete
    12·1 answer
  • 9. Nick Antonelli sells for Discount Appliance, Inc. His weekly base salary is
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!