1. Create a spreadsheet in Excel with the following labels and data 1 1st Quarte
ID: 372146 • Letter: 1
Question
1. Create a spreadsheet in Excel with the following labels and data 1 1st Quarter Sales Data January February March 3 Store 1 85123 6700099562 4 Store2 5 Store3 9898765444 36289 6 Store475555 70100 76598 7 45000 42099 46525 2. Apply currency format with 0 decimal places to cells B3:06. 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 82:62 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 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 o 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 in Excel. I, login to Skillsoft and go through online lessons. You can also use HelpExplanation / Answer
The picture is slightly blurred so rephrasing what I could read: In cell G3 enter an if function that compares the first qtr total sales for store 1 to its goal and displays 10% of total sales if th store made or surprised their goal
and 0 if it did not mak its goal. Point to the full handle of G3 and drag down to G6 to copy the formula to each
store. If necessary, apply currency formatting and increase column height
We would use the formula for G3=IF(E2<F2,0,(E2/10)) and drag it to the end. This gives us the required values as shown below
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.