Microsoft

Dunder-Mifflin Yearly Report

INSTRUCTIONS Step 1: Step 2: Apply the Accounting Number Format to Cells B4:G12 Step 3: Apply the Total Style to Cells A9:G9 Step 4: Select Cell F4; enter the formula to calculate Commission Commmission = (Gross Sales - Expenses- Promotions) * 10% Step 5: Use Cell F4's fill handle to copy the Commission formula through F8 Step 6: Select Cell G4; enter the formula to calculate Total Salary Total Salary = Starting Salary + Commission Step 7: Use Cell G4's fill handle to copy the Total Salary formula through G8 Step 8: Hide the "$" symbol for Cells B5:G8 Step 9: In Cell B9, use a function to calculate the sum of Cells B4:B8 Step 10: In Cell B10, use a function to calculate the average of Cells B4:B8 Step 11: In Cell B11, use a function to determine the highest value of Cells B4:B8 Step 12: In Cell B12, use a function to determine the lowest value of Cells B4:B8 Step 13: Select Cells B9:B12; use the fill handle to copy the functions through G9:G12 Step 14: If needed, resize columns to ensure content in cells is visible (not hidden)