new perspectives microsoft office 365 excel 2019 comprehensive

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. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.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. In addition, MindTap and updated SAM (Skills Assessment Manager) online resources are available to guide additional study and ensure successful results. NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE demonstrates the importance of what students are learning while strengthening your skills and helping students transfer those skills to other applications and disciplines for further success. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers. Develop the Microsoft Office 365 and Excel 2019 skills students need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & EXCEL 2019 COMPREHENSIVE.

New perspectives microsoft office 365 excel 2019 comprehensive