8:31 V OH+ "Use the following figur..Cost. [03 marks] 7 6/7" C Chegg .. . X Exercise 5 Objectives: Working with Sum IF and Count IF statements. Inserting Charts. Sales and Profit Report . First Quarter 2012 2 City Jan Feb Mar Average Mastmm 3 Cool New York $22,000.00 $29,000.00 $19,000.00 * CQ02 Los Angeles $42,000 00 $39,000.60 $43,000 00 London $18,000 09 $20,000.00 $22,000.00 6 Paris $35,000.00 $26,000.00 $31,000.0 Munich $12,000.00 $15,000.00 $13,080.00 B Total Sales Cost $83,000.00 $84,000.00 $43,000.00 Profi 10% Bonus Total Sales greater than 30,000 No Sales greater than 30,060 1. Create the worksheet shown above. 2. Set the Text alignment, Columns width and high appropriately. 3. Use AutoFill to put the Series Numbers into cells A5:47. 4. Format cells C3:G7, C8:811, C13:E13 to include dollar sign with two decimal places. 5. Find the Average Sales and Maximum Sales for each City. 6. Find the Total Sales for each Month. 7, Calculate the Profit for each month , where profit = Total Sales - Cost B. Calculate the 10% Bonus, which is 10% of the Profit. 9. Find the Total Sales for each Month; only for sales greater than 30,000. 10. Find the No of Sales for each Month; only for sales greater than 30,000. 11. Create the following Charts: Sales and Profit Maximum Sales in each city $35.090.0 New york Parts 6 |Page Solved Exercise 5 Objectives: Working Visit with Sum IF and Count ... Images may be subject to copyright. Learn More Related content Objectives: . Working with Sun IF and Count IF statements. . Working will San IF and Conn IF sametors ! Did you find these results useful? Yes No