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
Angle B is 45% of angle A. Angle C is 35% of angle A. What is the measurement of angle A?
mafiozo [28]

We assume , A, B, and C are angles of a triangle.
The sum of angles of a triangle is equal to 180º; therefore:
A+B+C=180º

B is 45% of angle A; then B=0.45A
C is 35% of anble A; Then C=0.35A

We can suggest this equation;
A+0.45A+0.35A=180
1.8A=180
A=180/1.8
A=100

Answer: The measurement of angle A is 100º.
3 0
3 years ago
The_timing add me on snap i barely have friends I will take as long as you to reply
bonufazy [111]

Answer:

ok ill be your friend ok dont worry

3 0
3 years ago
Read 2 more answers
what do i do if i have meausring cups but it doesnt say how much they are? i really wanna make some cookies
olya-2409 [2.1K]
Try measuring a different way, maybe with just cups
5 0
3 years ago
The point (2, –4) is reflected across the line y = –1. What are the coordinates of the image?
schepotkina [342]

ANSWER

The coordinates of the image are (2,2)

EXPLANATION

The mapping for a reflection across the line y=k is :

(x,y)\to (x,2k-y)

We want to find the image of the point (2,-4) after a reflection in the line y=-1.

In this case k=-1.

(2, - 4)\to (2,2( - 1)- - 4)

This simplifies to,

(2, - 4)\to (2, - 2 + 4)

(2, - 4)\to (2, 2)

Hence the image is (2,2)

4 0
3 years ago
What are the coordinates of M' after triangle MNO is reflected over the y-axis, and rotated 90 degrees clockwise with
exis [7]
(0,-6) because it is reflected and rotated
3 0
3 years ago
Read 2 more answers
Other questions:
  • 3(-3-3x)+4= -5 The solution is x= what?
    6·2 answers
  • 8 + x + y = 8 + y + x. This is an illustration of which property?
    15·2 answers
  • Consider the following statement: If Paul is older than Bill and Fred is younger than Bill, then Bill's age is between Paul's an
    13·2 answers
  • Look at the figure if tan x=3/y and cos x =y/z what is the value of sin x?
    15·2 answers
  • Estimate 5,002,319 times 24,625
    13·2 answers
  • A combination lock has 3 dials. The first 2 dials have a setting for digits 0 through 9, and the third has settings for all 26 l
    10·1 answer
  • The polynomial fx) is written in factored form:
    5·1 answer
  • The planting medium Mrs. Jaz uses to start his seeds in the early spring is hydrophobic. What does that word mean, and why would
    15·1 answer
  • What is 5x5 + 5 to the power of 5.
    11·2 answers
  • Calculate the slope of the line in the graphs and show your work
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!