(Solved): 1. In cell D7, enter a formula without using a function that divides the Cost of sales value in cel ...

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 \( \ 13: D 15 \), and the range D17:D19. In the range D17:D19, copy the formula and number formatting only. Profit and Loss Statement For the year 2022