Excel Data Analysis Problem 1. Create a spreadsheet in Excel with the following labels and data: 2. 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
Excel Data Analysis Problem
1. Create a spreadsheet in Excel with the following labels and data:
2. 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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
