SOLUTION: Shane is working with a spreadsheet on his computer. The spreadsheet will calculate the cost of the wood trim around rectangular windows based on the dimensions of the window and t

Algebra ->  Customizable Word Problem Solvers  -> Misc -> SOLUTION: Shane is working with a spreadsheet on his computer. The spreadsheet will calculate the cost of the wood trim around rectangular windows based on the dimensions of the window and t      Log On

Ad: Over 600 Algebra Word Problems at edhelper.com


    

Question 1011174: Shane is working with a spreadsheet on his computer. The spreadsheet will calculate the cost of the wood trim around rectangular windows based on the dimensions of the window and the price of the wood. The following entries have been made. Shane wants to enter a formula in the last column so that the spreadsheet will calculate the final cost of the job. Which of the following formulas should he enter?

Length of window in feet: A7
Width of window in feet: B7
Price per foot of wood trim: C7
Cost of trim for window: ______
Answer by Theo(13342) About Me  (Show Source):
You can put this solution on YOUR website!
the wood trim around the windows would be on the circumference of the window.
circumference of a rectangle is equal to 2 * length + 2 * width.
length is in A7.
width is in B7
price per foot is in C7
cost of trim for window would be equal to 2 * (A7 + B7) * C7
a picture of what the spreadsheet might look like is shown below.
see below the picture for further comments.
$$$

the formula in cell D7 is "=2*(A7 + B7)*C7"

this formula says:

add the contents in the cells A7 and B7 together and then multiply them by 2 * the contents in cell C7 and then place the result in cell D7.

the result is that you get 2 * (6 + 4) * 3.42 = 68.4 in cell D7.

the formula for perimeter is 2 * length + 2 * width.
the 2 can be factored out to get 2 * (length + width).
the total is then multiplied by the cost per foot.

that is the formula that you see in cell D7.

in excel, the equal sign (=), tells excel that the contents of the cell contain a formula and that excel must execute the formula and then display the results in that same cell.