Question

The formula for cell D2 is shown in the spreadsheet. WEST Using the same pattern, write a formula for for call C4 YOU WILL NOT BE USING THE ACTUAL NUN BERS IN THE CELLS

Answer 1

Let,

A4 = Length

B4 = Width

C4 = Height

D4 = Volume

To write a formula for Cell C4, it means we will make a formula in computing the Height when the Length, Width, and Volume are given.

But before that, based on the spreadsheet data given, it is presumed to be data (length, width, and height) of a rectangular prism and its volume.

The formula for the Volume of a Rectangular Prism:

`\text{Length x Width x Height = Volume}`

To compute for the Height,

`\text{ Height = }\frac{Volume}{Length\text{ x Width}}`

Or,

`\text{ C4 = }\frac{D4}{A4\text{ x B4}}`

This equation, when put in the spreadsheet, will be,

= (D4)/(A4*B4)