Microsoft Office 365 - Pearson Education

2y ago
96 Views
12 Downloads
3.01 MB
26 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Kamden Hassan
Transcription

GOIntroductoryMicrosoft Office 365 2019 EditionLearn Practice raviettSeries Editor: Shelley GaskinA01 GASK2845 12 SE FM.indd 112/12/18 7:48 PM

VP Courseware Portfolio Management: Andrew GilfillanExecutive Portfolio Manager: Jenifer NilesTeam Lead, Content Production: Laura BurgessContent Producer: Shannon LeMay-FinnDevelopment Editor: Ginny MunroePortfolio Management Assistant: Bridget DalyDirector of Product Marketing: Brad ParkinsDirector of Field Marketing: Jonathan CottrellProduct Marketing Manager: Heather TaylorField Marketing Manager: Bob NisbetProduct Marketing Assistant: Liz BennettField Marketing Assistant: Derrica MoserSenior Operations Specialist: Diane PeiranoSenior Art Director: Mary SeinerInterior and Cover Design: Pearson CSCCover Photo: Jag cz/Shutterstock, everything possible/ShutterstockSenior Product Model Manager: Eric HakansonManager, Digital Studio: Heather DarbyDigital Content Producer, MyLab IT: Becca GoldenCourse Producer, MyLab IT: Amanda LosonskyDigital Studio Producer: Tanika HendersonFull-Service Project Management: Pearson CSC, Katie OstlerComposition: Pearson CSCPrinter/Binder: LSC Communications, Inc.Cover Printer: Phoenix Color/HagerstownCredits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text.Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related graphicspublished as part of the services for any purpose. all such documents and related graphics are provided “as is” without warranty of any kind. microsoftand/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all warranties and conditions ofmerchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. in no event shall Microsoft and/or itsrespective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits,whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of information availablefrom the services.The documents and related graphics contained herein could include technical inaccuracies or typographical errors. changes are periodically added to theinformation herein. microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s) describedherein at any time. partial screen shots may be viewed in full within the software version specified.Microsoft and Windows are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screenshots and icons reprintedwith permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation.Copyright 2020, 2017, 2014 by Pearson Education, Inc. 221 River Street, Hoboken, NJ 07030. All rights reserved. Manufactured in the UnitedStates of America. This publication is protected by Copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. To obtainpermission(s) to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, Hoboken, New Jersey,070308Many of the designations by manufacturers and seller to distinguish their products are claimed as trademarks. Where those designations appear in thisbook, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.Library of Congress Cataloging-in-Publication DataOn file with the Library of Congress.10 9 8 7 6 5 4 3 2 1ISBN-10: 0-13-541781-3ISBN-13: 978-0-13-541781-2A01 GASK2845 12 SE FM.indd 212/12/18 7:48 PM

Brief ContentsPrepare Students to Succeed! .xviiiMicrosoft Office and Windows 10Chapter 1Microsoft Office Features and Windows 10File Managment . 1WordChapter 1Creating Documents with Microsoft Word . 103Chapter 2Creating Cover Letters and Using Tablesto Create Resumes . 169Chapter 3Creating Research Papers, Newsletters,and Merged Mailing Labels . 235ExcelChapter 1Creating a Worksheet and Charting Data . 315Chapter 2Using Functions, Creating Tables, andManaging Large Workbooks . 385Chapter 3Analyzing Data with Pie Charts, LineCharts, and What-If Analysis Tools . 459AccessChapter 1Getting Started with Microsoft Access 2019 . 519Chapter 2Sort and Query a Database . 595Chapter 3Forms, Filters, and Reports . 671Brief ContentsA01 GASK2845 12 SE FM.indd 3iii12/12/18 7:48 PM

