I need help with the formulas from question 8 to 12.

please and thank you.

Part 2 - Data Validation and Formulas 8. In cell F6 and A14:A38 create data validation rules that allows you to choose the Customer # and Item # from a list, using columns from the Customers and Products sheets as the sources. Create an Input Message and Error Alert for both validation rules. 9. Using Structured References, nest the following VLOOKUP functions, within IFERROR functions: In cells B7, B8, B9, and B10 create VLOOKUP functions that will display the required information based on what Customer # is chosen in cell F6. Use an IFERROR function to display nothing if a customer is not chosen or if there is an error. Test your functions, selecting Customer #2. (Auto fit columns if necessary.) In B14, D14, and E14 create VLOOKUP functions that will display the description, unit price, and discount based on what Item# is chosen in A14. Use an IFERROR function to display nothing if an item is not chosen or if there is an error. (Format numbers as currency.) (Auto fit columns if necessary.) [Test your functions by selecting an Item#.] In F14, create a formula to calculate the Total. (=Qty * Unit Price - Discount). Nest the formula in an IFERROR and display nothing if A14 is blank. Format numbers as currency Add a comment in F13: Does not include shipping. Shipping is calculated after subtotal. Figure 1 Company #2 placed an order, as shown in Figure 1. Type the Item# Qty order into the Invoice form. Z4567 5 Z4568 10 In Cell F40 create a formula to calculate the Subtotal. Z4569 15 In Cell F41 create a formula to calculate a 5% sales tax on all Z4570 20 orders. Use Named Cells in the formulas. (Format Numbers). Z4571 25 10. In Cell F42, use an IF function to calculate the shipping charge. Shipping is free if the customer orders 100 items or more. Orders with less than 100 items are charged $5.00 per item. (Hint: Nest SUM of Qty calculations inside the IF function). (Format numbers, and test your function).In F43 create a formula totaling the invoice. Part 3 - Protect Worksheets 11. Protect the Invoice worksheet so that only Customer#, Item#, and Qty cells can be edited. (No password). 12. Protect the Customers and Products worksheet so that no changes can be made. - = I - 12 Clipboard KI Font Alignment 37 fr G A B D E F Computer Warehouse 17705 NW Springville Rd. Hillsboro, Oregon 97229 BP: 971-555-5432 Email:sales@cw.com. 4 F: 971-555-2345 Website:www.computerwarehouse.com 5 3 Customer#: 7 Bill To: 8 Email: Invoice#: 9 Phone: Invoice Date: 10 Fax: 11 12 13 Item# Description Qty Unit Price Discount Total 14 15 16 17 18 19 20 21 22 23 24 Invoice Products Customers C21 fi E B Description Laptop Desktop Server Tablet Phone Monitor Printer Scanner Copier D Unit Price Discount $ 750.00 $ 100.00 $ 540.00 $ 50.00 $ 1,600.00 $ 200.00 $ 345.00 $ 40.00 $ 300.00 $ 30.00 $ 180.00 $ 25.00 $ 60.00 $ 10.00 $ 40.00 $ 10.00 $ 570.00 $ 70.00 A 1 Item # 2 Z4567 3 Z4568 4 Z4569 5 Z4570 6 Z4571 7 Z4572 8 Z4573 9 Z4574 10 74575 11 12 13 14 15 16 17 18 19 20 21 Invoice Products Customers Paste Styles K Number K Alignment Font Clipboard Customer # 1 v A B 1 Customer # Company Name Contact Name 2 1 Tailspin Toys Robert Lyon 3 2 Contoso, Ltd Sanjay Patel 4. 3 Depot Max 5 E F Address City State 345 Cherry Street Albany SD 567 Walnut Lane Moline MO 789 Main Street Portland OR G ZIP Code 23456 98765 97220 H Phone Em 432-555-0178 sor 432-555-0189 sor 503-230-4658 sor Bill Ryder 7 B 9 0 1 2 3 15 16 17 18 19 20 21 Invoice Products Customel: Allg er # ct Name Lyon Patel der D E F Address City State 345 Cherry Street Albany SD 567 Walnut Lane Moline MO 789 Main Street Portland OR ZIP Code 23456 98765 97220 H J Phone Email Fax 432-555-0178 someone@example.com 432-555-0187 432-555-0189 someone@example.com 432-555-0123 503-230-4658 someone@example.com 530-555-0123 Part 2 - Data Validation and Formulas 8. In cell F6 and A14:A38 create data validation rules that allows you to choose the Customer # and Item # from a list, using columns from the Customers and Products sheets as the sources. Create an Input Message and Error Alert for both validation rules. 9. Using Structured References, nest the following VLOOKUP functions, within IFERROR functions: In cells B7, B8, B9, and B10 create VLOOKUP functions that will display the required information based on what Customer # is chosen in cell F6. Use an IFERROR function to display nothing if a customer is not chosen or if there is an error. Test your functions, selecting Customer #2. (Auto fit columns if necessary.) In B14, D14, and E14 create VLOOKUP functions that will display the description, unit price, and discount based on what Item# is chosen in A14. Use an IFERROR function to display nothing if an item is not chosen or if there is an error. (Format numbers as currency.) (Auto fit columns if necessary.) [Test your functions by selecting an Item#.] In F14, create a formula to calculate the Total. (=Qty * Unit Price - Discount). Nest the formula in an IFERROR and display nothing if A14 is blank. Format numbers as currency Add a comment in F13: Does not include shipping. Shipping is calculated after subtotal. Figure 1 Company #2 placed an order, as shown in Figure 1. Type the Item# Qty order into the Invoice form. Z4567 5 Z4568 10 In Cell F40 create a formula to calculate the Subtotal. Z4569 15 In Cell F41 create a formula to calculate a 5% sales tax on all Z4570 20 orders. Use Named Cells in the formulas. (Format Numbers). Z4571 25 10. In Cell F42, use an IF function to calculate the shipping charge. Shipping is free if the customer orders 100 items or more. Orders with less than 100 items are charged $5.00 per item. (Hint: Nest SUM of Qty calculations inside the IF function). (Format numbers, and test your function).In F43 create a formula totaling the invoice. Part 3 - Protect Worksheets 11. Protect the Invoice worksheet so that only Customer#, Item#, and Qty cells can be edited. (No password). 12. Protect the Customers and Products worksheet so that no changes can be made. - = I - 12 Clipboard KI Font Alignment 37 fr G A B D E F Computer Warehouse 17705 NW Springville Rd. Hillsboro, Oregon 97229 BP: 971-555-5432 Email:sales@cw.com. 4 F: 971-555-2345 Website:www.computerwarehouse.com 5 3 Customer#: 7 Bill To: 8 Email: Invoice#: 9 Phone: Invoice Date: 10 Fax: 11 12 13 Item# Description Qty Unit Price Discount Total 14 15 16 17 18 19 20 21 22 23 24 Invoice Products Customers C21 fi E B Description Laptop Desktop Server Tablet Phone Monitor Printer Scanner Copier D Unit Price Discount $ 750.00 $ 100.00 $ 540.00 $ 50.00 $ 1,600.00 $ 200.00 $ 345.00 $ 40.00 $ 300.00 $ 30.00 $ 180.00 $ 25.00 $ 60.00 $ 10.00 $ 40.00 $ 10.00 $ 570.00 $ 70.00 A 1 Item # 2 Z4567 3 Z4568 4 Z4569 5 Z4570 6 Z4571 7 Z4572 8 Z4573 9 Z4574 10 74575 11 12 13 14 15 16 17 18 19 20 21 Invoice Products Customers Paste Styles K Number K Alignment Font Clipboard Customer # 1 v A B 1 Customer # Company Name Contact Name 2 1 Tailspin Toys Robert Lyon 3 2 Contoso, Ltd Sanjay Patel 4. 3 Depot Max 5 E F Address City State 345 Cherry Street Albany SD 567 Walnut Lane Moline MO 789 Main Street Portland OR G ZIP Code 23456 98765 97220 H Phone Em 432-555-0178 sor 432-555-0189 sor 503-230-4658 sor Bill Ryder 7 B 9 0 1 2 3 15 16 17 18 19 20 21 Invoice Products Customel: Allg er # ct Name Lyon Patel der D E F Address City State 345 Cherry Street Albany SD 567 Walnut Lane Moline MO 789 Main Street Portland OR ZIP Code 23456 98765 97220 H J Phone Email Fax 432-555-0178 someone@example.com 432-555-0187 432-555-0189 someone@example.com 432-555-0123 503-230-4658 someone@example.com 530-555-0123