Add data labels to the end of the data markers showing the revenue for each car model 7. Meie the bar churt to the range 811:21 of the Analysis worksheet. In the Car Models work sheet, create a clustered bar chart of the data in the range A4 89. John wants to present the company revenue broken down by car type. Repeat Step 3 for the data in the range A16:117 of the Rentals by Type worksheet, placing the pie chart comparing revenue between the Americas and international sales in the range 159 of the Analysis worksheet. Repuat Step 3 for the data in the range A11:B12 of the Rentals by Type worksheet placing the ple chart comparing Leisure and Commercial sales in the range HSC-H9 of the Analysis worksheetĮX 4-60 Excel Module 4 Analyzing and Charting Financial Data 5. Add data labels to the outside end of the two slices showing the percentage of the Airport vs Off Airport sales 4.
Remove the chart title from the pie chart c. Move the chart cover the range DS F9 in the Analysis worksheet b. Create a pie chart of the data in the range A6:37. International, In the Rentals by Type worksheet, do the following: a. 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 33:34. Save the workbook as NPEX_4_Certus in the location specified by your instructor 2. Open the NP_EX_4-3.xlsx workbook located in the Excel > Case folder included with your Data files. APPLY Case Problem 1 Data File needed for this Case Problem: NP_EX_4-3.xlsx Certus 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, John is developing a mar ket report for an upcoming sales conference and needs your assistance in summarizes market infor mation into a collection of Excel charts and graphics. Add data markers for the high and low points of each sparkline using the Red standard color 12. Add line sparklines to the range H28H33 using the data values from the range 85:144 of the Sectors worksheet.
Keep the data bars from overlap- ping the values in those cells by modifying the conditional formatting rule so that the maximum length of the databar corresponds to a value of 0.30. Add solid blue data bars to the values in the range G28:G38. Align and evenly distribute the icons within cell 89. Set the height and width of each icon 0.209. On the Prospectus worksheet, replace the text in cell 89 with three star icons from the Celebration group in the icon gallery. Resize and move the text boxes so that they align with the chart corners 9. Add the four text boxes shown earlier in Figure 4-28 to the scatter chart, placing the return and volatility descriptions on separate lines.
Anova excel worksheet module 4 series#
Complete the scatter chart by adding a new data series to the chart with cell G5 in the Performance worksheet as the series name, the range F6-F15 in the Performance worksheet as the Series X values, and the range Ge:G15 in the Performance worksheet as the Series Y Values 8. Add data callouts to the data markers in the data series showing only the text from the range Ab Ay in the Performance worksheet. Set the label position to none for both the vertical and horizontal axis labels. Rescate the horizontal axis to go from 4 to 24 with the vertical axis crossing at 14.71.
Rescale the vertical axis to go from 0.0 to 0.06 with the horizontal axis crossing at 0.031. Remove the chart title and the gridlines from the chart d. Move the chart to the range F15:H24 of the Prospectus worksheet. Create a scatter chart from the data in the range B5.C7 using the scatter chart from the list of recommended charts. Hidekl needs to compare the return rate and volatility of the Ortus Fund to other investment vehicles. Transcribed image text: EX 4-14 Module 4 Analyzing and Charting Financial Data Excel 7.
0 kommentar(er)