PowerPointChapter 1Getting Started with Microsoft PowerPoint . 745Chapter 2Formatting PowerPoint Presentations . 813Chapter 3Enhancing a Presentation withAnimation, Video, Tables, and Charts . 877Appendixes: Microsoft Office Specialist Mappings .A-1Glossary . G-1Index . I-1ivBrief ContentsA01 GASK2845 12 SE FM.indd 412/12/18 7:48 PM

Table of ContentsMicrosoft Office and Windows 10 1Chapter 1 Microsoft OfficeFeatures andWindows 10 FileManagementPROJECT IA Chef Notes12Objective 1iv1 Explore Microsoft Office3Activity 1.01 Exploring Microsoft Office4Objective 2e2 Create a Folder for File Storage6Activity 1.02 Creating a Folder for File StorageMore Knowledge Creating a Microsoft Account77Objective 3 Download and Extract ZippedFiles, Enter and Edit Text in anOffice Application, and UseEditor to Check DocumentsActivity 1.03 Downloading and Extracting ZippedFiles from MyLab IT and Enteringand Editing Text in an Office ProgramActivity 1.04 Checking SpellingObjective 4 Perform Office Commandsand Apply Office FormattingActivity 1.15 Inserting a Footer, InsertingDocument Info, and AddingDocument PropertiesActivity 1.16 Inspecting a DocumentActivity 1.17 Inserting a Bookmark and a 3D ModelActivity 1.18 Printing a File and Closing aDesktop AppA01 GASK2845 12 SE FM.indd 541Objective 6iv Use the Office Help Features41Activity 1.19 Using Microsoft Office Tell Me, TellMe More, the Help Tab, and AddingAlt Text to an Excel ChartMore Knowledge Don’t Type, Talk! With the NewDictate Feature4110111415373738394044PROJECT 1B Hotel Files45Objective 77 Explore Windows 1046Activity 1.20 Recognizing User Accounts inWindows 10Activity 1.21 Turning On Your Computer, SigningIn, and Exploring the Windows 10EnvironmentActivity 1.22 Pinning a Program to the TaskbarObjective 8 Prepare to Work with Foldersand FilesActivity 1.05 Performing Commands from aDialog Box15Activity 1.06 Using Undo and Applying Text Effects 18Activity 1.07 Performing Commands from andCustomizing the Quick Access Toolbar 19Activity 1.08 Performing Commands fromthe Ribbon21Activity 1.09 Minimizing the Ribbon25More Knowledge Displaying KeyTips25Activity 1.10 Changing Page Orientation andZoom Level25More Knowledge Zooming to Page Width26Activity 1.11 Formatting Text by Using Fonts,Alignment, Font Colors, and Font Styles 27Activity 1.12 Using Format Painter30Activity 1.13 Using Keyboard Shortcuts andUsing the Clipboard to Copy, Cut,and Paste32Activity 1.14 Adding Alternative Text for Accessibility 36Objective 5 Finalize an Office DocumentMore Knowledge Creating an Electronic Image of YourDocumentActivity 1.23More KnowledgeActivity 1.24More KnowledgeMore KnowledgeActivity 1.25Activity 1.26Activity 1.27Creating a New Folder to Store a FileUse OneDrive as Cloud StorageCreating and Saving a FileJump to a Lettered Section of theApps List QuicklyThe Hamburger IconDownloading and Extracting ZippedFilesLocating and Inserting a Saved FileInto a PowerPoint PresentationUsing Snap and Task ViewObjective 9 Use File Explorer to ExtractZipped Files and to DisplayLocations, Folders, and FilesActivity 1.28 Navigating with File ExplorerActivity 1.29 Using File Explorer to ExtractZipped FilesActivity 1.30 Using File Explorer to DisplayLocations, Folders, and FilesObjective 10 Start Programsand Open Data FilesActivity 1.31 Starting ProgramsActivity 1.32 Opening Data FilesMore Knowledge Do Not Clutter Your Desktop byCreating Desktop Shortcuts orStoring FilesActivity 1.33 Searching, Pinning, Sorting, andFiltering in File ExplorerObjective 11 Create, Rename, and CopyFiles and 5Activity 1.34 C opying Files from a RemovableStorage Device to the DocumentsFolder on the Hard Disk Drive85Table of Contentsv12/12/18 7:48 PM

