In cell D$7,$ enter a formula without using a function that divides the Cost of sales value in cell C$7$ by

the revenue amount, using the defined name Revenue for the Charlotte worksheet. Copy the

formula from cell D$7$ to the range D$9$:D$11,$ the range D$13$:D$15,$ and the range D$17$:D$1\%.$ In the range

D$17$:D$19,$ copy the formula and number formatting only.

X Create a formula without using a function.

In the Charlotte worksheet, the formula in cell D$7$ should contain a reference to the defined

name "Revenue".

X Copy a formula into a range.

In the Charlotte worksheet, cell D$7$ contains an incorrect formula.

X Copy a formula into a range.

In the Charlotte worksheet, only the formula and the number format should be copied to the

range D$17$:D$79.$ The range should be formatted using the White. Background $1.$ Darker $15\%$ fill

color.