4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4 | COURSE NAME CIS108 - MASTER 20250127 скачать в хорошем качестве

4.3 Project: Excel Chapter 3 (SIMnet) Independent Project 3-4 | COURSE NAME CIS108 - MASTER 20250127

For Complete solution of Assignments and for the deal of complete Courses. Contact Me Contact Me For Help in Your Assignments and Courses WhatsApp : +923209088014 Email : myitlabservice@gmail.com WhatsApp Direct Link :https://wa.me/923209088014 We are handling all online courses, Business and Management, Business and Finance, Business and Accounting, HRM (Human resources management), History, English, literature, Nursing, Psychology, Statistics, IT (information technology), Applied sciences, Computer Science, Database Management system and many more. We will help you in weekly quizzes, assignments, Exam, thesis writing, Dissertation writing, SIMnet, Cengage Mindtap, Pearson MYITLAB and graduation all courses. We are dealing with complete courses in very reasonable prices. We can do complete MyITLab course , Microsoft Word ,Microsoft PowerPoint , Microsoft Excel , Microsoft Access and also linux assignments. #ExcelProject #MicrosoftExcel #SIMnet #CIS108 #OfficeApplications #ExcelCharts #ColumnChart #LineChart #BreakEvenAnalysis #DataVisualization #BusinessAnalytics #GrossMargin #FinancialAnalysis #ExcelSkills #SpreadsheetProject #ExcelForBusiness #CollegeAssignment #ExcelTraining #ExcelLearning #ChartFormatting 4.3 Project: Excel Chapter 3 (SIMnet) COURSE NAME CIS108 - MASTER 20250127 | 202512E OL CIS108 EO Office Applications K. Matthews Student Name: Harper, Timothy Student ID: timhar5066 Username: timhar5066 Start Date:12/12/202512:00 AMUS/Eastern Due Date:01/18/202611:59 PMUS/Eastern End Date:01/18/202611:59 PMUS/Eastern Independent Project 3-4 For this project, you create a column chart to graph profit margins for Classic Gardens and Landscapes. You also create a line chart to illustrate a break-even point in units for new catalog items. [Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.6] File Needed: ClassicGardens-03.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-ClassicGardens-03.xlsx Skills Covered in This Project Create a chart object. Size and position a chart object. Edit and format chart elements. Edit the source data for a chart. Build a line chart object. Edit axis labels. Position the legend. Add and format gridlines in a chart. Steps to complete This Project Mark the steps as checked when you complete them. 1. Open the ClassicGardens-03 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Use the Quick Analysis tool to create a Clustered Column chart object for cells A4:G9. 3. Move the chart object so that its top-left corner is at cell A12. Size the bottom of the chart to reach cell H30. 4. Edit the chart title to display CGL Gross Margin in Dollars on the first line. On the second line, type By Department. (In the Formula bar, press Alt+Enter to start a new line.) 5. Apply chart Style 14 to the chart. 6. Apply a 1 pt Black, Text 1 (second column) outline to the chart area. 7. Display the primary minor horizontal axis gridlines. Format the major value axis gridlines with a Black, Text 1 outline color. Do not change the color for the minor gridlines. (The Chart Elements drop-down list identifies the gridlines as Vertical (Value) Axis because they track values on the vertical axis.) 8. Resize the data range to remove the Design Consulting data series from the chart (Figure 3-84). Figure 3-84 Dragging the resize pointer 9. Select cell A1 and click the BreakEven sheet tab. 10. Review break-even formulas and build the data source for a line chart. a. Select cell B8. The margin per unit is calculated by subtracting the variable cost from the sales price. b. Select cell B10. The formula divides the fixed cost by the sales price minus the variable cost (margin per unit). The results are rounded to show no decimal places. c. Review the references and formulas in row 15. Build a table for the chart by copying the formulas in row 15 to the blank rows below it up to and including row 24. d. Select cell B5 and type 200. Verify that at this price, the break-even point is 200 units. This is the level at which the profit covers all costs. 11. Create a line chart. a. Select cells B14:C24 and E14:F24. b. c. Create a 2-D Line chart with markers for each line. Position the chart object to start at cell A26 and to reach cell H45.