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?

Answers

Answer 1

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

Answer 2

To look up a value from A1 in a table (E1:F10) and display the corresponding value from column F, use the formula =VLOOKUP(A1, E1:F10, 2, FALSE) in the desired output cell.

To look up the value in cell A1 from a table in E1 through F10 and return the value from the second column (F), you would use the VLOOKUP function. The appropriate formula to enter into the cell where you want to display the result would be =VLOOKUP(A1, E1:F10, 2, FALSE). This formula begins with an equal sign, as all Excel formulas do, and instructs Excel to find the value in cell A1 within the first column of the range E1:F10 and return the corresponding value from the second column of that range. The FALSE argument specifies that you want an exact match.


Related Questions

D-I are the measurements of the lengths of the sides of triangles. Identify the types of triangles.
d. 45 cm 61 cm 60 cm
e. 30 cm, 31cm, 30 cm
f. 4 cm, 5ft, 4 cm
g. 89mm, 89mm, 89mm
h. 9 in, 5in, 3 in
i. 22cm, 22cm, 22in

Answers

The types of triangles are:

d. Scalene

e. Isosceles

f. Isosceles

g. Equilateral

h. Scalene

i. Equilateral

Here's the type of triangle for each set of measurements:

d. 45 cm, 61 cm, 60 cm:

All sides are different lengths.

Therefore, this is a scalene triangle

e. 30 cm, 31cm, 30 cm:

Two sides have equal lengths (30 cm).

This is an isosceles triangle

f. 4 cm, 5ft, 4 cm:

We need to convert feet to the same unit as cm for comparison.

1ft = 12 inches = 2.54 cm

5ft = 5 * 2.54 cm ≈ 12.7 cm

We have two sides with equal length (4 cm) and one different length (12.7 cm).

This is also an isosceles triangle

g. 89mm, 89mm, 89mm:

All three sides have the same length.

This is an equilateral triangle, a special type of isosceles triangle where all sides are equal.

h. 9 in, 5in, 3 in:

All sides have different lengths.

This is a scalene triangle

i. 22cm, 22cm, 22in:

We need to convert inches to centimeters for comparison.

22in = 22 * 2.54 cm ≈ 55.88 cm

Comparing the converted lengths, we see all sides have equal lengths.

This is an equilateral triangle

Y - 3 = 4(x + 12) slope and y intercept

Answers

The y-intercept will be (0,51)

In case, if you want the x-intercept it will be (-51/4,0)

Benito saves $6 out of every $20 he earns. He earned $90 one month. How much did he save?

Answers

Set up a proportion:

6/20 = x/90

Meaning 6 saved over 20 and x saved over 90

Cross multiply

540 = 20x

x = 27

He saved $27

He saves $6 out of every $20 - 90/20 = 4.5
And 4.5 x 6 = 27

round to the nearest hundredth 3.2649

Answers

The answer is 3.26             :D :D :D :D    

Final answer:

The answer to rounding the number 3.2649 to the nearest hundredth is 3.26. You need to consider the digit in the thousandths place to determine if you round up or down.

Explanation:

To round the number 3.2649 to the nearest hundredth, you will need to look at the digit in the thousandths place, which is 4 in this case. In rounding, if the digit is 5 or more, you round up, else you round down. Here it is 4, it's less than 5, so we round down. So, the number 3.2649 when rounded to the nearest hundredth is 3.26.

Learn more about Rounding Numbers here:

https://brainly.com/question/29088877

#SPJ2

18.A ________ change occurred when a metal changed Color because it reacted with another substance.

Answers

The answer is a chemicl change.

A chemical change occured when a metal changed color because it reacted with another substance.

what is the mean of 5,10,15,20,25

Answers

5+10+15+20+25=75

75/5=15

15 is the mean

5+10+15+20+25=75

Your mean will be 75

Then divide by 5 = 15

Your answer will be 15

Olivia ordered cupcakes and a layer cake. Together she paid $52. She paid $12 more on the layer cake than on the cupcakes. What was the price of each?

Answers

Hey there!!

The total cost is $52.

She paid $12 more for the layer cake than the cupcake.

