Answered>Order 2421

  1. 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.)
  2. 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.
  3. Copy the IF function to the range D2:G2.
  4. View the Mobile Phone Sales worksheet in Page Layout view. Set the margins to Wide, and set the page orientation to landscape.
  5. View the Mobile Phone Sales worksheet in Page Break Preview. Insert manual page breaks at cells A18, A32 and A46
 
"Not answered?"
Get the Answer
/by