Grader Instructions Excel 2019 Project Yo19 Ch04 Assessment

Question

Grader Instructionsexcel 2019 Projectyo19 Excel Ch04 Assessment Exp Download and open the file named Excel_Ch04_Assessment_Express.xlsx . Save the file to your storage location. Create a 3-D Pie chart using the ranges A5:A10 and O5:O10 on the AnnualData worksheet to display the number of annual rentals for six car types. Position the chart with its upper left corner in cell H12 and lower right corner in cell O26. Change the chart title to "Annual Rentals," format the title to Arial Black, 16 pt, and bold. Add data labels to the chart to show category names and percentages, positioned outside the chart. Set data label font size to 8 and bold, then remove the legend. Explode the slice representing the auto type with the lowest percentage of rentals by 20%. Below the data, locate the clustered column chart and change its type to a line chart. Extend the data range to include July, August, and September, and switch row/column so that months July to December are on the x-axis. Format the line chart by applying Chart Style 6, adding primary major vertical gridlines, and changing the chart title to "Rentals by Auto Type for July to December." Create a 3-D Clustered Column chart using ranges A5:A10 and H5:H10 for the Semi-Annual Total for all auto types. Move this chart to a new chart sheet titled "SemiAnnualReport." Add the title "Semi-Annual Total," bold it, and adjust the 3-D rotation to X=130 and Y=40. Add data labels with font size 14, bold, and position at the data points. Finally, move the "SemiAnnualReport" worksheet to the right of the "AnnualData" worksheet, save your workbook, and close Excel.

Dr. Jack HW Helper · Accepted Answer

The following report details the steps taken to create and format various charts in an Excel workbook to facilitate a visual analysis of vehicle rental data for Express Car Rental. These actions aim to enhance data comprehension and presentation quality for strategic decision-making purposes. Introduction Graphical representation of data is an essential feature in business analytics, providing viewers with quick insights that might be overlooked in raw data. In this context, leveraging Excel's charting capabilities allows for layered visualizations—pie charts, column charts, and line charts—that collectively offer a comprehensive overview of vehicle rental patterns across different time periods and vehicle types. This report describes the process of creating such visualizations, emphasizing formatting choices that improve clarity and aesthetic appeal. Creating the Pie Chart for Annual Rentals The process commenced with opening the specified Excel file, followed by saving it in the desired directory to ensure data safety. Using data ranges A5:A10 and O5:O10 on the "AnnualData" worksheet, a 3-D Pie chart was inserted. Proper positioning within the worksheet was achieved by setting the upper left corner at cell H12 and the lower right corner at cell O26, maximizing visual balance. To facilitate rapid understanding, the chart was titled "Annual Rentals," with the title formatted in Arial Black, 16-point font, and made bold, ensuring it stands out. Data labels were added directly onto each pie slice, displaying both category names and the corresponding percentages. Positioning the labels outside the slices prevents overlap and maintains readability. The labels' font size was set to 8, and they were made bold to enhance visibility. Removing the legend, typically redundant when data labels are present, contributed to a cleaner visual. To underscore the lowest rental category, the corresponding slice was "exploded" outward by 20%, creating a visual emphasis that highlights

Grader Instructions Excel 2019 Project Yo19 Ch04 Assessment

Grader Instructionsexcel 2019 Projectyo19 Excel Ch04 Assessment Exp

Paper For Above instruction

Introduction

Creating the Pie Chart for Annual Rentals

Transforming the Column Chart into a Line Chart

Creating and Formatting the Semi-Annual Total Chart

Final Arrangement and Saving

Conclusion

References