GO! With Google DocsActivity 1.35 Creating Folders, Renaming Folders,and Renaming FilesActivity 1.36 Copying FilesActivity 1.37 Moving FilesMore Knowledge Using Shift Click to Select FilesActivity 1.38 Copying and Moving Files bySnapping Two WindowsMore Knowledge Deleting Files and Using the RecycleBin878990919294GO To Work 95End of Chapter 96Summary GO! Learn It OnlineGlossary 9697Microsoft Word 2019103Chapter 1 Creating Documentswith Microsoft Word103PROJECT 1A FlyerObjective 1 Create a New Document andInsert Text104105Activity 1.01 Creating a New Word Document105More Knowledge Word’s Default Settings Are Easierto Read Online107Activity 1.02 Inserting Text from Another Document 107Objective 2 Insert and Format GraphicsActivity 1.03More KnowledgeActivity 1.04Activity 1.05Activity 1.06Activity 1.07Activity 1.08More KnowledgeActivity 1.09Activity 1.10Formatting Text by Using Text EffectsClear Existing FormattingInserting PicturesWrapping Text Around a PictureUsing Layout OptionsResizing Pictures and Using LiveLayoutPositioning a PictureApplying Picture EffectsApplying Picture StylesApplying Artistic EffectsAdding a Page BorderObjective 3 Insert and Modify Text Boxesand Shapes108109109110111112114114114115116Activity 1.11 Inserting, Sizing, and Positioning aShapeActivity 1.12 Typing Text in a Shape andFormatting a ShapeActivity 1.13 Inserting a Text BoxActivity 1.14 Sizing and Positioning a Text Boxand Formatting a Text Box UsingShape Styles117118Objective 4 Preview and Print a Document120Activity 1.15 Adding a File Name to the Footer byInserting a FieldActivity 1.16 Adding Document Properties andPreviewing and Printing a Documentvi108116Objective Create a Flyer Using GoogleDocsPROJECT 1B Information HandoutObjective 5 Change Document andParagraph LayoutActivity 1.17Activity 1.18Activity 1.19Activity 1.20Activity 1.21Setting MarginsAligning ParagraphsSetting Line SpacingIndenting TextSetting Space Before and AfterParagraphsObjective 6 Create and Modify ListsActivity 1.22Activity 1.23More KnowledgeActivity 1.24Creating a Bulleted ListCreating a Numbered ListTo End a ListCustomizing BulletsObjective 7 Set and Modify Tab StopsActivity 1.25 Setting Tab StopsActivity 1.26 Modifying Tab StopsObjective 8 Insert and Format a SmartArtGraphic and an IconActivity 1.27 Inserting a SmartArt GraphicActivity 1.28 Sizing and Formatting a SmartArtGraphicActivity 1.29 Inserting an IconGO! With Google 39139141143143144145147Objective Create an Information Handout 147GO! To Work End of Chapter149150Summary; GO! Learn It Online; GO! CollaborativeTeam Project 151Project Guide for Word Chapter 1151Glossary152Chapter Review 153Content-Based Assessments: Mastery, CriticalThinking, and Problem Solving 159Content-Based Assessment Rubric 167GO! Think 168Chapter 2 Creating Cover Lettersand Using Tables to169Create ResumesPROJECT 2A Resume119124Objective 1 Create a Table for a ResumeActivity 2.01 Inserting a Table by Defining TableDimensionsActivity 2.02 Typing Text in a TableActivity 2.03 Inserting Text From a File and UsingResume AssistantActivity 2.04 Creating Bulleted Lists in a Table170171171172173176Table of ContentsA01 GASK2845 12 SE FM.indd 612/12/18 7:48 PM

