Apply currency format with 0 decimal places to cells B3:D6.

3. Apply bold formating to labels in Row 2 and Column A.

4. In cell E2 type Total.

5. In cell F2 type Goal.

6. In cell G2 type Bonus.

7. Merge and Center the contents of cell A1 in A1:G1. Bold the text and increase the font size to 16.

8. Select cells B2:G2 and center (bold any headings if necessary).

9. In cell E3 enter a formula that adds up the sales for the three months. Increase the width of column E if necessary. Point to the fill handle of E3 and drag down to E6 to copy the formula down for each store.

10. In cells F3:F6 type 250000, 150000, 200000, & 250000. Apply currency style with 0 decimal places and increase the column width if necessary.

11. In cell G3 enter an IF function that compares the first quarter total sales for Store 1 to its goal and displays 10% of the total sales if the store made or surpassed their goal and 0 if it did not make their goal. Point to the fill handle of G3 and drag down to G6 to copy the formula down for each store. If necessary, apply currency formatting and increase column width.

12. Save the file as DataAnalysisProblem and submit in the drop-box with that name.

NOTES: The format of an IF statement: =IF(logical test, value if true, value if false). Columns E and G must use formulas or functions, you will not get full credit without them. Remember if you need to review Excel, login to SkillSoft and go through online lessons. You can also use Help in Excel.

Total Goal Bonus 1st Quarter Sales Date January Febuary March 3 Store 1 $ 85,123.00 $67,000.00 $ 99,562.00 4 Store 2 $ 45,000.00 $ 42,099.00 $ 46,525.00 5 Store 3 $98,987.00 $ 65,444.00 $36,289.00 6 Store 4 $ 75,555.00 $ 70,100.00 $ 76,598.00 Total Goal Bonus 1st Quarter Sales Date January Febuary March 3 Store 1 $ 85,123.00 $67,000.00 $ 99,562.00 4 Store 2 $ 45,000.00 $ 42,099.00 $ 46,525.00 5 Store 3 $98,987.00 $ 65,444.00 $36,289.00 6 Store 4 $ 75,555.00 $ 70,100.00 $ 76,598.00