Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
Copy the formula in cell C3 to the range D3:G3 to find the percentage of total sales for each region. ( Hint: Make sure you used an absolute...
- Copy the formula in cell C3 to the range D3:G3 to find the percentage of total sales for each region. (Hint: Make sure you used an absolute reference in the formula you copied.)
- In cell C2, use an IF function to test whether the percentage of total sales in 2016 for Region 1 is greater than or equal to 15%. If it is, the formula returns "Good Sales"; otherwise, it leaves the cell blank.
- Copy the IF function to the range D2:G2.
- View the Mobile Phone Sales worksheet in Page Layout view. Set the margins to Wide, and set the page orientation to landscape.
- View the Mobile Phone Sales worksheet in Page Break Preview. Insert manual page breaks at cells A18, A32 and A46
