viii The second edition of Introduction to Microsoft Offi ce 2019 has been revised to refl ect updates to the Microsoft Offi ce 2019 software suite and the Windows 10 oper- ating system. Changes from Microsoft Offi ce 2016 to Microsoft Offi ce 2019 are incorporated into each chap- ter, as are changes from Windows 8 (and earlier ver- sions) to Windows 10. This new edition is aligned to the standards for the Microsoft Offi ce Specialist (MOS) certifi cation exam, as well as the Key Applications exam for the IC3 Digital Literacy Certifi cation. The most noticeable change to this edition is the addition of a new chapter on Microsoft Outlook, which increases the total chapters of the text to eleven. The coverage of Microsoft Outlook helps users learn the basics of one of the most widely used software appli- cations in the workplace. The changes to each individual chapter are summa- rized in the following list. • Chapter 1 Introduction to Information Technology provides an overview of important topics in the fi eld of information technology (IT). This chapter includes changes to the Microsoft Edge web browser application. • Chapter 2 Introduction to System and Application Software covers the basic functionality of both system and application software. Updates to this chapter refl ect changes to the Windows 10 operating system. • Chapter 3 File Management discusses the importance of organizing information stored on a computer and effective fi le management practices. Changes to the Windows 10 operating system and MOS standards for Microsoft Word and Microsoft PowerPoint are included. • Chapter 4 Common Offi ce Application Features covers the software features shared by all programs in the Microsoft Offi ce suite of software. This chapter incorporates MOS standards for Microsoft Access, PowerPoint, and Word. Key additions to this chapter include working with 3D models, shapes, text boxes, SmartArt, screen shots, and screen clippings, and adding alternative text for accessibility. • Chapter 5 Word-Processing Software discusses the use of word-processing software for creating and proofi ng documents. MOS standards for Microsoft Word and selected standards for Microsoft PowerPoint are covered. Key additions to this chapter include adding column breaks locking and unlocking the track changes feature and managing comments. • Chapter 6 Formal Documents covers how to create formal documents for the workplace, including business letters and reports. It also discusses ethical practices for intellectual property. This chapter incorporates MOS standards for Microsoft Word. • Chapter 7 Presentation Software explains the process for creating a professional presentation explores ways in which presentations can be enhanced through the use of transitions, animations, and visuals and describes creating handouts. MOS standards for Microsoft PowerPoint and selected standards for Microsoft Access and Word are covered. Key additions to this chapter include marking presentations as fi nal recording slide shows drawing with digital ink inserting screen recordings and using summary, section, and slide zoom features. • Chapter 8 Spreadsheet Software introduces spreadsheets and explains how to manage data in spreadsheets. This chapter incorporates MOS standards for Microsoft Excel. Key additions to this chapter are data viewing options and setting a print area. • Chapter 9 Advanced Spreadsheet Uses discusses the use of functions in Microsoft Excel spreadsheets and visual enhancements of data with tables and charts. This chapter incorporates MOS standards for Microsoft Excel. • Chapter 10 Database Software introduces databases and covers how to import data, view data, and run queries in a database. This chapter incorporates MOS standards for Microsoft Access. • Chapter 11 Personal Information Management Software is a new chapter that discusses the ways in which Microsoft Outlook is used for communication and personal information management, such as with a calendar and contacts list. This chapter is written to cover the MOS standards for Microsoft Outlook. New to This Edition