Objective 2 Format a TableActivity 2.05 Changing the Width of TableColumns and Using AutoFitMore Knowledge Changing Column WidthsActivity 2.06 Using One-Click Row/ColumnInsertion to Modify Table DimensionsActivity 2.07 Adjusting Cell Margins and MergingTable CellsActivity 2.08 Setting Tabs in a TableActivity 2.09 Using Spacing After in a TableActivity 2.10 Modifying Table Borders, UsingSpacing Before, and ViewingGridlines in a TableMore Knowledge Converting a Table to TextObjective 3 Present a Word DocumentOnlineActivity 2.11 Presenting a Word Document OnlineGO! With Google DocsObjective Edit a Resume in Google DocsPROJECT 2B Cover Letter and EnvelopeObjective 4 Create a Letterhead for aCover LetterActivity 2.12 Inserting a Manual Line BreakActivity 2.13 Applying a Bottom Border to aParagraphObjective 5 Create a Cover Letter andCorrect and Reorganize Text177Summary; GO! Learn It Online; GO! CollaborativeTeam Project177178Project Guide for Word Chapter vity 2.14 Adding AutoCorrect EntriesActivity 2.15 Inserting the Current Date andCreating a Cover LetterActivity 2.16 Finding and Replacing TextActivity 2.17 Selecting Text and Moving Text byUsing Drag and DropActivity 2.18 Inserting a Table into a Documentand Applying a Table Style194200Objective 6 Use the Word Editor to CheckYour Document201195197199Activity 2.19 Using the Word Editor to Check forSpelling, Grammar, and Writing Issues 202Activity 2.20 Using the Thesaurus205Objective 7 Print an Envelope, Changea Style Set, Create a WordTemplate, and Use LearningToolsActivity 2.21Activity 2.22Activity 2.23Activity 2.24Addressing and Printing an EnvelopeChanging a Style SetCreating a Word TemplateUsing Learning Tools and Read AloudGO! With Google DocsObjective Create a Table in Google Docs206206207208210212212GO! To Work 214End of Chapter215GlossaryChapter ReviewMastering Word 224Rubric 232233GO! ThinkChapter 3 Creating ResearchPapers, Newsletters,and Merged MailingLabelsPROJECT 3A Research PaperObjective 1 Create a Research PaperActivity 3.01 Formatting the Spacing and FirstPage Information for a ResearchPaperActivity 3.02 Formatting the Page Numbering andParagraph Indents for a ResearchPaperMore Knowledge Suppressing the Page Number onthe First Page of a Document235236237237238240Objective 2 Insert Footnotes in a ResearchPaper240Activity 3.03 Inserting FootnotesMore Knowledge Using Symbols Rather ThanNumbers for NotesActivity 3.04 Modifying a Footnote Style240241241Objective 3 Create Citations and aBibliography in a Research Paper 244Activity 3.05 Adding Citations for a BookActivity 3.06 Editing CitationsMore Knowledge Word Formats the MLA Style forTwo or More Authors AutomaticallyActivity 3.07 Adding Citations for a WebsiteMore Knowledge Including URLs of Web SourcesActivity 3.08 Inserting Page BreaksActivity 3.09 Creating a Reference PageActivity 3.10 Managing and Modifying Sourcesfor a DocumentActivity 3.11 Using the Navigation Pane to Go toa Specific PageActivity 3.12 Managing Document PropertiesActivity 3.13 Using Smart Lookup, Researcher,Text Highlighting, Cover Pages, andSide to Side Page MovementObjective 4 Use Read Mode, PDF Reflow,and Save Documents inAlternative File FormatsActivity 3.14 Using Read Mode, PDF Reflow, andSaving Documents in Alternative FileFormatsTable of ContentsA01 GASK2845 12 SE FM.indd 55vii12/12/18 7:48 PM

