Order ID:89JHGSJE83839 | Style:APA/MLA/Harvard/Chicago | Pages:5-10 |
Instructions:
Excel 2016 Project – Grader – Instructions
YO Excel16 Ch04 PS2 v3
Thomas Reynolds is the corporate buyer for Express Car Rental automobiles that are put into operation. Tom has the option of purchasing many lots of vehicles from a downsizing rental firm. He’d like to obtain a better picture of the amount of rentals by car type across the country. Tom has received a worksheet with rental data from the previous year from the corporate accountant. Tom wants to use this simplified data, but believes that embedding charts will give the chief financial officer a faster and more visual review at their meeting next week.
Perform the following steps:
Points Points Points Points Points Points Points Points Points Point
1
To begin, open Excel. Open the e02ch04Express.xlsx spreadsheet. Replace LastFirst with your name and save the file as e02ch04Express LastFirst. 0 2 Create a 3-D Pie chart showing the number of annual rentals for the six automobile kinds using the cells A5:A10 and O5:O10 on the AnnualData worksheet. Reposition the chart such that the upper left corner of cell H12 is inside it. Change the title of the 3-D pie chart to Annual Rentals. Change the title’s font to Arial Black, 16 pt, bold. 8 4 On the pie chart, add data labels with only the category name and percentage. Place the label information on the chart’s outer edge. Change the labels’ font size to 8 and make them bold. The legend should be removed. By 20 percent, expand the slice of the graphic that shows the vehicle type with the lowest percentage of annual rentals. 12 5 Hover your mouse over the clustered column chart below the monthly data. Select Line as the chart type. 10 6 Include the months of July, August, and September in the data used in the line chart. On the x-axis, switch the row and column data so that the months of July to December are displayed. 9 7 Change the chart style to Style 6 and add primary major vertical gridlines to the line chart. Change the title of the chart to July to December Rentals by Auto Type. 9 8 On the AnnualData worksheet, create a 3-D Clustered Column chart for the Semi-Annual Total for all auto types using the fields A5:10 and H5:H10. The auto kinds should be the dominant horizontal axis. 15
9 Copy the 3-D column chart from the AnnualData worksheet to a chart sheet, renaming it SemiAnnualReport.
9
10 If necessary, label the chart with the title Semi-Annual Total. The title is bold. Set the chart’s 3-D Rotation to 30 degrees on the X axis and 20 degrees on the Y axis. To the chart, add Data Labels. Change the data labels’ size to 14 and then make them bold. 8 11 After the AnnualData worksheet, reposition the SemiAnnualReport worksheet. 5 12 In the AnnualData worksheet’s left footer column, type the File Name. 2
13 Make a backup of the worksheet. Exit Excel after closing the workbook. As requested, turn in the workbook. 100 total points 0 total points 0 total points 0 total points 0 total points
1 YO Excel16 Ch04 PS2 v3 YO Excel16 Ch04 PS2 v3 YO Excel16 Ch04 PS2 v3 YO Excel16_
AnnualNationalRentalData/VehiclesRentedByType AnnualNationalRentalData/VehiclesRentedByType
Thomas Reynolds Auto Type is a typeface designed by Thomas Reynolds.
Semi-Annual Total January February March April May June
Jul Aug Sep Oct Nov Dec Annual Total Green Collection 300 250 366 522 477 699 2614 899 862 566 855 588 288 6672 Compact/Midsize 500 700 890 755 899 788 4532 566 425 655 547 689 588 8002 Full-size/Standard 250 355 652 553 650 800 3260 788 1056 852 544 455 977 7932 SUV/Minivan 150 260
Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 855 547 544 578 598 Oct Green Collection 199 Dec Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 588 689 455 355 168 99 Nov Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 288 588 977 1155 198 66 Dec Green Collection Compact/Midsize Full-size/Standard SUV/Minivan Sports car Relic 288 588 977 1155 198 66
RUBRIC |
||||||
Excellent Quality 95-100%
|
Introduction
45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Literature Support 91-84 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned. |
Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met. |
|||
Average Score 50-85% |
40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided. |
83-76 points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration. |
52-49 points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met. |
|||
Poor Quality 0-45% |
37-1 points The background and/or significance are missing. No search history information is provided. |
75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration. |
48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met |
|||
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow
Project Assignment in Excel 2016 |