9:35 Search Back Questions of Assignment 4.docx Please answer the following questions by umy VBA programing, Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save your work as a Macro- enabled Workbook, and submit it on Canvas, Reopen your Macro-enabled workbook before you submit to ensure that your VBA programs are correctly saved and workable. Please highlight your final answer in Excel Q1. One of the best known mathematical formulas is Pythagorean Theorem, which tells us the relationship between the two legs and the hypotenuse in a right triangle. The two legs meet at a 90 angle and the hypotenuse is the longest side of the right triangle and is the side opposite the right angle. The theorem shows that, where e is the length of the hypotenuse, and a and b are the lengths of the remaining two legs Use VBA to create a function with two parameters (i.e. a and b) as the inputs of two legs' lengths, and use Pythagorean Theorem to calculate the length of the hypotenuse. Show the answer when a is 5 and bis 8 Q2. Create a function to calculate the commission that follows the rule below. The commission rate applies to the total sales. Please calculate the commission for $200 sales, $3.500 sales. $8.000 sales, $12,000 sales and 2,000,000 sales. (Use If-Elseif- Else) Comra Sale Sales1,000 1.000 Sales