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]
4 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]4 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
HURRY PLEASE HELP ASAPP
larisa [96]

Answer:

The very last is the right answer

Step-by-step explanation:

4 0
4 years ago
Read 2 more answers
Consider this Venn diagram of the prime factors of 210 and 330. Which is the least common multiple of these two numbers?
Mrrafil [7]
The least common multiple of these two numbers is 2310. Hope this helps
5 0
4 years ago
Someone help I will give u 5 points
SCORPION-xisa [38]
83 would be the answer. You don’t gotta multiply or anything
3 0
3 years ago
I can find a simplified expression for the perimeter of a square with a side length of (2x-4)
ELEN [110]

perimeter = 8x - 16

A square has 4 sides of equal length, multiply length of side by 4

perimeter = 4(2x - 4) = 8x - 16


4 0
4 years ago
The Palue of the digit in the hundredths place is
Harman [31]

Answer:The value of the digit in the hundredths place is 10 times as great as the value of the digit in the tenths place.

Explained: The model shows that your number is 0.11

We have to find what we can multiply to become the 1 in the tenths place. Since they are the same number but in different places, we just multiply it by 10 to change the value.

So, if you multiply 10 by the 1 in the hundredths place, it will get you to the 1 in the tenths place.

♡<em>Hope</em><em> </em><em>it</em><em> </em><em>helps</em><em>♡</em>

7 0
3 years ago
Other questions:
  • Guys, I just need 2 more scenarios for this assignment! I am in deep need for help even if you can just write up 1 that would be
    15·2 answers
  • This year, a baseball player made 92 hits out of 564 times at bat. Another player made 84 hits out of 634 times at bat. Did the
    5·2 answers
  • What is -5/8 + 3/4 ?
    8·2 answers
  • E ,F and H are three of the verticales of rectangle EFGH on the coordinate plane . What are the coordinates of G , the fourth ve
    8·1 answer
  • What does pemdas orelse mean in math
    15·2 answers
  • Sheree smith purchased a new SUV for $32,984. He received a $49.95 rebate from the manufacturer and a $38.95 rebate from the sto
    13·1 answer
  • Large pool equipment sets cost $1,042. Small pool equipment sets cost$907. How much does it cost to buy 3 large pool equipment s
    7·1 answer
  • Alex made $28.74 for three hours of work at his job at the pet store . If he works a total of 40 hours in one week , how much mo
    12·1 answer
  • Help........................​
    6·1 answer
  • Please help will mark brainliest 12 x 12 - 44
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!