14. A table is used to record the June retail sales of ten southeastern states. (Refer to worksheet "3.14.) a. Name each cell in the range B2:B12 by its cor- responding state abbreviation from column A. (For example, cell B2 should be named "FL.") Set the current workbook as the scope of these names. b. Name the entire Monthly Sales column Monthly Sales." Set worksheet 3.14 as the scope of this name. C. In cell A14, calculate the sum of the sales values using range names. (This can be done using names from part a or part b above.) 14. A table is used to record the June retail sales of ten southeastern states. (Refer to worksheet "3.14.) a. Name each cell in the range B2:B12 by its cor- responding state abbreviation from column A. (For example, cell B2 should be named "FL.") Set the current workbook as the scope of these names. b. Name the entire Monthly Sales column Monthly Sales." Set worksheet 3.14 as the scope of this name. C. In cell A14, calculate the sum of the sales values using range names. (This can be done using names from part a or part b above.)