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.

How do I install the data validation in Section B

Starting on the Inventory tab, (cell C10 ), enter a whole dollar amount for the first carpet type. Assume each carpet type that follows below (cells C11C19 ) is higher quality and a bit more expensive. Increase the unit price by even increments of $0.25$0.75. Do the same for Flooring types (cells C20-C29) 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. 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. Create a macro that copies and pastes this example into a new tab. This macro should also remove any customer specific data, item \#s and square footage. Create a button to run this macro on the Sample Invoice tab. Add two invoices to the workbook and label one tab as Blank Invoice, and the other a friend or family member's name. Complete this invoice with sample data including customer data, items and square footage of a two bedroom one bath home. Email completed file to your instructor. Starting on the Inventory tab, (cell C10 ), enter a whole dollar amount for the first carpet type. Assume each carpet type that follows below (cells C11C19 ) is higher quality and a bit more expensive. Increase the unit price by even increments of $0.25$0.75. Do the same for Flooring types (cells C20-C29) 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. 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. Create a macro that copies and pastes this example into a new tab. This macro should also remove any customer specific data, item \#s and square footage. Create a button to run this macro on the Sample Invoice tab. Add two invoices to the workbook and label one tab as Blank Invoice, and the other a friend or family member's name. Complete this invoice with sample data including customer data, items and square footage of a two bedroom one bath home. Email completed file to your instructor