Question

Green oak has a density of 60 pounds per cubic foot. A block of this wood is 1 foot long, 2 feet wide and 3 feet deep. Create a spreadsheet which calculates how much the block weighs. Your spreadsheet should use the following techniques: 1) Short equations rather than one long equation 2) Separate inputs, calculations and outputs 3) Use cells which contain the values of the input parameters such as Width, rather than hardcoding the number 2 into a formula (for example) 4) Name cells 5) Create formulas for calculations AFTER naming the cells so that the formulas will also include names. 6) What do you think the answer should be-is this what you calculated? Try some other test values to see if it is calculating correctly. For instance, try calculating the weight of a 1 foot x 1 foot x 1 foot block of wood which has a density of 50 pounds per square foot and see if your spreadsheet gives the answer you predict. B(Ctr)

Answer 1

Spreadsheet should have 4 cell inputs:

Density, Length, Width and Depth

1) Formula is simple = Density*Length*Width*Height (because block is cuboid)

2) Inputs are taken in 4 cells and output in the 5th , Here is how the table looks

Density	60
Length	1
Width	2
Height	3
Weight	360

3) this is what the cells would look like

You can name the cells in Excel if you want