Objective: Upon completion of this activity you will be able to apply formulas and functions discussed through Excel topics Student Instructions: 1. Excel Activity 2. Download the project titled Activity 4.3 Excel Project Instructions and Activity. 43 Excel Project Book and complete it. 3. You will have 1 attempt to submit 4. It its important to follow all the instructions. Remember to save you project as indicated in the instructions 5. This project has 50 points value. 6. For due date refer to the Calendar located in the "Tools" menu in Blackboard. IE 2611: Computer Tools II Activity 4.3 Excel Project Student Instructions: You must complete this and save as Activity 4.3 Excel Project_Your Name Sheet 1: Rename a New Sheet with the name Products. o Create a Table with 6 columns and 20 Products. The names for this columns are: Product Number Product Name Description Retail Price Qty Stock Store Sheet 2. Rename a New Sheet with the name Invoice. You must create an Invoice format as presented in the image below. o 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 (Qty) column and a Total column to calculate the total (Unit Price x Qty) o Include in a cell the Invoice subtotal, a cell to calculate the IVU of 11.5% and a cell of the Total (Sum of Subtotal and IVU 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. B c D E G H 1 Date Product Region SalesRep Customer Units Sales COGS 2 1/23/13 Quad West Sioux IDFR 23 $621.00 $333.50 3 1/18/13 Sunshine West Pham TTT 65 $1,235.00 $520.00 4 6/19/13 Sunset West Pham FM 47 $987.00 $434.75 5 6/13/13 Quad MidWest Smith PLOT 24 $648.00 $348.00 6 4/6/13 Sunshine 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 Sunshine South Smith ET 29 $551.00 $232.00 10 6/19/13 Carlota West Chin ZAT 55 $1,265.00 $605.00 11 5/17/13 Carlota Midwest Franks ZAT 39 $897.00 $429.00 12 4/11/13 Sunshine Midwest Pham DFGH 49 $931.00 $392.00 13 2/15/13 Carlota 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 Sunset South Chin WT 24 $504.00 $222.00 18 1/22/13 Bellen West 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 21 5/19/13 Carlota MidWest Sioux TTT 43 $989.00 $473.00 22 5/7/13 Sunshine South Gault AA 20 $380.00 $160.00 23 4/20/13 Bellen West Gault WEMI 39 $858.00 $390.00 24 4/9/13 Sunset Midwest (Gault ET 33 $693.00 $305.25 25 5/5/13 Sunshine East Chin HII 6 $114.00 $48.00 26 5/5/13 Carlota East Chin KPSA 33 $759.00 $363.00 27 3/14/13 Bellen MidWest Pham TIT 34 $748.00 $340.00 28 1/11/13 Bellen MidWest Smith KPSA 23 $506.00 $230,00 29 5/13/13 Carlota MidWestGault QT 6 $138.00 $66.00 30 4/23/13 Sunset South Smith FM 15 $315.00 $138.75 31 3/22/13 Carlota South Pham ITTW 27 $621.00 $297.00 32 1/18/13 Sunset South Pham DFGH 36 $756.00 $333.00 33 6/24/13 Bellen MidWestGault SFWK 64 $1,408.00 $640.00 34 2/7/13 Sunset MidWest Gault JAQ 44 $924.00 $407.00 35 3/19/13 Carlota South Pham TIT 54 $1,242.00 $594.00 36 6/3/13 Quad MidWest Smith HII 21 $567.00 $304.50 37 3/26/13 Sunset East Franks DFGH 40 $840.00 $370.00 38 4/26/13 Carlota South Smith AST 22 $506.00 $242.00 39 4/26/13 Sunset MidWest Gault MNGD 51 $1,071.00 $471.75 Objective: Upon completion of this activity you will be able to apply formulas and functions discussed through Excel topics Student Instructions: 1. Excel Activity 2. Download the project titled Activity 4.3 Excel Project Instructions and Activity. 43 Excel Project Book and complete it. 3. You will have 1 attempt to submit 4. It its important to follow all the instructions. Remember to save you project as indicated in the instructions 5. This project has 50 points value. 6. For due date refer to the Calendar located in the "Tools" menu in Blackboard. IE 2611: Computer Tools II Activity 4.3 Excel Project Student Instructions: You must complete this and save as Activity 4.3 Excel Project_Your Name Sheet 1: Rename a New Sheet with the name Products. o Create a Table with 6 columns and 20 Products. The names for this columns are: Product Number Product Name Description Retail Price Qty Stock Store Sheet 2. Rename a New Sheet with the name Invoice. You must create an Invoice format as presented in the image below. o 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 (Qty) column and a Total column to calculate the total (Unit Price x Qty) o Include in a cell the Invoice subtotal, a cell to calculate the IVU of 11.5% and a cell of the Total (Sum of Subtotal and IVU 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. B c D E G H 1 Date Product Region SalesRep Customer Units Sales COGS 2 1/23/13 Quad West Sioux IDFR 23 $621.00 $333.50 3 1/18/13 Sunshine West Pham TTT 65 $1,235.00 $520.00 4 6/19/13 Sunset West Pham FM 47 $987.00 $434.75 5 6/13/13 Quad MidWest Smith PLOT 24 $648.00 $348.00 6 4/6/13 Sunshine 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 Sunshine South Smith ET 29 $551.00 $232.00 10 6/19/13 Carlota West Chin ZAT 55 $1,265.00 $605.00 11 5/17/13 Carlota Midwest Franks ZAT 39 $897.00 $429.00 12 4/11/13 Sunshine Midwest Pham DFGH 49 $931.00 $392.00 13 2/15/13 Carlota 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 Sunset South Chin WT 24 $504.00 $222.00 18 1/22/13 Bellen West 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 21 5/19/13 Carlota MidWest Sioux TTT 43 $989.00 $473.00 22 5/7/13 Sunshine South Gault AA 20 $380.00 $160.00 23 4/20/13 Bellen West Gault WEMI 39 $858.00 $390.00 24 4/9/13 Sunset Midwest (Gault ET 33 $693.00 $305.25 25 5/5/13 Sunshine East Chin HII 6 $114.00 $48.00 26 5/5/13 Carlota East Chin KPSA 33 $759.00 $363.00 27 3/14/13 Bellen MidWest Pham TIT 34 $748.00 $340.00 28 1/11/13 Bellen MidWest Smith KPSA 23 $506.00 $230,00 29 5/13/13 Carlota MidWestGault QT 6 $138.00 $66.00 30 4/23/13 Sunset South Smith FM 15 $315.00 $138.75 31 3/22/13 Carlota South Pham ITTW 27 $621.00 $297.00 32 1/18/13 Sunset South Pham DFGH 36 $756.00 $333.00 33 6/24/13 Bellen MidWestGault SFWK 64 $1,408.00 $640.00 34 2/7/13 Sunset MidWest Gault JAQ 44 $924.00 $407.00 35 3/19/13 Carlota South Pham TIT 54 $1,242.00 $594.00 36 6/3/13 Quad MidWest Smith HII 21 $567.00 $304.50 37 3/26/13 Sunset East Franks DFGH 40 $840.00 $370.00 38 4/26/13 Carlota South Smith AST 22 $506.00 $242.00 39 4/26/13 Sunset MidWest Gault MNGD 51 $1,071.00 $471.75