Today's+Schedule

1. Open the file on Page 516 or Class Files --> IIT --> Excel --> Chapter 3 --> E22Try 2. In cell J4 calculate the percentage for Tamika by taking the amount she sold (I4) and dividing it by the Weekly Total amount (E22). 3. Copy the formula down to John Baker (J9). 4. Fix the formula so it will work properly. (Go back to J4 and change the formula to use an absolute reference for the Weekly Total). 5. Select G3:G9 and J3:J9 and create a 3D Pie Chart. 6. Position the chart under the data on the worksheet. 7. Modify the chart title to say Percentage of Sales 8. Add Data Labels to the chart. (Hint: Plus (+) sign.) 9. Save the file to today’s folder
 * Warm Up (March 14 & 15) **