Question

1. → In-cell-D7,-enter-a-formula-without-using-a-function-that-divides the-Cost-of-sales-value- in-cell-C7-by-the-revenue-amount, using the defined-name-Revenue-for-the-Charlotte- worksheet.-Copy-the-formula-from-cell-D7-to-the-range-D9: D11, the-range-D13:D15,-and- the range D17:D19.-In-the-range-D17:D19,-copy-the-formula-and-number-formatting- only.1​

Answer 1

Assuming the defined name "Revenue" refers to the cell containing the revenue amount, the formula to divide the cost of sales in cell C7 by the revenue amount is:

=C7/Revenue

To copy this formula to the specified ranges, follow these steps:

Select cell D7 and enter the above formula.

Copy the formula by pressing Ctrl+C (or Command+C on a Mac).

Select the range D9:D11, then paste the formula by pressing Ctrl+V (or Command+V on a Mac).

Select the range D13:D15, then paste the formula by pressing Ctrl+V (or Command+V on a Mac).

Select the range D17:D19.

Press Ctrl+V (or Command+V on a Mac) to paste the formula.

While the cells are still selected, press Ctrl+Shift+V (or Command+Option+V on a Mac) to bring up the Paste Special dialog box.

In the Paste Special dialog box, select "Formulas" and "Number formats".

Click "OK" to apply the formula and number formatting to the selected cells.