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.

Acolor class has three public, integer-returning accessor methods: getred, getgreen, and getblue, and three protected, void-returning mutator methods: setred, setgreen, setblue, each of which accepts an integer parameter and assigns it to the corresponding color component. the class, alphachannelcolor-- a subclass of color-- has an integer instance variable, alpha, containing the alpha channel value, representing the degree of transparency of the color. alphachannelcolor also has a method named dissolve (void-returning, and no parameters), that causes the color to fade a bit. it does this by incrementing (by 1) all three color components (using the above accessor and mutator methods) as well as the alpha component value. write the dissolve method.