![]() Add data labels to the end of the data markers showing the revenue for each car model.ħ. Move the bar chart to the range B11:F21 of the Analysis worksheet. In the Car Models worksheet, create a clustered bar chart of the data in the range A4:B9. John wants to present the company revenue broken down by car type. ![]() Repeat Step 3 for the data in the range A16:B17 of the Rentals by Type worksheet, placing the pie chart comparing revenue between the Americas and International sales in the range J5:J9 of the Analysis worksheet.Ħ. Repeat Step 3 for the data in the range A11:B12 of the Rentals by Type worksheet, placing the pie chart comparing Leisure and Commercial sales in the range H5:H9 of the Analysis worksheet.ĥ. Add data labels to the outside end of the two slices showing the percentage of the Airport vs. Remove the chart title from the pie chart.Ĭ. Move the chart cover the range D5:F9 in the Analysis worksheet.ī. Create a pie chart of the data in the range A6:B7. In the Rentals by Type worksheet, do the following:Ī. John wants the report to include pie charts that break down the current year's revenue in terms of market (Airport vs. In the Documentation sheet, enter your name and the date in the range B3:B4.ģ. Save the workbook as NP_EX_4_Certus in the location specified by your instructor.Ģ. Open the NP_EX_4-3.xlsx workbook located in the Excel4 > Case1 folder included with your Data Files. ![]() John is developing a market report for an upcoming sales conference and needs your assistance in summarizes market information into a collection of Excel charts and graphics. Data File needed for this Case Problem: NP_EX_4-3.xlsxĬertus Car Rental John Tretow is an account manager for the Certus Car Rental, an industry-leading car rental firm that serves customers across the United States and overseas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |