The worksheet named ElectronicsSales contains information about several sales made at an electronics store. A salesperson’s name will be entered in B17. (6 points) a. Write an Excel formula that can be copied from C17 to D17:F17 that will extract that salesperson’s radio sales to C17, TV sales to D17, printer sales to E17, and CD sales to F17. b. Make necessary changes to the data file and make the search more flexible. In other words, use Data Validation to allow a user of the model to choose one salesperson from the list, and one product from the list, and then write a formula to show up the units sold automatically.

The volume v and paper surface area a of a conical paper cup are given by where r is the radius of the base of the cone and h is the height of the cone. a. by eliminating h, obtain the expression for a as a function of r and v. b. create a user-de ned function that accepts r as the only argument and computes a for a given value of v. declare v to be global within the function. c. for v ! 10 in.3 , use the function with the fminbnd function to compute the value of r that minimizes the area a. what is the corresponding value of the height h? investigate the sensitivity of the solution by plotting v versus r. how much can r vary about its optimal value before the area increases 10 percent above its minimum value?