Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

PLEASE I NEED THE STEP BY STEP OF HOW TO DO THIS IN EXCEL ASAP, THANK YOU image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Modern Auditing

Authors: William C. Boynton, Walter G. Kell, Raymond N. Johnson, Dr William Boynton

7th Edition

047118909X, 978-0471189091

More Books

Students also viewed these Accounting questions

Question

42. Determine za for the following: a. a .0055 b. a .09 c. a .663

Answered: 1 week ago

Question

7. Understand the challenges of multilingualism.

Answered: 1 week ago