Independent Project 3-4Windows MacFor this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also build a pie chart sheet to graph the proportion that each category contributes to total revenue.[Student Learning Outcomes 3.1, 3.2, 3.3, 3.4, 3.5, 3.6]File Needed: ClassicGardens-03.xlsx (Available from the Start File link.)Completed Project File Name: [your name]-ClassicGardens-03.xlsxSkills Covered in This ProjectCreate a chart object.Size and position a chart object.Edit and format chart elements.Edit the source data for a chart.Build a pie chart sheet.Use texture as fill.Add and format data labels in a chart. Open the ClassicGardens-03.xlsx 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. Create a Clustered Column chart object for cells A4:G9. Move the chart object so that its top-left corner is at cell A12. Size the bottom of the chart to reach cell H30. Edit the chart title to display CGL Major Sales Revenue and press Enter to start a new line. On the second line, type Second and Third Quarters. Apply chart Style 14 to the chart. Format the first line and the second line of the chart title to a font size of 20 pt. Apply a 1 pt Black, Text 1 (second column) outline to the chart area. Verify that the chart is still selected. In the highlighted range in the worksheet, drag the resize pointer to remove the Design Consulting data series from the chart (Figure 3-71).Figure 3-71 Resize the chart by dragging the resize pointer Create a 3-D Pie chart sheet for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Tools Design tab, Location group]. Edit the chart title to display Revenue by Category. Change the font size to 32. Select the legend and change the font size to 12. Apply the Woven mat texture fill (first row, fourth column) to the Patio and Furniture slice.Select the pie shape and add data labels to display in the center of each slice. Display the Format Data Labels task pane, choose the Accounting format [Label Options button, Number group], and set 0 decimal places. Change the data label font size to 14 pt and apply bold [Home tab, Font group]. Deselect the chart. Save and close the workbook (Figure 3-72). Upload and save your project file. Submit project for grading.Figure 3-72 Excel 3-4 completed worksheet and chart

Company BackgroundZYZ is a leading provider in the mortgage space, they have over 1 million customers that they deal with.ZYZ's services span mostly the mortgage space between lenders and sellers alike. Within their company they have many mundane data entry tasks that occur on a daily basis, whilst employees have not complained they would like to help clear these tasks so employees can better use their time.As a part of this the CTO has taken charge and wants to begin incorporating RPA into their internal process’s. He wants to keep a close eye on the project whilst delegating it to a manager to help the project move where he cannot dedicate as much time. They are both at the same experience level of RPA. The CTO’s division looks after all things IT at the company, be it software or hardware systems.ScenarioFor some time ZYZ has been wanted to streamline their Auto Copy process as it’s a mundane task and the user has complained that they have to deal with a slow system spending 2-3 hours a day to get 200+ files completed. The task is repetitive and can be run at anytime of the day once a day but it prevents other tasks in the process from being completed if it isn’t done.The organization is keen to work through this quickly so that they can show the benefits of RPA to their company. The process is easy and straight forward however there are key things that must be checked before a file is completed out in the process. They have concerns on if the bot being created will be able to handle this.The only direction they have given so far is “We would like the bot to run efficiently and quickly, we would like it to be accurate in its steps whilst ensuring any issues that arise are dealt with appropriately”. Questions to discuss in the interview:Q: What are the basic requirements of this project?Q: What potential blockers or constraints/hinderances do you see to this process?Q: Who would you expect at the meeting for the process walkthrough and why?Q: What would you do to help kerb any anxiety the client has about RPA and their first process?Q: How would you present the solution to the clientQ: summarize or explain the scenario on how you understand it briefly