Let's take the price of the cupcake as $x. Then, the price of the layer cake would be $12 + x

The sum of these would result in $52.

... x + x + 12 = 52

... 2x + 12 = 52

... 2x = 52 - 12

... 2x = 40

... x = 20

Hence, the price of the cupcake is $20 and the price of the layer cake is $32.

Hope my answer helps!!


2x+5y=35 x=-10-15y. what value of x satisfies the system of equations?

Answers

you can substitute the whole equation that equals x into the other equation and solve it algebraically, with that x is 23 abd y is -2.2

Plot the line for the equation on the graph. y−4=−14(x−5)

Answers

Answer:

Where do I plot it

Step-by-step explanation:

Answer:

Answer: Hopefully this helps other people! :) I got it right on the test!

Need help with number 60 plz. Multi-step math :)

Answers

Problem 60)

Solution

Part 1

Joy earns $8 per hour. She earns $128 per month.

The number of hours worked in each month = 128/8 = 16 hours.

She works 16 hours each month in order to earn $128.

Part 2

After six months she gets a $2 per hour raise.

Now her earning per become $10.

She works 16 hours each month.

Joy earning per month = 16*10 = $160.


Hope you will understand the solution. Thank you :)

Solve the system by the substitution method.

X+Y=-3
Y=-4x

Answers

find it I cannot find it

x = 1, y = - 4

substitute y = - 4x into the other equation

x - 4x = - 3

- 3x = - 3 ( divide both sides by - 3 )

x = 1

substitute x = 1 into y = - 4x ⇒ y = - 4


The number a times 10 to the power of negative 2 is about 8 times greater than b times 10 to the power of negative 3. Find the correct value of a and b.

A. a = 3.1 and b = 2.5
B. a = 2.5 and b = 3.1
C. a = 2 and b = 1.2
D. a = 1.2 and b = 2

Answers

Answer:

c

Step-by-step explanation:


The correct values of a and b are a = 3.1 and b = 2.5, which corresponds to option A.

To solve the question, we need to set up an equation using the information given. Here's a step-by-step explanation:

a * 10^-2 = 8 * b * 10^-3Divide both sides by 10^-3 to simplify the equation: a * 10 = 8 * bPlugging in the values for a and b from option A, we get 3.1 * 10 = 8 * 2.5, which is true.Therefore, a = 3.1 and b = 2.5, matching option A.

A bookstore manager marks down the price of older hardcover books,which originally sell for b dollars,by 46 percent. What is the markdown as a decimal. Write an expression for the sale price of the hardcover book. What is the same price of a hardcover book for which the original retail price was $29.00? If you buy the book in part c, how much do you save by paying the sale price?

Answers

We are given original selling price of book = $b.

Price is marked down by 46%.

46% can be written as 46/100 in decimals it would be 0.46.

Therefore, markdown as a decimal is 0.46

Now, markdown is 0.46 of original price = 0.46b

Therefore, new price after marked down can be written by expression =

b - 0.46b = 0.56b.

Therefore, the expression for the sale price of the hardcover book is 0.56b.

If original retail price was = $29.00.

The sale price would be 0.56b = 29*0.56 = $15.66.

Total saving = 29-15.66 = $13.34.

Therefore, you save $13.34 by paying the sale price $15.66.


Where does 56 come from ?

which fraction is not equivalent 30\48

Answers

The answer is C. 20/38

Write An equation in slope intercept form for the line passing through each pair of points (-1,3) and (2,-5)

Answers

Slope m = y2-y1/x2-x1

Points (-1,3) and (2,-5)


M= -5-3/2-(-1)


M= -8/3


M= -8/3


Slope is -8/3


Now fill in the formula equation of a line using one if the points and slope to find b .


(2,-5) and slope -8/3


Y=mx+b


-5=-8/3(2)+b


-5=-16/3+b

-5+16/3=b

1/3=b


Now put all together


Y= -8/3x+1/3

Slope intercept form of a line is y = mx + b, where m is the slope and b is the y coordinate of the y intercept.

The easiest way to solve this problem is by using another equation for a line, also known as point slope form. This equation is best to use for a line if you have  a point and slope of the line, but do not have the y-intercept.

