Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please only answer the yellow highlighted Click on the Sample Invoice tab to view its example. To prevent errors, update column B of the sample
Please only answer the yellow highlighted
Click on the Sample Invoice tab to view its example. To prevent errors, update column B of the sample invoice using a data validation list of Item #s provided in the Inventory tab. Use vlookup to automatically display the description and unit price of the Item # shown. Add appropriate formulas to Price, Subtotal, Sales Tax and Total. Wolfie's Flooring Emporium 1701 Wright Street (608)246-6500 Email us at: Wolfie@WolfiesFlooring.com Madison, WI 53704 Website: WolfiesFlooring.com Bill To: Sample Customer Phone: (555) 555-1212 Invoice #: Address: 123 Main Street, Anywhere, WI 53000 Contact: Ms. Customer Invoice Date: Room Item # Description Square footage Unit Price Price Living Room C-1005 Lucky One 300 $3.00 $900.00 Kitchen F-2210 Laminate - Lifeproof 140 9.75 1,365.00 Master Bedroom C-1015 Bellbury 225 $4.00 900.00 Master Bath F-2230 120 12.75 1,530.00 Tile - Natural Stone Boxton Bedroom #1 C-1025 130 $5.00 650.00 Bedroom #2 C-1030 Bluff 130 $5.50 715.00 Subtotal $6,060.00Step 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