1- For any month selected in cell B8 (again, note use of drop-down menu), report the average number of units sold for that month in cell C8. No intermediate (additional) cells may be used (created) to perform the calculation.

2- In cell C11, report the dollar value sold for the selected part (in B5), for the given month (B8). No intermediate (additional) cells may be used (created) to perform the calculation.