I need an explanation for this Excel question to help me study.
i need some one to do 2 Excel projects, i will provide the instructions in a file with numbers for each.
i need you to open the file that i uploaded and work on it. DO NOT OPEN A NEW ONE.
Excel file number 1 for instructions # 1.___Excel file number 2 for instructions # 2.Classic Gardens and Landscapes (CGL) Revenue for Quarters 2 and 3 Revenue Categories Lawn Maintenance April $7.886,48 July $7.650,23 August $7.683,30 September Total $46.715,63 Tree & Shrubbery $11.819,93 $11.909,48 $12.043,13 $11.803,28 $11.879,78 $12.226,28 $71.681,85 Patio and Furniture $15.192,23 $13.070,48 $12.957,30 $13.039,88 $15.318,23 $16.876,13 $86.454,23 Design Consulting $7.741,13 June $8.094,38 Fountains and Irrigation $7.660,13 May $4.478,18 $4.708,13 $4.475,25 $5.153,63 $5.514,53 $7.919,55 $32.249,25 $579,38 $585,23 $631,13 $563,18 $584,78 $698,40 $3.642,08 Total Revenue $39.729,83 $38.014,43 $37.993,28 $38.210,18 $40.980,60 $45.814,73 $240.743,03 Central Sierra Insurance Personal Lines Policy by Agent Policy Type Automobile Homeowners Recreational Vehicle Valuable Items AJP 155 230 28 12 RLN 201 318 54 2 EMM 165 265 31 5 Policy Type by Agent 350 300 250 200 150 100 50 0 AJP RLN Automobile Homeowners Recreational Vehicle EMM Valuable Items AJP Automobile Homeowners Recreational Vehicle Valuable Items USING MICROSOFT EXCEL 2016 Independent Project 3-4 Independent Project 3-4 For 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. 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. Download start file Build a pie chart sheet. Use texture as fill. Add and format data labels in a chart. 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. 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 Major Sales Revenue on one line, then press Enter and type Second and Third Quarters on the second line. 5. Apply chart Style 14 to the chart. 6. Format the first line and the second line of the chart title to a font size of 20 pt. 7. Apply a ½ point Black, Text 1 outline to the chart area.