3 (a) What do you understand by Data Validation Write briefly in your excel sheet Make a table with imaginary data set you can make by your own and create appropriate table Consider these three variables with dropdown option for imaginary Product Name , 11 Digit product ID , and BDT currency Production Cost 3 (b) Use the V lookup and figure out the price of large jacket from the table I am giving the table below ProdSize Product Size Price Shirt Medium Shirt Medium 22 Shirt Large Shirt Large 24 Jacket Medium Jacket Medium 60 Jacket Large Jacket Large 65 These questions are from MSC142 (Visual Programming For Business) course This is a course on Microsoft excel Kindly solve these question on Microsoft excel and show me your workings step by step You can solve it on Microsoft Excel and click picture and send me step by step Kindly read the question carefully and solve these questions If you have any question kindly knock me and then solve the question Take your time Thanks

The Answer is in the image, click to view ...

Question: 3. (a) What do you understand by Data Validation? Write briefly in your excel sheet. Make a table with imaginary data set you can make

3. (a) What do you understand by Data Validation? Write briefly in your excel sheet. Make a table with imaginary data set you can make by your own and create appropriate table; Consider these three variables with dropdown option for imaginary. "Product Name", "11 Digit product ID", and "BDT currency Production Cost".

3.(b) Use the V-lookup and figure out the price of large jacket from the table. I am giving the table below:

ProdSize	Product	Size	Price
Shirt\|Medium	Shirt	Medium	22
Shirt\|Large	Shirt	Large	24
Jacket\|Medium	Jacket	Medium	60
Jacket\|Large	Jacket	Large	65

These questions are from MSC142 (Visual Programming For Business) course. This is a course on Microsoft excel. Kindly solve these question on Microsoft excel and show me your workings step by step. You can solve it on Microsoft Excel and click picture and send me step by step. Kindly read the question carefully and solve these questions. If you have any question kindly knock me and then solve the question. Take your time. Thanks.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

3. (a) Suppose that you want to pay off your home loan in 15 years, the annual interest rate is 14 percent and you can afford to pay only BDT 25000 each months, then how much you can borrow? Use Goal...

IN JAVA Lab: Performance Experiments Objective Your goal for this lab is to experiment with different implementations of the NaturalNumber kernel and of the power function and compare their...

Exp19_Access_App_CapAssessment - Student Loans 1.0 Project Description: Quill Financial Services has recently started working with student loans. You will build the company's database. The initial...

c. Make sure your chart's axes and title are deflection will be measured along the y-axis and 1/I will Excel Charts Project appropriately labeled. Include units with your axis be measured along the...

inputs.txt: Konya Bursa Ankara A1 B1 C1 A2 B2 C2 4 print reserve_seat Ahmet Konya A1 0 reserve_seat Kamer Bursa A1 1 reserve_seat Cemal Ankara A1 2 reserve_seat Elif Konya B1 2 reserve_seat Mehmet...

please i need help! Background: Your company has just acquired a new subsidiary that makes two products, Clodhopper and Clodbuster. The Clodhopper is intended for the general consumer market and its...

Introduction In this exercise, you will undertake a data modeling project for Global Super Store. Scenario Global Super Store have collected huge amounts of data from their business operations within...

Recruitment at Salesteq Corporation = ROUND (number, num_digits) Assignment Purpose Where, Attracting employees by using different recruitment sources is an important aspect of human - number =...

Create a job description for Restaurant Server. 1. A job description including job title, company overview, job summary (purpose and duties), detailed list of duties, qualifications and KSA summary,...

Make sure to show a sample calculation for each type of calculation- showing all steps with proper units. SPH3U: Physics, Grade 11, University Preparation Unit 5: Electricity and Magnetism Lab...

only information given Stockholm Construction Company has contracted to build an office building. The construction began on January 1, 20X4 and the estimated date of completion is July 1, 20X7. The...

If 36.28 mL of a standard 0.3744 M KOH solution reacts with 57.50 mL of CH 3 COOH solution, what is the molarity of the acid solution?

Match the following business activities to the steps in capital budgeting process.Business activities: 1 . A manager evaluates progress one year into the project . 2 . Employees submit suggestions...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...