GO! With Google DocsObjective Use the Research Bar inGoogle DocsPROJECT 3B Newsletter with OptionalMailing LabelsObjective 5 Format a Multiple-ColumnNewsletterActivity 3.15 Changing One Column of Text toTwo ColumnsActivity 3.16 Formatting Multiple ColumnsMore Knowledge Justifying Column TextActivity 3.17 Inserting a Column BreakActivity 3.18 Inserting a PictureActivity 3.19 Cropping a Picture and Resizing aPicture by ScalingActivity 3.20 Setting Transparent Color andRecoloring a PictureActivity 3.21 Adjusting the Brightness andContrast of a PictureActivity 3.22 Applying a Border to a Picture andFlipping a PictureActivity 3.23 Inserting and Formatting a ScreenClippingMore Knowledge Inserting a Link in a DocumentObjective 6 Use Special Character andParagraph 74274275Activity 3.24 Applying the Small CapsFont EffectActivity 3.25 Inserting Symbols and SpecialCharactersActivity 3.26 Adding Borders and Shading to aParagraph277Objective 7 Create Mailing Labels UsingMail Merge280Activity 3.27 Starting the Mail Merge WizardActivity 3.28 Completing the Mail MergeActivity 3.29 Previewing and Printing Mail MergeResultsGO! With Google DocsObjective Create a Table in GoogleDocsGO! To Work End of ChapterSummary; GO! Learn It Online; GO! CollaborativeTeam ProjectReview and Assesment Guide for Word Chapter 3GlossaryChapter ring Word 299Rubric 310GO! Think 311viiiMicrosoft Excel 2019315Chapter 1 Creating a Worksheet315and Charting DataPROJECT 1A Sales Report with Embedded Column Chart and SparklinesObjective 1 Create, Save, and Navigate anExcel Workbook316317Activity 1.01 Starting Excel, Navigating Excel,and Naming and Saving a Workbook 317Objective 2 Enter Data in a WorksheetActivity 1.02 Entering Text, Using AutoComplete,and Using the Name Box to Selecta CellActivity 1.03 Using Auto Fill and KeyboardShortcutsActivity 1.04 Aligning Text and Adjusting the Sizeof ColumnsActivity 1.05 Entering NumbersObjective 3 Construct and Copy Formulasand Use the SUM FunctionActivity 1.06 Constructing a Formula and Usingthe SUM FunctionActivity 1.07 Copying a Formula by Using the FillHandle320320321323325326326328Objective 4 Format Cells with Merge &Center, Cell Styles, and Themes 329Activity 1.08 Using Merge & Center and ApplyingCell StylesActivity 1.09 Formatting Financial NumbersActivity 1.10 Changing the Workbook ThemeMore Knowledge Formatting a Cell’s Font, Style, Size,or Color with Individual Commands329330332332Objective 5 Chart Data to Create a ColumnChart and Insert Sparklines332Activity 1.11 Charting Data and UsingRecommended Charts to Select andInsert a Column ChartActivity 1.12 Using the Chart Tools to ApplyChart StylesActivity 1.13 Creating and Formatting SparklinesObjective 6 Print a Worksheet, DisplayFormulas, and Close ExcelActivity 1.14 Creating a Footer and Centering aWorksheetActivity 1.15 Adding Document Properties andPrinting a WorkbookActivity 1.16 Printing a Section of the WorksheetActivity 1.17 Changing Page Orientation andDisplaying, Printing, and HidingFormulas332335338339339341342342Table of ContentsA01 GASK2845 12 SE FM.indd 812/12/18 7:48 PM

GO! With Google SheetsObjective Create a Sales Report withan Embedded Column ChartUsing Google SheetsPROJECT 1B Inventory Valuation345345347Objective 7 Check Spelling in a Worksheet 348Activity 1.18 Checking Spelling in a Worksheet348Objective 8 Enter Data by Range350Activity 1.19 Entering Data by Range350Objective 9 Construct Formulas forMathematical OperationsActivity 1.20 Using Arithmetic OperatorsActivity 1.21 Using the Quick Analysis ToolActivity 1.22 Copying Formulas ContainingAbsolute Cell ReferencesMore Knowledge Calculate a Percentage if You Knowthe Total and the AmountObjective 10 Edit Values in a WorksheetActivity 1.23 Editing Values in a WorksheetActivity 1.24 Formatting Cells with the PercentStyleObjective 11 Format a WorksheetActivity 1.25 Inserting and Deleting Rows andColumnsActivity 1.26 Adjusting Column Widths andWrapping TextActivity 1.27 Changing Theme ColorsGO! With Google SheetsObjective Create a

