Consider the following worksheet of monthly sales of five products. You select the range B$16$:F$16$ and then you click the AutoSum button on the Home ribbon. Next, you create range names for each product's column: for example, you create the range name Product$\_1$ for the monthly sales in column B$.$ Which of the following is true?

a$.$ The formulas won't yet contain range names, and the quickest way to get them to contain range names is to select Apply Names from the Define Names dropdown list on the Formulas ribbon.

b$.$ The formulas won't yet contain range names, and the quickest way to get them to contain range names is to select each formula individually and type in the corresponding range name, replacing the cell reference.

c$.$ The formulas won't yet contain range names, and the quickest way to get them to contain range names is to select Paste Names from the Use in Formula dropdown list on the Formulas ribbon.

d$.$ Each formula will contain the corresponding range name. For example, the formula in cell D$16$ will be