Create a new Excel worksheet. Name it PaintUsername. If your username is SorgeRA, then the filename would be Paint SorgeRA. Use no spaces. Use caps as shown. F Enter the following. Save often. A B C D 1 Paint Calculator 2 Room Length 3 Width 4 Height 5 Area of the walls 6 Coats of paint 7 Paint @ 400 sq ft 16 ft 13.5 ft 9 ft sq ft 2 gallons o Begin each with a space. Cell E5: Calculate the area of the walls. The walls consist of 4 rectangles. Add the area of each wall. When simplified, the calculation becomes: 2 * (Length + Width) * Height To write the formula find the cell that contains each of these three values. Remember, all Excel formulas must begin with the equal sign. =2* (E2+E3) *E4 Cell E7: Calculate the number of gallons needed to paint the walls with the number of requested coats of paint. Cell E6 contains the number of coats. Multiplying E5 and E6 will result in the total square feet of paint. Cell C7 contains the amount of area of wall covered by a single gallon. Dividing the total square feet of paint (E5*E6) by the number of square feet a single gallon of paint will cover (C7) will give the total number of gallons. If you need part of a gallon, you will need to purchase a full gallon; therefore this calculation will need to be rounded up. =ROUNDUP (E5*E6/07,0) Complete the table by formatting cells E2, E3, and E4 to show 1 decimal in all numbers. Adjust the column widths. Shade cells. Draw borders (thin on the inside and thick on the outside). Center title above the table. (If you need assistance with these basic Excel skills, then either study the Online Help with Excel found on the syllabus, read and study a book on Excel, or go to the tutor center for assistance.) B DE F 1 Paint Calculator Room Length 16 ft 3 Width 13.5 ft 4 Height 9 ft 5 Area of the walls 531 sq ft 6 Coats of paint 2 7 Paint @ 400 B gallons 8 sq ft This paint calculator spreadsheet is an example of an operational decision making process. This table is used in the day-to-day operation of a paint store in helping a customer determine the amount of paint needed to paint a room in a house. A more complete table would be needed to calculate the amount of a single color paint for multiple rooms