Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service. For one service recognition program, you need to calculate the length of service in complete months. What is the correct formula?

Afriend of mine is giving a dinner party. his current wine supply includes 10 bottles of zinfandel, 8 of merlot, and 11 of cabernet (he only drinks red wine), all from different wineries. (a) if he wants to serve 3 bottles of zinfandel and serving order is important, how many ways are there to do this? ways (b) if 6 bottles of wine are to be randomly selected from the 29 for serving, how many ways are there to do this? ways (c) if 6 bottles are randomly selected, how many ways are there to obtain two bottles of each variety? ways (d) if 6 bottles are randomly selected, what is the probability that this results in two bottles of each variety being chosen? (round your answer to three decimal places.) (e) if 6 bottles are randomly selected, what is the probability that all of them are the same variety? (round your answer to three decimal places.)