TU09 - Chapter 4 - Baltimore Car Rental - V10 скачать в хорошем качестве

TU09 - Chapter 4 - Baltimore Car Rental - V10

TU09 - Chapter 4 - Baltimore Car Rental - V10 Project Description: Baltimore Car Rental is a local car rental company that has offices in four locations in Baltimore County. The Chairman for the Board of Director, Stephen Duke, has called for a special meeting to review the following: (1) Rental volume by month and vehicle; (2) The five-year history of customer complaints; (3) Is the company meeting it stated goal of turning over the entire fleet of "Off-Lease Vehicles" every three years?; and, (4) From an "Off-Lease" sales perspective, which vehicle appears to be the most popular in the Belair and Hunt Valley? Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named TU09 – Chapter 4 – Baltimore Car Rental - Starting File.xlsx. The system should have automatically added your last name to the beginning of the filename. If not, please do so now then save the file to the same location where your other EBTM250 files are being stored. 0 2 The student acknowledges that this document, along with any associated files, are for the student's private use only and, in addition, are proprietary to Towson University and cannot be sold, copied, shared and/or bartered to third parties without the expressed written consent of Towson University or the author/creator of the work. In Cell R1 of the "AnnualData" tab, type "I Accept" to acknowledge your understanding of the preceding statements along with its' personal use only limitation. 1 3 Before getting started, update the workbook Theme to "Office 2013 - 2022 Theme". 2 4 After opening the Starting File you will see a column chart under the data table. Move the chart to the upper-left corner of cell B12 and drag the lower-right corner of the chart to H26. Now update that chart as follows: 1) Add the months of July, August and September (so that the last 6-months are shown). 2) Switch the row and column data so that the months July to December are shown in the Legend (on the horizontal x-axis). 3) Modify the appearance of the chart to Layout 5. 4) Change the color combinations to Colorful Palette 4. 5) Update the description of the Primary Vertical axis to "Rentals". 6) The Chart Title should read "Baltimore Rentals: July to December". 8 5 Create a 3-D Pie Chart on the "AnnualData" worksheet as follows: 1) Use the data in cell ranges B5:B10 and P5:P10. 2) Move the chart so the upper left corner is inside cell I12 and the lower right corner is in cell P26. Hint: The Pie Chart will display the number of annual rentals for the six auto types shown in column B. 11 6 To help users have a better understanding of the chart's contents, make sure you incorporate a descriptive chart title. On the 3-D pie chart, update the title to "Annual Car Rentals for BCR". Change the font of the title to Arial Black, 16 pt., and then apply bold. 6 7 Continue to update the 3D chart as follows: 1) Add data labels to the outside end of each slice (6 in all). 2) Format the data labels to only display the category name and percentage. 3) Change the font size of the labels to 8 and apply bold. 4) Because data labels were added, the chart legend is no longer necessary. Remove it. 5) Update the 3-D orientation. Have the X Rotation = 165 degrees; Y Rotation = 30 degrees and the Perspective = 25 degrees. 6) Finally, explode the slice of the chart that represents the Vintage Vehicles by 20%. 10 8 The "Baltimore Rentals: Last Quarter" Bar Chart also needs updating. While the six vehicles are shown along the vertical axis, the Legend displays Series3, Series2 and Series1. Update the Legend to have "series1" display "December", "series2" display "November" and "Series3" display "October". Then update the chart Style to 4. 6 9 You will now be creating a 4th chart on the "AnnualData" tab. Highlight cell range B5:B10 and I5:I10. Click on the "column" option and then the sub-option "3-D Clustered Column". The screen will display two possibilities. Choose the chart with six blue columns (not the milti-colored option). This chart represents the Semi-Annual Total for all auto types for the first six month of the year. Simply move the chart somewhere to the below the 3-D Pie Chart. No specific location. 6 10 Now, using the ribbon, move the newly created 3-D column chart from the "AnnualData" worksheet to a new worksheet. Name the new worksheet "SemiAnnualReport". Once moved, update the chart's appearance to Style 3 and update to color of the columns to Monochromatic Palette 6. To make the "Convertibles" column standout from the other 5 vehicles, you will need to change the color of that column to Orange, Accent 2. Hint: Moving the chart is a one step process... only requiring one click. 3 11 Next, update the chart title to display "Semi-Annual Rentals for BCR" and make sure the title is Bolded. Adjust the 3-D Rotation of the chart 17 Save and close TU09 – Chapter 4 – Baltimore Car Rental.xlsx. Exit Excel. Submit the file as directed