Just do the excel

User Generated

TviraUO

Computer Science

Temple University

Description

i promise this excel is very easy, i hope someone can help me to finish it, thank you so much. i can give your more tip.

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project YO16_XL_CH04_GRADER_PS2_AS - Express 1.3 Project Description: Thomas Reynolds is the corporate buyer for vehicles put into service by Express Car Rental. Tom has the option to buy several lots of vehicles from another rental agency that is downsizing. He wants to get a better idea of the number of rentals nationwide by vehicle type. The corporate accountant has forwarded Tom a worksheet containing rental data for last year. Tom wants to use this summarized data but feels that embedding charts will provide a quicker analysis in a more visual manner for the chief financial officer at their meeting next week. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step 1 2 3 4 Points Possible Instructions Start Excel. Open the file named e02ch04Express.xlsx. Save the file with the name e02ch04Express_LastFirst, replacing LastFirst with your name. 0.000 Use the cells A5:A10 and O5:O10 on the AnnualData worksheet to create a 3-D Pie chart of the number of annual rentals for the six car types. Reposition the chart so the upper left corner is inside cell H12. On the 3-D pie chart, change the title to Annual Rentals. Change the font of the title to Arial Black, 16 pt, and bold. Add data labels on the pie chart to include the category name and percentage only. Position the label information on the outside end of the chart. Change the font size of the labels to 8 and apply bold. Remove the legend. Explode the slice of the chart that represents the auto type with the lowest percentage of annual rentals by 20%. 13.000 8.000 12.000 5 Click the clustered column chart located below the monthly data. Change the chart type to Line. 10.000 6 Increase the data used in the line chart to include the months of July, August, and September. Switch the row and column data so that the months July to December are represented on the x-axis. 9.000 7 Change the chart style to Style 6. On the line chart, add primary major vertical gridlines. Change the chart title to Rentals by Auto Type for July to December. 9.000 8 Create a 3-D Clustered Column chart using the cells A5:10 and H5:H10 for the Semi-Annual Total for all auto types on the AnnualData worksheet. The primary horizontal axis should be the auto types. 15.000 9 Move the 3-D column chart from the AnnualData worksheet to a chart sheet, and then name that worksheet SemiAnnualReport. 9.000 Updated: 05/02/2017 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Excel Project Points Possible Step Instructions 10 If necessary, add the chart title Semi-Annual Total to the chart. Bold the title. Adjust the 3D Rotation of the chart to have a X rotation of 30 and a Y rotation of 20. Add Data Labels to the chart. Change the size of the data labels to 14 and then bold. 11 12 13 Reposition the SemiAnnualReport worksheet after the AnnualData worksheet. 5.000 Insert the File Name in the left footer section of AnnualData worksheet. 2.000 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. Total Points Updated: 05/02/2017 2 8.000 0.000 100.000 Current_Instruction.docx Express Car Rental Auto Type Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic Jan 300 500 250 150 200 50 Feb 250 700 355 260 350 122 Mar 366 890 652 555 355 224 Chart Title 1400 1200 1000 800 600 400 200 0 Oct Nov Dec Annual National Rental Data/ Vehicles Rented by Type Created by Thomas Reynolds SemiAnnual Total Apr May Jun Jul Aug 522 477 699 2614 899 862 755 899 788 4532 566 425 553 650 800 3260 788 1056 456 556 652 2629 1230 1855 233 155 132 1425 355 523 126 98 155 775 189 166 Sep 566 655 852 658 458 137 Oct 855 547 544 578 598 199 Nov 588 689 455 355 168 99 Dec 288 588 977 1155 198 66 Annual Total 6672 8002 7932 8460 3725 1631
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you so much

Express Car Rental
Annual National Rental Data/ Vehicles Rented by Type
Created by Thomas Reynolds

Auto Type
Green Collection
Compact/Midsize
Full-size/Standard
SUV/Minivan
Sports car
Relic

Jan
300
500
250
150
200
50

Feb
250
700
355
260
350
122

Mar
366
8...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags