Question: Please answer the question in the yellow only. I only need to know the formula's Wolfie's receives phone calls asking for estimates. Create a two-value

Please answer the question in the yellow only. I only need to know the formula'sPlease answer the question in the yellow only. I only need toknow the formula's Wolfie's receives phone calls asking for estimates. Create a

Wolfie's receives phone calls asking for estimates. Create a two-value data table (cells C9:P29) for anyone answering the phone to quickly provide such estimate. Begin this by creating a formula in cell C6 to calculate the total cost based on values (manually enter) in C4 & C5. Costs per square foot Total Square Footage Total Cost QUICK ESTIMATE Square feet 225 250 275 100 125 150 175 200 300 325 350 375 400 Item # C-1005 C-1010 C-1015 C-1020 C-1025 C-1030 C-1035 C-1040 C-1045 C-1050 F-2205 F-2210 F-2215 F-2220 F-2225 F-2230 F-2235 - F-2240 F-2245 F-2250 Description Lucky One $4.00 Tide Water 4.25 Bellbury 4.50 Rail Street 4.75 Boxton 5.00 Bluff 5.25 Mason 5.50 Ashcraft 5.75 Crossroads 6.00 Silver Mane 6.25 Laminate - Standard 8.00 Laminate - Lifeproof 8.25 Vinyl - Sheet 8.75 Vinyl - Luxury 9.25 Tile - Ceramic 9.75 Tile - Natural Stone 10.25 Tile - Mosaic 10.75 Hardwood - Cork 11.25 Hardwood - Engineere 11.75 Hardwood - Solid 12.25 Wolfie's receives phone calls asking for estimates. Create a two-value data table (cells C9:P29) for anyone answering the phone to quickly provide such estimate. Begin this by creating a formula in cell C6 to calculate the total cost based on values (manually enter) in C4 & C5. Costs per square foot Total Square Footage Total Cost QUICK ESTIMATE Square feet 225 250 275 100 125 150 175 200 300 325 350 375 400 Item # C-1005 C-1010 C-1015 C-1020 C-1025 C-1030 C-1035 C-1040 C-1045 C-1050 F-2205 F-2210 F-2215 F-2220 F-2225 F-2230 F-2235 - F-2240 F-2245 F-2250 Description Lucky One $4.00 Tide Water 4.25 Bellbury 4.50 Rail Street 4.75 Boxton 5.00 Bluff 5.25 Mason 5.50 Ashcraft 5.75 Crossroads 6.00 Silver Mane 6.25 Laminate - Standard 8.00 Laminate - Lifeproof 8.25 Vinyl - Sheet 8.75 Vinyl - Luxury 9.25 Tile - Ceramic 9.75 Tile - Natural Stone 10.25 Tile - Mosaic 10.75 Hardwood - Cork 11.25 Hardwood - Engineere 11.75 Hardwood - Solid 12.25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!