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 Seek to figure it out the best solution.

3. (b) 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.(c) 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 3 questions are from MSC142 (Visual Programming For Business) course. This is a course on Microsoft excel. Kindly solve these 3 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.