Computer Science

posted by .

w w w (dot)cs(dot)umass(dot)edu(slash)~verts(slash)coins105(slash)quizzes(slash)images(slash)hw10(dot)gif

Using the constants in cells A2:A9, create formulae for cells A12:A15 (surrounded by a dark line)
to compute the corresponding "derived" physical constants indicated in cells B12:B15. Then create
formulae for cells D18:D23 to compute product prices based on the corresponding input values in
A18:A23 and the units in B18:B23. You can use some constants from A2:A9 in your formulae, if
needed. Write formulae only; do not write actual numerical results. For example, if I type any
number for grams of Spike Nails into cell A18, then the cost in dollars for that quantity of Spike
Nails should automatically appear in cell D18. You write the formula to go in D18 in terms of input cell
A18 and the cell addresses of the required conversion constants. Use only cell addresses in your formulae;
do not use actual numbers.

Cell A12: =(A4*A5)
Cell A13: =(A3*A4*A5)
Cell A14: =(A2*A3*A4*A5)
Cell A15: =(A6*A7)
Cell D18: =(A18)*(C7/A15)
Cell D19: =A19*(C6*A7)
Cell D20: =A20*(C5/A6)
Cell D21:
Cell D22:
Cell D23:

So far , I got A12:A15 correct, but D18:D23, I cannot seem to get,I thought i got D18 and D19 correct, but it was not, so i cannot get D20:D23 either. Help please and thank you.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Math - Vectors

    If "u = (2,2,-1)", "v = (3,-1,0)" and "w = (1,7,8)", verify that "u (dot) (v + w) = u (dot) v + u (dot) w". My work: LHS: u (dot) (v + w) = (2,2,-1) (dot) (4,6,8) = [(2,2,-1) (dot) (3,-1,0)] + [(2,2,-1) (dot) (1,7,8)] = [u (dot) v] …
  2. chemistry

    Dear Dr. Bob, Go to this website listed and you will see that this is not a take home exam. This is my professor's website and you can see his comment on the exams we took today 7/7/10. I just want to know what my score is so I can …
  3. Fibonacci numbers

    I have been working on this question all day and can not figure out what to do. The question says according to the Quadratic Formula, the solutions of x^2-x-1=0 I know the positive solution is the golden rule ratio and the negative …
  4. Trig

    Can anyone help with this question. Now suppose that, starting with the first row of seats, the floor of the seating area is inclined at an angle of Theta = 25 degrees above the horizontal, and the distance that you sit …
  5. Trig - Please help

    Can anyone help with this question? Now suppose that, starting with the first row of seats, the floor of the seating area is inclined at an angle of Theta = 25 degrees above the horizontal, and the distance that you sit
  6. Chemistry

    Hi everyone, I really need help with this problem. What is the reactant, products, and what compounds is it?
  7. Word study slash english

    What are some words with the ay slash igh sound
  8. Vectors: Dot product

    Given a and b unit vectors if |a+b|=square root 3, determine (2a-5b)dot(b+3a) First I foiled the whole thing: =2(a dot b)+ 6 (a dot a) - 5(b dpt b) -15(a dot b) =-13(a dot b) + 6(a dot a) - 5(b dot b) =-13(1)(1)+6-5 =-13+1 =-12 Textbook …
  9. Vectprs and Scalars

    Why are some of these scalars and others are vectors?
  10. Math

    4. The CGJ girls plan to string a set of lights diagonally from two vertical poles for overhead lighting for dancing on the right side of the deck (see the diagram). The string of lights is sold in foot increments only. How many feet …

More Similar Questions