We need to find the slope of this line passing through the pair of points (-1, 3) and (2, -5). We can do this by using the slope formula: [tex]\frac{y_2-y_1}{x_2-x_1}[/tex]. Substitute in the appropriate coordinates.

[tex]\frac{-5-3}{2-(-1)}[/tex] = [tex]\frac{-8}{3}[/tex], so the slope of the line is -8/3.

Point slope form of a line is [tex]y-y_1=m(x-x_1)[/tex]. Substitute -8/3 for m, and use the point coordinate (-1, 3) for y1 and x1. You could use either point coordinate but I chose to use this one.

[tex]y-3= -8/3[x-(-1)][/tex]

Distribute -8/3 inside the parentheses.

[tex]y-3= -8/3x - 8/3[/tex]

Add 3 to both sides.

y = -8/3x + 1/3 is your answer (slope intercept form).

The number of employees of a company decreased from 225 to 189. Find the percent decrease

Answers

So what you want to do is divide 189 by 225 which equals 0.84 then subtract o. 84 from one and u get 0. 16 which you have to multiply by 100 to get 16%
Final answer:

The number of employees at the company decreased by 16%. This was calculated by first finding the decrease in number of employees (36) and then calculating this as a percentage of the original number of employees.

Explanation:

To find the percent decrease in the number of employees at the company, you need to follow these steps:

First determine how many employees there has been a decrease by subtracting the final number of employees from the original number. So 225 - 189 = 36.Next, calculate the percentage that this decrease represents out of the original number. You do this by dividing the decrease by the original number and then multiplying the result by 100 to get a percentage. So (36/225) * 100 = 16%.

So the number of employees at the company decreased by 16%.

Learn more about Percent Decrease here:

https://brainly.com/question/8549621

#SPJ11

Find the difference between x+5 and 2x+3

Answers


[tex](2x + 3) - (x + 5) = 2x + 3 - x - 5 =x - 2 [/tex]

Answer:

The difference between the given expressions would be [tex]x - 2[/tex]

Step-by-step explanation:

Given phrase,

Difference between x+5 and 2x+3,

[tex]( 2x + 3 ) - (x + 5)[/tex]

[tex]=2x + 3 - x - 5[/tex]   ( By distributive property )

[tex]=x - 2[/tex]     ( By combining like terms )

Hence, the required difference would be [tex]x-2[/tex]

Simplify 3m^2(10+m) PLEASE HELP

Answers

3m^2 (10+m)

Use FOIL

3m^2*m=3m^3

3m^2*10= 30m^2

Answer: 3m^3 + 10m^2

Solution :

Given expression [tex]3m^{2}(10+m)[/tex]

To simplify this expression, first we need to know about the Distributive property.

Distributive Property: [tex]a\times(b+c)=(a\times b)+(a\times c)[/tex]

Given expression [tex]3m^{2}(10+m)[/tex]

Applying Distributive property on this expression -

[tex]\Rightarrow 3m^{2}(10+m)=(3m^{2}\times10)+(3m^{2}\times m)[/tex]

                                       [tex]= 30m^{2}+3m^{3}[/tex]

Simplified form of [tex]3m^{2}(10+m)[/tex] is  [tex]30m^{2}+3m^{3}[/tex]

1. If ΔMNO≅ΔGHI, then which of the following is NOT true? A. ΔMON≅ΔGIH B. OM=IG C. ΔHIG≅ΔNMO D. ΔIHG≅ΔONM E. ∠GHI≅∠ONM

Answers

I'm pretty sure it is E. but I haven't done this in a while. So don't count to much on that answer

Evaluate the expression when x = 2

Answers

the answer is 1 when x=2

If you roll a die, what is the probability that a one will appear on top

Answers

you will have a 1 in 6 chance to roll a 1 on a die

A standard Die has 6 sides.

The probability of any number being on top is 1/6.

The probability of having a one on top would be 1/6.

Pls help forgot to do this

Answers

The surface area of a rectangular prism is the sum of the areas of its faces added together. From the picture, we can see that the prism is constructed of 4 faces that measure 7 cm by 9 cm and 2 faces that measure 7 cm by 7 cm.


