# PSU METBD 050 - Formatting & Cell Formulas (2 pages)

Previewing page*1*of 2 page document

**View the full content.**## Formatting & Cell Formulas

Previewing page *1*
of
actual document.

**View the full content.**View Full Document

## Formatting & Cell Formulas

0 0 78 views

Lecture Notes

- Pages:
- 2
- School:
- Pennsylvania State University
- Course:
- Metbd 050 - Creating a Text String in Excel

**Unformatted text preview: **

METBD 050 Homework 5 Formatting Cell Formulas Download the file Truss xls from the webpage and format it as shown in the figure below 12 point Bold Width 10 29 Width 9 29 Width 8 43 MERGE 12 Point Arial Bold Yellow or White fill in internal vertical borders in THREE places D6 J18 is WHITE FILL Figure is available for insertion after next class MERGE 10 Point Arial Bold in FIVE places White Fill Light Turquoise Fill Tan Fill Rose Fill All text is 10 point Arial font unless noted otherwise Note the justification of the text as well as the number of decimal places displayed Match the borders as given above H5 050 Formatting CellFormulas doc 1 24 05 Bold Text Page 1 of 2 Cell Formulas Add cell formulas to your worksheet as follows You are to calculate each value by hand calculations before proceding to write the cell formulas 1 In cell B9 the height of the truss is computed using the formula based on the length of the truss and its pitch Length Pitch Height 24 2 In cells B19 C25 compute the coordinates of the truss joints A G based on the span L and the height H of the truss Use the dimensions shown in the figure on the first page when computing the coordinates 3 In cells B30 B40 write the cell formulas to determine the length of each member using the distance formula and the coordinates you computed in cells B19 C25 4 In cells G21 F23 write the cell formulas to determine the reactions of the truss The reactions are the forces that the truss supports must provide to maintain equilibrium of the truss The formulas for the reactions are as follows P H Q R 2S 2 L 3 3 Ax Q Ey Ay P R S Ey 5 In the Page Setup Dialog box be sure to set the print area to be printed on one page wide by one page tall as shown in the figure below Also be sure to display the gridlines and column and row headers Do this each time you print a worksheet for this class 6 Change the Span in your worksheet to 20 and the pitch to 3 and print out your worksheet to a single page Staple your hand calculations

View Full Document