Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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.00

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