Use the following Excel spreadsheet to answer Questions 7 and 8. The spreadsheet

Question

Use the following Excel spreadsheet to answer Questions 7 and 8. The spreadsheet above is used to record test scores and shows the test scores of some of the students. Write down the formula which should go in cell E2. Write down the formula which should go in cell B6. A reinforced concrete design indicates an ultimate moment of the slab is equal to 682.9 ft-lb. Converting the ultimate moment to in-lb. is most nearly equal to which of the following. a. 56.91 in-lb b. 8, 196 in-lb c. 4, 097 in-lb d. Cannot be converted. The actual pressure for a strip footing is 5,000 psf. Converting to kips/sq middot ft is mostly nearly equal to which of the following. a. 50 b. 1,000 c. 5 d. 500

Explanation / Answer

7) Formula in cell E2 -

= SUM(B2:D2)

8) Formula in cell B6 -

=MIN(B2:B5)

9) 1 ft = 12 inch

so, 682.9 ft-lb = 682.9 x 12 inch-lb = 8194.8 in-lb

answer - b) 8196 in-lb

10) 1 kips = 1000 pound force

so, 1 pound force = .001 kips

so, 5000 psf (pounds per square feet) = 5000 x .001 kips / sq.ft = 5 kips / sq.ft

Answer. c) 5

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.