Suppose that a spreadsheet contains the following values.

A1 6
B1 -4
C1 2
D1 3
Determine the value of cell E1 if it contains the following formulas.
a) +A1 + B1 E1= 2 got that one right
b) +4*A1 + 5*B1 got that one wrong
c) +C1*(A1 +3*B1) got that one wrong
d) +A1+...+D1 or sum(A1.. D1) got it right. What could I have done wrong.
Could you please help me.

(b) 4(6) + 5(-4) = 24-20 = 4

(c) 2(6 + 3(-3)) = 2(6-9) = 2(-3) = -6

when asking what you did wrong, it's a lot better if you show what you did, so we can figure that out.

Of course! I'm here to help you. Let's go through each of the formulas step by step to identify what might have gone wrong.

a) The formula "+A1 + B1" simply adds the values in cells A1 and B1. Since A1 is 6 and B1 is -4, the correct value for E1 would be 6 + (-4) = 2. You mentioned that you got this one right, so no problems here.

b) The formula "+4*A1 + 5*B1" multiplies 4 with the value in cell A1 and 5 with the value in cell B1, and then adds the results. According to the given values, A1 is 6 and B1 is -4. Substituting these values, we have 4 * 6 + 5 * (-4) = 24 + (-20) = 4. So the correct value for E1 would be 4. If you got a different answer, please double-check your calculations.

c) The formula "+C1*(A1 + 3*B1)" multiplies the value in cell C1 with the sum of A1 and 3 times the value in B1. Using the given values, C1 is 2, A1 is 6, and B1 is -4. Substituting these values, we have 2 * (6 + 3 * (-4)) = 2 * (6 - 12) = 2 * (-6) = -12. Hence, the correct value for E1 would be -12. If you got a different result, please reevaluate your calculations.

d) The formula "+A1+...+D1" or "SUM(A1..D1)" adds up the values in cells A1, B1, C1, and D1. Using the given values, we have 6 + (-4) + 2 + 3 = 7. Thus, the correct value for E1 would be 7. If you obtained a different answer, please review your computation.

In summary, please ensure that you accurately perform the calculations when substituting the values into the formulas to get the correct results. If you still face difficulties, feel free to ask for further assistance!