The area of one 7 cm by 9 cm face is 63 cm². Together, all four of the faces add up to 252 cm².


The area of one 7 cm by 7 cm face is 49 cm². Together, the two faces add up to 98 cm².


Using these areas, we can say that the total surface area of the prism would be 252 cm² added to 98 cm², or 350 cm².

12y+d=−19y+t
Solve for y

Answers

Hi!

Solve for d.

[tex]12y+d=-19y+t[/tex]

Subtract by 12y from both sides.

[tex]12y+d-12y=-19y+t-12y[/tex]

[tex]Answer---> d=-31y+t[/tex]

Solve for y.

Add 19y from both sides.

[tex]d+12y+19y=t-19y+19y[/tex]

[tex]d+31y=t[/tex]

Add d from both sides

[tex]d+31y+-d=t+-d[/tex]

[tex]31y=-d+t[/tex]

Divide by 31 from both sides.

[tex]\frac{31y}{31}=\frac{-d+t}{31}[/tex]

[tex]Answer ----> y=\frac{-1}{31} d+\frac{1}{31}t[/tex]

Hope this helps!

Thank you for posting your question at here on Brainly.

Have a great day!

-Charlie

What is the least common denominator for the fractions 1/3 and 2/9

Answers

the LCD of the two is 9 what you do is this  so 1/3,2/9 is simple its 1/3 2/3 1 then lets try the 2/9 2/9 4/9 6/9 and keep doing that until they both reach the SAME number.


The LCD (Least common denominator) is 9,  

For the denominators (3, 9) the least common multiple (LCM) is 9.

Therefore, the least common denominator (LCD) is 9.


Hope This Helps :D

In a recent year the total sales at a restaurant a bar $350,000 worth in at restaurant be. Total sales at the two stores were $575 million. What were the sales for the year at each store?

Answers

Subtract the difference from the total:

575,000,000 - 350,000 = 574, 650, 000

Divide the difference by 2:

574, 650, 000 / 2 = 287,325,000

That is the lower one, then add the difference for the higher one:


Restaurant A = $287,325,000 + $350,000 = $287, 675,000

Restaurant B = $287,325,000




Mr. McKay spent $2.60 for a box of crackers and then divided them evenly between the s students in his class. Write an expression for the cost of the crackers for each student. Find the cost for s=20 students

Answers

$2.60 was spent on a box of crackers.  s = 20 students.

Let's have C be the cost of crackers for each student.  To find the cost, we divide the total amount of money (2.60) by the number of students (20)

C = 2.6/20

C = 0.13

Final answer:

The cost of the crackers for each student in Mr. McKay's class, if divided evenly, would be $0.13 when there are 20 students.

Explanation:

Mr. McKay's expenditure on the box of crackers can be written as an arithmetic expression where the total cost is divided by the number of students. This expression is 2.6 / s. By substituting the given number of students (s=20), we find that the cost of the crackers for each student is 2.6 / 20 = $0.13. Therefore, each student should pay $0.13 if the cost of the crackers is to be divided evenly among them.

Learn more about Crackers cost per student here:

https://brainly.com/question/31886937

#SPJ2

Which line is a graph of the equation: 2x + 5y = –10? Number graph ranging from negative five to five on the x axis and negative six to two on the y axis. Four lines are drawn in blue on the graph. Lines a and c have a positive slope and are parallel to each other. Lines b and d have a negative slope and are parallel to each other. Lines a and b intersect at (zero, two), and lines c and d intersect at (zero, negative two). A. line a B. line b C. line c D. line d

Answers

First we find the slope of the given line by using slope intercept form.

Converting the equation into slope intercept form

[tex] 5y=-2x-10[/tex]

Divide both side by 5 we get

[tex] y==-\frac{2}{5}-2[/tex]

On comparing with [tex] y=mx+c[/tex]


We get slope [tex] m=-\frac{2}{5}[/tex]

as the slope of line is negative therefore the line will either "b" or "d"

As line "b" pass from (0,2)

On putting it in given equation we get


[tex] 2(0)+5(2)=10[/tex]

Which is not equL to RHS of the line

