Complete the following steps to determine the total deposits received for each tour. a. In cell D2, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for all Corfu Sailing Voyage tours. Use Corfu Sailing Voyage as the criteria argument, Tour InfolTour] as the range argument, and Tour_Info[Deposits Received] as the sum_range argument in your formula.
b. In cell D3, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for each Nepal Trekking tour Use Nepal Trekking as the criteria argument, Tour_Info[Tour] as the range argument, and Tour_Info[Deposits Received] as the sum_rang argument in your formula.
c. In cell D4, enter a formula using the SUMIF function that totals the amounts in the Deposits Received column for each Hiking Patagonia tour. Use Hiking Patagonia as the criteria argument, Tour_Info[Tour as the range argument, and Tour_Info[Deposits Received] as the sum_range argument in your formula.

Create a function (prob3_6) that will do the following: input a positive scalar integer x. if x is odd, multiply it by 3 and add 1. if the given x is even, divide it by 2. repeat this rule on the new value until you get 1, if ever. your program will output how many operations it had to perform to get to 1 and the largest number along the way. for example, start with the number 3: because 3 is odd, we multiply by 3 and add 1 giving us 10. 10 is even so we divide it by 2, giving us 5. 5 is odd so we multiply by 3 and add one, giving us 16. we divide 16 (even) by two giving 8. we divide 8 (even) by two giving 4. we divide 4 (even) by two giving 2. we divide 2 (even) by 2 to give us 1. once we have one, we stop. this example took seven operations to get to one. the largest number we had along the way was 16. every value of n that anyone has ever checked eventually leads to 1, but it is an open mathematical problem (known as the collatz conjectureopens in new tab) whether every value of n eventually leads to 1. your program should include a while loop and an if-statement.