Chapter_2_&_3 - CISM 2530 Advanced Business Apps....

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CISM 2530 Advanced Business Apps. Dion Designwear Profit Analysis Product DescriptionCost Profit Units Sold Total Sales Total Profit 4835 Coat 247.63 144.83 95,159 37346101.14 13781877.97 5. Use Conditional Formatting to highlight the total sales less than 8,000,000 with light red fill format 7563 Custom 210.08 142.18 75,762 26687922.12 10771841.16 6. Merge and center cells A1:G1, increase the font size to 18 8191 Dress 186.53 99.48 69,297 19819634.97 6893665.56 7. Merge and center cells A2:G2, increase the subtitle font size to 18 8409 Hat 146.82 59.97 39,164 8098723.56 2348665.08 8. Apply a theme workbook, select Trek 5677 Jacket 140.68 85.63 38,261 8658846.91 3276289.43 9. select range A2:G2, apply a background color orange accent 6 ligher 40% 8985 Shirt 68.38 8.15 42,420 3246402.6 345723 10. Use NOW function in cell F18. Now function is one of the 22 date and time functions available in Excel 5871 Slacks 144.54 30.44 68,536 11992429.28 2086235.84 7796 Sleepwear 93.74 11.8 77,413 8170168.02 913473.4 7777 Suit 305.91 126 19,999 8637768.09 2519874 8178 Sweater 112.21 9.24 61,257 7439662.65 566014.68 Totals 1656.52 717.72 587268 140097659.34 43503660.12 Lowest 68.38 8.15 19999 3246402.6 345723 Highest 305.91 144.83 95159 37346101.14 13781877.97 Average 165.652 71.772 58726.8 14009765.934 4350366.012 2/7/2012 21:59 Perform the following tasks 2. Use the fill handle to copy down the formulas for the remaining cells in column F, then apply a currency format with zero decimal points to cells F4:F13 3. Calculate the total profit in cell G4. The calculation should be Units Sold multiply by Cost, then subtracted from Total Sales (Note: The Profit should not have any negative numbers3....
View Full Document

This note was uploaded on 02/06/2012 for the course BUSA 1101 taught by Professor Staff during the Fall '11 term at Georgia Southern University .

Page1 / 4

Chapter_2_&_3 - CISM 2530 Advanced Business Apps....

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online