Answered step by step
Verified Expert Solution
Link Copied!

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'simage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions