Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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's
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.25Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started