Table of Contents Microsoft Office and Windows 10 1 Chapter 1 Microsoft Office Features and Windows 10 File Management 1 PROJECT IA Chef Notes 2 Objective 1 iv1 Explore Microsoft Office 3 Activity 1.01 Exploring Microsoft Office 4 Objective 2 e2 Create a Folder for File Storage Activity 1.216 Activity 1.02 Creating a Folder for File Storage 7 More Knowledge Creating a Microsoft Account 7

Related Documents:

Office 365 is a sub brand of Office that reflects Office as a service and include traditional Office apps and cloud-based services. The first mention of “Office 365” in body copy must be referenced as “Microsoft Office 365”. After the first mention, Office 365 may be referenced as: Microsoft Office 365 Office 365 Office 365 SKUs

Intune Device Intune Device 2 Enterprise Mobility Security E3 Intune 9 Enterprise Mobility Security E5 Intune 15 Microsoft 365 E3 Intune 34 Microsoft 365 E5 Intune 57 Microsoft 365 F1 Intune 10 Microsoft 365 Business Intune 20 Microsoft 365 Education A3 Intune for Education 6 Microsoft 365 Education A5 Intune for Education 11

Management Microsoft Forms Pro 1 Year Audit Log Retention. Microsoft 365 Common Features. Microsoft 365 Plans. Microsoft 365 Plans. Enterprise Mobility Security. Windows 10. Office 365 Enterprise. Microsoft 365 Plans. Advanced Threat Analytics. Intune Device Management & Application Management. Azure Information Protection Plan 1. CALs

Pearson Education LTD. Pearson Education Australia PTY, Limited. Pearson Education Singapore, Pte. Ltd. Pearson Education North Asia, Ltd. Pearson Education Canada, Ltd. Pearson Educatión de Mexico, S.A. de C.V. Pearson Education—Japan Pearson Education Malaysia, Pte. Ltd. Library of Co

Pearson Education LTD. Pearson Education Australia PTY, Limited. Pearson Education Singapore, Pte. Ltd. Pearson Education North Asia, Ltd. Pearson Education Canada, Ltd. Pearson Educación de Mexico, S.A. de C.V. Pearson Education—Japan Pearson Education Malaysia, Pte. Ltd. The Libra

replica for Ferrari 365 GTB 4 Daytona models. Part #:. 365 GT 2 2 365 GTB 4. FR-365-055 Set of air conditioning service valves for Ferrari 365 GT 2 2, . Cap screw heater valve for Ferrari 365 models. Part #: AR-GIU-064 365 GTB4 Daytona GTC4. FR-206-879-1 Pressureless radiator cap for Ferrari 365 GTB4 Daytona, and

Biežāk uzdotie jautājumi par Microsoft Office 365 pakalpojumiem RTU IT lietotāju atbalsta centrs, tālrunis: 67089999, fakss: 67089824, e-pasts: it@rtu.lv 4. Kā saņemt Microsoft Office 365 programmu instalācijas, lietošanai Jūsu datorā?!!! Lai saņemtu Microsoft Office 365 programmu instalācijas, Jums bija jāpiesakās pakalpojumam

Office 365 入门 什么是 Office 365 企业版? 正如 Office 2010 是一套桌面应用程序一样,您的 Office 365 企业版订阅向您提供一套 �的 Office 桌面应用程序。 Office 365 允许您: 最多在五计算机上安装 Office。 使用 Office Online 从具有 .