Therefore b is not the given line


Now putting point (0,-2)

We get [tex] 0+5(-2)=-10[/tex]

Satisfy the equation and line "d" pass from it


There the give equationis of line "d"

Answer:the answer is line D

Step-by-step explanation:took the test and got it right

Which ordered pair is a solution of the equation Y=- 7X +2

Answers

2 he nebsna Yukon 4(56)

Answer:

neither

Step-by-step explanation:

If ƒ( x )= 2 x 2 + 3, then ƒ( x - 1)= 2 x 2 + 4 x + 5.

True or False

Answers

The value of function f(x - 1) = 2x² + 4x + 5 is not true.

Here,

The function is given as;

f (x) = 2x² + 3

And, f(x - 1) = 2x² + 4x + 5

We have to check the value of f(x - 1) is true or not.

What is substitution method?

To find the value of any one of the variables from one equation in terms of the other variable is called the substitution method.

Now,

The function is;

f (x) = 2x² + 3

To determine the value of f (x - 1), we can put (x -1) in place of x as;

f (x) = 2x² + 3

f (x - 1) = 2(x - 1)² + 3

f (x - 1) = 2(x² + 1 - 2x) + 3

f (x - 1) = 2x² + 2 - 4x + 3

f (x - 1) = 2x² - 4x + 5

Hence, The value of function f(x - 1) = 2x² + 4x + 5 is not true.

Learn more about the substitution method visit:

https://brainly.com/question/1550745

#SPJ2

Miguel baked 5 loaves of bread. Each loaf required 7/8 cup of flour. How much flour dis miquel use?

Answers

That’s very simple.. all what u have to do is to multiple 5 by 7/8 so the answer is 35/8 or 4.375
Other Questions
Plzzzzzz help me due tomorrow u will be marked BRAINLIEST Four neighborhood children opened their own lemonade stand. The table shows the sales information for each stand, in glasses of lemonade. What was the largest fraction of sales of the stands' inventory? A. 12 B. 47 C. 34 D. 712 Lines of poetry may be arranged into groups that are calledQuestion 1 options:linesformsstanzas Computer programs that play chess first appeared in the 1960s, but these programs were no match for the top human players. It was not until 1997 that a chess computer called Deep Blue was able to narrowly defeat world champion Garry Kasparov in a series of games. Kasparov concealed his disappointment as best he could, but he could not hide the embarrassment he felt over losing to a machine. What can you infer about the benefit to the game of chess and of the computer program that plays chess PLS HELP 20PTS What type of relief carvings are on the columns of the Hypostyle Hall in the Great Temple of Amun at Karnak? low relief high relief sunken relief the perimeter of a square with sides of length 3x discuss the nature and scope of geography with emphasis on geomorphology Which of the following georges seurat use the elements of art in his paintingA. He used colors with low saturationB. His shapes are mostly geometricC.He implied form through shadingD. He made space look shallow by not using overlapping. Order the numbers from least to greatest. 34, 0.5, 23,73, 1.2 The order of the numbers from least to greatest Does mediation lead to heightened states of consciousness, alertness, or creativity? How does the auger hole, bored about half an inch or so, into the plank develop the symbol of Ahabs whalebone leg? plzzzzzzzzzzzzzzz help what is 6+x3=13 When DNA is extracted from E. coli cells and analyzed for base composition, it is found that 42% of the bases are cytosine. That means that there is also 42% of which base? What does confronting the squire reveal about Herbert's character Cause and Effect What effect did Abu Bakr have on the spread of Islam? An object has a mass of 20 g and displaces a volume of 5 mL. What is the object's density? Please help..Find (4.8 x 10^6)(3.6 x 10^3) / (2 x 10^5) , expressed in scientific notation. A) 8.64 x 10^4 B) 8.64 x 10^6 C) 8.64 x 10^8 D) 17.28 x 10^4 A mile is 1760 yards. How many miles does Stacy walk each week? She walked 4680 yards. John had 245.000 in his current account before he invested two-fifths of the money in an insurance company. How much did he invest? How much is left in the account? Two glucose molecules joined together form a. maltose. b. dextrose. c. lactose. d. sucrose.