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
How do you simplify 48/200
Kipish [7]

Answer:

6/25

Step-by-step explanation:

all you need to do is to look for common factors of both the numerator and the denominator and you keep on breaking it down

3 0
2 years ago
(PLEASE HELP) The picture explains everything.
mamaluj [8]
Store #2 since it has a lower MAD
4 0
2 years ago
Pls help me i need helpppp
TEA [102]

Answer:

{-3, -4}

Step-by-step explanation:

hope it will help you☺

6 0
3 years ago
What the dependant, independent, and equation is
Anestetic [448]

Answer:

Dependent Value: Cost (C)

Independent Value: Bushels (B)

Step-by-step explanation:

You can make the letter D out of the side of the bar graph and the letter I on the bottom, this tells you the label on the side is the dependent and the label on the bottom is the independent. If you dont have a line graph then think about this sentence starter: ...... effects.......

Quote to make you happy:

7 0
3 years ago
Someone please answer this lol xx
Tamiku [17]
The answer is 4 lol
3 0
3 years ago
Other questions:
  • Find the product of 3/8 4/5
    15·1 answer
  • The pentagon PORSTis transformed into POR'ST using which two transformations?
    12·1 answer
  • What is £390 shared as 5:8 ratio
    6·1 answer
  • Gloria used 2 1/2 tubes of blue paint to paint the sky in her picture. Each tube holds 4/5 ounces of paint. How many ounces of b
    11·1 answer
  • Convert from fraction to percent 8/12
    13·2 answers
  • The sum of two numbers is 278. One number is 52 more than the other number. What are the two numbers
    7·1 answer
  • A silo in the shape of a cylinder is partially filled with corn to cows. The corn fills 50% of the height of the silo. What is t
    8·1 answer
  • 45.60$ meal with a an 18% tip
    12·1 answer
  • I Need help asap!!!!!
    11·2 answers
  • Which of the following is equal to b^3/4 for all values
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!