PLEASE I NEED THE STEP BY STEP OF HOW TO DO THIS IN EXCEL ASAP, THANK YOU
Student Instructions: You must complete this and save as Activity 4.3 Excel Project Your Name Sheett. Rename a New Sheet with the name Products Create a Table with 6 columns and 20 Products. The names for this columns are: Product Number Product Name Description Retail Price Qy Stock Store Sheet 2. Rename a New Sheet with the name Invoice. You must create an Invoice format as presented in the image below. In this Invoice you must bring the information of the Products Sheet using Data Validation in the Product Name and complete the rest of the information in the Product #Column and in the Unit Price column. Using VLookUp in almost 10 products (Product Name Code, Price) Also, include a Quantity (Cty) column and a Total column to calculate the total (Unit Price x Qty) Include in a cell the Invoice subtotal, a cell to calculate the NU of 11.5% and a cel of the Total (Sum of Subtotal and IV calculated) - You must create a button related to a Macro to clean the fields. Considerate that this action will not eliminate the Data Validation and the formulas related podium 1 Date Product Region SalesRep Customer Units Sales COGS 2 1/23/13 Quad West Sioux DFR 23 $621.00 $333.50 3 1/18/13 Quad West Pham TTT 65 $1,235.00 $520.00 4 6/19/13 Quad West Pham FM 47 $587.00 $434.75 5 6/13/13 Quad MidWest Smith PLOT 24 $648.00 $348.00 6 4/6/13 Quad South Pham JAQ 58 $1,102.00 $464.00 7 3/2/13 Quad West Franks ET 22 $594.00 $319.00 8 3/24/13 Quad East Smith JAQ 8 $216.00 $116.00 9 2/27/13 Quad South Smith ET 29 $551.00 $232.00 10 6/19/13 Quad West Chin ZAT 55 $1,265.00 $605.00 11 5/17/13 Quad Midwest Franks ZAT 39 $897.00 $429.00 12 4/11/13 Quad Midwest Pham DFGH $931.00 $392.00 13 2/15/13 Quad Midwest Pham KBTB 63 $1.449.00 $693.00 14 2/20/13 Quad South Smith ITTW 19 $513.00 $275,50 15 1/9/13 Quad Midwest Chin LOP 40 $1,080.00 $580.00 16 4/4/13 Quad East Smith YTR 60 $1,620.00 $870.00 17 4/17/13 Quad South Chin WT 24 $504.00 $222.00 18 1/22/13 Bellen Pham BBT 10 $220.00 $100.00 19 2/9/13 Sunshine East Smith GRR 26 $494.00 $208.00 20 5/15/13 Sunshine West Pham WFMI 65 $1,235.00 $520.00 West Student Instructions: You must complete this and save as Activity 4.3 Excel Project Your Name Sheett. Rename a New Sheet with the name Products Create a Table with 6 columns and 20 Products. The names for this columns are: Product Number Product Name Description Retail Price Qy Stock Store Sheet 2. Rename a New Sheet with the name Invoice. You must create an Invoice format as presented in the image below. In this Invoice you must bring the information of the Products Sheet using Data Validation in the Product Name and complete the rest of the information in the Product #Column and in the Unit Price column. Using VLookUp in almost 10 products (Product Name Code, Price) Also, include a Quantity (Cty) column and a Total column to calculate the total (Unit Price x Qty) Include in a cell the Invoice subtotal, a cell to calculate the NU of 11.5% and a cel of the Total (Sum of Subtotal and IV calculated) - You must create a button related to a Macro to clean the fields. Considerate that this action will not eliminate the Data Validation and the formulas related podium 1 Date Product Region SalesRep Customer Units Sales COGS 2 1/23/13 Quad West Sioux DFR 23 $621.00 $333.50 3 1/18/13 Quad West Pham TTT 65 $1,235.00 $520.00 4 6/19/13 Quad West Pham FM 47 $587.00 $434.75 5 6/13/13 Quad MidWest Smith PLOT 24 $648.00 $348.00 6 4/6/13 Quad South Pham JAQ 58 $1,102.00 $464.00 7 3/2/13 Quad West Franks ET 22 $594.00 $319.00 8 3/24/13 Quad East Smith JAQ 8 $216.00 $116.00 9 2/27/13 Quad South Smith ET 29 $551.00 $232.00 10 6/19/13 Quad West Chin ZAT 55 $1,265.00 $605.00 11 5/17/13 Quad Midwest Franks ZAT 39 $897.00 $429.00 12 4/11/13 Quad Midwest Pham DFGH $931.00 $392.00 13 2/15/13 Quad Midwest Pham KBTB 63 $1.449.00 $693.00 14 2/20/13 Quad South Smith ITTW 19 $513.00 $275,50 15 1/9/13 Quad Midwest Chin LOP 40 $1,080.00 $580.00 16 4/4/13 Quad East Smith YTR 60 $1,620.00 $870.00 17 4/17/13 Quad South Chin WT 24 $504.00 $222.00 18 1/22/13 Bellen Pham BBT 10 $220.00 $100.00 19 2/9/13 Sunshine East Smith GRR 26 $494.00 $208.00 20 5/15/13 Sunshine West Pham WFMI 65 $1,235.00 $520.00 West
