Question: 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

 Using the constants in cells A2:A9, create formulae for cells A12:A15

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 TA Physical Units 101 ??? Per an 2.54 cm per inch Lumberyard Units $2.50S/foot Cherry S0.70 ?/foot White Pine $1.50 $/foot Red Oak $1.00 ?/pound Finish Nails S0.75 ?/pound Roof Nails 12 inches per fooit 5280 feet per mile 453.5973 grams per po pounds per ton $900.00?/ton Spike Nails 1001 an per meter 1000 meters per kn 10 Your First Set of Answers 12 13 14 15 16 17 Input Quantity in Specified Units Output in Dollars 18 19 20 21 inches per mile cm per mmile mper mile grams per ton Your Second Set of Answers grams of Spike Nails tons of Roof Nails grams of Einish Nails meters of Red 0ak iles of White pi 23 kilometers (kn) of Cherr

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!