Full question: 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.
Reading books is a great way to learn. Here are some of the books we recommend.
Click on cell D7 and enter
C7/Revenue. Copy and past the formula. In range D17:D19 make sure u just paste the formula not the stylings. Right click and it will give paste options.this answer is given in this link which has answer from qn 8 to 12 with video