Shelly Cashman Series Microsoft Office 365 Office 2019 Introductory by Misty Vermaat Ellen Monk Sus by MS Office Expert

•, CENGAGE

Microsoft‘ Office 36S‘ a

OFFICE 2019 CABLE I FREUND | MONK I SEBO + I VERN A AT

Austr alia • Br azil • Me xico • Singapor e • United Kingdom • United States

Copyright 2020 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.

We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I canâ&#x20AC;&#x2122;t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.

Shelly Cashman Series® Microsoft® Office 365® & Office 2019 Introductory Sandra E. Cable, Steven M. Freund, Ellen F. Monk, Susan L. Sebok, Misty E. Vermaat SVP, GM Skills & Global Product Management: Jonathan Lau Product Director: Lauren Murphy Product Assistant: Veronica Moreno-Nestojko Executive Director, Content Design: Marah Bellegarde Director, Learning Design: Leigh Hefferon Associate Learning Designer: Courtney Cozzy Vice President, Marketing—Science, Technology, and Math: Jason R. Sakos Senior Marketing Director: Michele McTighe Marketing Manager: Timothy J. Cali Director, Content Delivery: Patty Stephan Senior Content Manager: Anne Orgren Digital Delivery Lead: Laura Ruschman Designer: Lizz Anderson Cover image(s): Sergey Kelin/ShutterStock.com (Ocean), nikkytok/ShutterStock.com (Crystal), PARINKI/ShutterStock.com (Marble), Erika Kirkpatrick/ShutterStock.com (Driftwood), Vladitto/ShutterStock.com (Skyscraper), Roman Sigaev/ShutterStock.com (Clouds)

© 2020, 2017 Cengage Learning, Inc. Unless otherwise noted, all content is © Cengage. ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced or distributed in any form or by any means, except as permitted by U.S. copyright law, without the prior written permission of the copyright owner. Mac Users: If you’re working through this product using a Mac, some of the steps may vary. Additional information for Mac users is included with the Data files for this product. Disclaimer: This text is intended for instructional purposes only; data is fictional and does not belong to any real persons or companies. Disclaimer: The material in this text was written using Microsoft Windows 10 and Office 365 Professional Plus and was Quality Assurance tested before the publication date. As Microsoft continually updates the Windows 10 operating system and Office 365, your software experience may vary slightly from what is presented in the printed text. Windows, Access, Excel, and PowerPoint are registered trademarks of Microsoft Corporation. Microsoft and the Office logo are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. This product is an independent publication and is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation. Some of the product names and company names used in this book have been used for identification purposes only and may be trademarks or registered trademarks of Microsoft Corporation in the United States and/ or other countries. Unless otherwise noted, all non-Microsoft clip art is courtesy of openclipart.org. For product information and technology assistance, contact us at Cengage Customer & Sales Support, 1-800-354-9706 or support.cengage.com. For permission to use material from this text or product, submit all requests online at www.cengage.com/permissions Library of Congress Control Number: 2018966288 Student Edition ISBN: 978-0-357-02643-4 K12 ISBN: 978-0-357-11944-0 Looseleaf available as part of a digital bundle Cengage 20 Channel Center Street Boston, MA 02210 USA Cengage is a leading provider of customized learning solutions with employees residing in nearly 40 different countries and sales in more than 125 countries around the world. Find your local representative at www.cengage.com. Cengage products are represented in Canada by Nelson Education, Ltd. To learn more about Cengage platforms and services, visit www.cengage.com.

Notice to the Reader Publisher does not warrant or guarantee any of the products described herein or perform any independent analysis in connection with any of the product information contained herein. Publisher does not assume, and expressly disclaims, any obligation to obtain and include information other than that provided to it by the manufacturer. The reader is expressly warned to consider and adopt all safety precautions that might be indicated by the activities described herein and to avoid all potential hazards. By following the instructions contained herein, the reader willingly assumes all risks in connection with such instructions. The publisher makes no representations or warranties of any kind, including but not limited to, the warranties of fitness for particular purpose or merchantability, nor are any such representations implied with respect to the material set forth herein, and the publisher takes no responsibility with respect to such material. The publisher shall not be liable for any special, consequential, or exemplary damages resulting, in whole or part, from the readers’ use of, or reliance upon, this material.

Printed in the United States of America Print Number: 01 Print Year: 2019

Brief Contents Getting to Know Microsoft Office Versions� � � � � �� OFF-1Using SAM Projects and Textbook Projects��S A M -1

Word 2019 MODULE 1: Creating and Modifying a Flyer��W D1-1 MODULE 2: Creating a Research Paper �� WD 2-1 MODULE 3: Creating a Business Letter ��WD 3-1

PowerPoint 2019 MODULE 1: Creating and Editing Presentations with Pictures ��

P T1-1 MODULE 2:

Enhancing Presentations with Shapes and SmartArt ��PPT 2-1 MODULE 3: Inserting WordArt, Charts, and Tables��PPT 3-1

Excel 2019 MODULE 1: Creating a Worksheet and a Chart �� EX1-1 MODULE 2: Formulas, Functions, and Formatting ��EX 2-1 MODULE 3: Working with Large Worksheets, Charting, and What-If Analysis ��EX3-1

Access 2019 MODULE 1: Databases and Database Objects: An Introduction��AC1-1 MODULE 2: Querying a Database�� AC 2-1 MODULE 3: Maintaining a Database ��AC 3-1 Index

��I-1

Contents Getting to Know Microsoft Office Versions Using SAM Projects and Textbook Projects

Microsoft

OFF-1 SAM-1

Word 2019

MODULE ONE Creating and Modifying a Flyer Objectives What Is Word? Introduction Project: Flyer with a Picture Starting and Using Word To Start Word and Create a Blank Document The Word Window To Display a Different Tab on the Ribbon To Adjust the Margins Entering Text in a Document

WD 1-1 WD 1-1 WD 1-2 WD 1-2 WD 1-3 WD 1-3 WD 1-5 WD 1-10 WD 1-11 WD 1-12

To Type Text To Change the Zoom to Page Width To Display Formatting Marks Wordwrap To Wordwrap Text as You Type Spelling and Grammar Check To Enter More Text with Spelling and Grammar Errors To Check Spelling and Grammar as You Work in a Document To Insert a Blank Line To Enter More Text Navigating a Document To Save a Document for the First Time Formatting Paragraphs and Characters Font, Font Sizes, and Themes To Change the Document Theme To Center a Paragraph To Center Another Paragraph Formatting Single versus Multiple Paragraphs and Characters To Select a Line To Change the Font Size of Selected Text To Change the Font of Selected Text To Change the Case of Selected Text To Apply a Preset Text Effect to Selected Text

WD 1-12 WD 1-13 WD 1-14 WD 1-14 WD 1-15 WD 1-15 WD 1-16 WD 1-16 WD 1-18 WD 1-19 WD 1-20 WD 1-21 WD 1-23 WD 1-24 WD 1-25 WD 1-27 WD 1-28 WD WD WD WD WD WD

1-28 1-28 1-29 1-30 1-31 1-32

To Shade a Paragraph To Select a Paragraph To Change the Font Color of Selected Text To Change the Font Size of Selected Text To Change the Zoom Percentage To Select Multiple Lines To Change the Font Size of Selected Text To Number a List of Paragraphs To Undo and Redo an Action To Bullet a List of Paragraphs AutoFormat As You Type To Remove a Hyperlink To Center Another Paragraph To Use the Mini Toolbar to Format Text To Select a Group of Words To Underline Text To Italicize Text To Select Nonadjacent Text To Bold Text Selecting Text To Save an Existing Document with a Different File Name Inserting and Formatting a Picture in a Word Document To Center a Paragraph To Insert a Picture from a File To Change the Zoom to One Page To Resize an Object Proportionally To Apply a Picture Style To Apply a Picture Effect Enhancing the Page To Change Theme Colors To Add a Page Border To Change Spacing before and after Paragraphs To Change the Document Properties To Save an Existing Document with the Same File Name To Close a Document Correcting Errors and Revising a Document Types of Changes Made to Documents To Open a Document To Change the Zoom to Page Width To Insert Text in an Existing Document Cutting, Copying, and Pasting To Delete or Cut Text

WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD WD

1-33 1-34 1-35 1-35 1-36 1-37 1-38 1-38 1-40 1-40 1-42 1-42 1-43 1-43 1-45 1-45 1-46 1-47 1-48 1-48

WD 1-49 WD 1-50 WD 1-51 WD 1-51 WD 1-53 WD 1-53 WD 1-55 WD 1-56 WD 1-57 WD 1-58 WD 1-59 WD 1-60 WD 1-61 WD 1-62 WD 1-63 WD 1-64 WD 1-64 WD 1-64 WD 1-65 WD 1-65 WD 1-66 WD 1-66

Microsoft Office 2019 Introductory Contents v

To Copy and Paste To Display the Paste Options Menu To Move Text To Switch to Read Mode To Switch to Print Layout View To Save a Document with the Same File Name To Print a Document Using Word Help To Use the Tell Me Box To Use the Help Pane Obtaining Help while Working in Word To Sign Out of a Microsoft Account To Exit Word Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

WD 1-67 WD 1-68 WD 1-69 WD 1-70 WD 1-71 WD 1-71 WD 1-71 WD 1-72 WD 1-73 WD 1-74 WD 1-75 WD 1-75 WD 1-76 WD 1-77 WD 1-78 WD 1-80 WD 1-82 WD 1-84

MODULE TWO Creating a Research Paper Objectives Introduction Project: Research Paper MLA Documentation Style Changing Document Settings To Start Word and Specify Settings Styles To Modify a Style Adjusting Line and Paragraph Spacing To Change Line Spacing To Remove Space after a Paragraph To Update a Style to Match a Selection Creating a Header To Insert a Header To Right-Align a Paragraph To Enter Text in a Header To Insert Page Numbers To Close the Header Typing the Research Paper Text To Enter Name and Course Information To Click and Type Keyboard Shortcuts for Formatting Text To Format Text Using a Keyboard Shortcut To Display the Rulers To First-Line Indent Paragraphs To AutoCorrect as You Type To Use the AutoCorrect Options Button To Create an AutoCorrect Entry The AutoCorrect Dialog Box To Enter More Text Citations To Change the Bibliography Style To Insert a Citation for a New Source To Enter More Text Footnotes To Insert a Footnote To Insert a Citation Placeholder Footnote Text Style To Modify a Style Using a Shortcut Menu To Edit a Source

WD 2-1 WD 2-1 WD 2-1 WD 2-2 WD 2-4 WD 2-4 WD 2-4 WD 2-5 WD 2-6 WD 2-6 WD 2-7 WD 2-8 WD 2-8 WD 2-9 WD 2-10 WD 2-10 WD 2-10 WD 2-12 WD 2-12 WD 2-13 WD 2-14 WD 2-15 WD 2-15 WD 2-16 WD 2-16 WD 2-18 WD 2-18 WD 2-19 WD 2-20 WD 2-21 WD 2-22 WD 2-22 WD 2-23 WD 2-25 WD 2-25 WD 2-26 WD 2-27 WD 2-28 WD 2-28 WD 2-30

To Edit a Citation Working with Footnotes and Endnotes To Enter More Text To Count Words Automatic Page Breaks To Enter More Text and Insert a Citation Placeholder To Hide and Show White Space To Edit a Source To Enter More Text Creating an Alphabetical Works Cited Page To Insert a Page Break To Apply a Style To Center Text To Create a Bibliographical Reference List Proofreading and Revising the Research Paper To Edit a Source Using the Source Manager Dialog Box To Update a Field (the Bibliography) To Open the Navigation Pane To Go to a Page To Insert a Citation Using an Existing Source To Move a Citation To Find Text To Replace Text Find and Replace Dialog Box To Use the Thesaurus To Check Spelling and Grammar at Once The Main and Custom Dictionaries To Save and Print the Document To Use Smart Lookup To Use Researcher To Change the Zoom to Multiple Pages To Change Read Mode Color Working with Comments in a Document To Insert a Comment To Insert Another Comment To Go To a Comment To Edit a Comment in a Comment Balloon To Go to a Comment To Reply to a Comment To Hide and Show Comments To Delete a Comment To Delete All Comments To Exit Word Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

WD 2-32 WD 2-33 WD 2-34 WD 2-34 WD 2-35 WD 2-35 WD 2-35 WD 2-37 WD 2-38 WD 2-38 WD 2-39 WD 2-39 WD 2-40 WD 2-40 WD 2-42 WD 2-43 WD 2-43 WD 2-45 WD 2-45 WD WD WD WD WD WD

2-46 2-47 2-47 2-48 2-49 2-49

WD 2-50 WD 2-52 WD 2-53 WD 2-54 WD 2-54 WD 2-55 WD 2-56 WD 2-57 WD 2-57 WD 2-58 WD 2-59 WD 2-60 WD 2-60 WD 2-60 WD 2-61 WD 2-61 WD 2-62 WD 2-63 WD 2-63 WD 2-64 WD 2-65 WD 2-68 WD 2-69

MODULE THREE Creating a Business Letter Objectives Introduction Project: Business Letter To Start Word and Change Word Settings Creating a Letterhead To Insert a Shape Floating versus Inline Objects

WD WD WD WD WD WD WD

3-1 3-1 3-1 3-3 3-4 3-5 3-6

vi Contents Microsoft Office 2019 Introductory

To Change an Object’s Position To Change an Object’s Text Wrapping To Apply a Shape Style To Change the Shape Outline To Apply a Shape Effect To Add Text to a Shape To Use the ‘Increase Font Size’ Button To Bold Selected Text and Save the Letterhead Document To Insert an Online Picture To Resize a Picture to a Percent of the Original Size To Change the Color of a Picture To Adjust the Brightness and Contrast of a Picture To Add a Picture Border To Change an Object’s Text Wrapping To Move an Object To Copy an Object To Use Paste Options to Paste an Object To Move an Object To Flip an Object To Format and Enter Text To Insert a Symbol from the Symbol Gallery To Enter Text To Add a Paragraph Border To Clear Formatting Creating a Business Letter To Save a Document with a New File Name To Apply a Style Using Tab Stops to Align Text To Display the Ruler To Set Custom Tab Stops To Insert the Current Date in a Document To Enter the Inside Address and Salutation Tables To Insert an Empty Table To Enter Data in a Table To Enter More Data in a Table To Apply a Table Style To Select a Column Selecting Table Contents To Insert a Row in a Table Deleting Table Data To Add More Text To Bullet a List as You Type To Enter More Text and then Save the Letter Working with SmartArt Graphics To Insert a Page Break To Enter and Format Text To Add and Format a Paragraph Border To Clear Formatting To Apply a Style and Enter More Text To Change the Underline Style To Use the Format Painter Button SmartArt Graphics To Insert a SmartArt Graphic

WD 3-7 WD 3-8 WD 3-8 WD 3-9 WD 3-10 WD 3-10 WD 3-11 WD 3-12 WD 3-12 WD 3-14 WD 3-15 WD 3-16 WD 3-16 WD 3-17 WD 3-18 WD 3-18 WD 3-18 WD 3-19 WD 3-19 WD 3-20

To Delete Shapes from a SmartArt Graphic To Add Text to Shapes in a SmartArt Graphic To Add a Shape to a SmartArt Graphic To Add More Shapes and Text to a SmartArt Graphic To Change Colors of a SmartArt Graphic To Apply a SmartArt Style To Resize the SmartArt Graphic To Save and Print the Letter Enhancing a Document’s Accessibility Addressing and Printing Envelopes and Mailing Labels To Address and Print an Envelope Envelopes and Labels Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

Microsoft WD 3-20 WD 3-21 WD 3-21 WD 3-22 WD 3-23 WD 3-24 WD 3-24 WD 3-25 WD 3-26 WD 3-26 WD 3-27 WD 3-28 WD 3-29 WD 3-30 WD 3-31 WD 3-32 WD 3-32 WD 3-34 WD 3-35 WD 3-35 WD 3-37 WD 3-37 WD 3-38 WD 3-39 WD 3-39 WD 3-39 WD 3-40 WD 3-41 WD 3-43 WD 3-43 WD 3-44 WD 3-45 WD 3-46 WD 3-47

WD 3-49 WD 3-50 WD 3-51 WD WD WD WD WD WD

3-52 3-54 3-55 3-55 3-56 3-56

WD 3-57 WD 3-57 WD 3-58 WD 3-59 WD 3-60 WD 3-62 WD 3-64 WD 3-65

PowerPoint 2019

MODULE ONE Creating and Editing Presentations with Pictures Objectives What Is PowerPoint? Project: Presentation with a Bulleted List and Pictures Starting and Using PowerPoint To Start PowerPoint and Create a Blank Presentation The PowerPoint Window To Display a Different Tab on the Ribbon Creating a Title Slide To Choose a Presentation Theme To Enter the Presentation Title Correcting a Mistake When Typing Paragraphs To Enter the Presentation Subtitle Paragraph To Zoom a Slide Formatting Characters Fonts and Font Styles To Select a Paragraph To Italicize Text To Increase Font Size To Select a Word To Change the Text Color To Zoom a Slide To Save a Presentation for the First Time Adding a Slide with a Bulleted List To Add a New Title and Content Slide Creating a Multilevel Bulleted List To Enter a Slide Title To Select a Text Placeholder To Type a Multilevel Bulleted List To Type the Remaining Text

PPT 1-1 PPT 1-1 PPT 1-2 PPT 1-3 PPT 1-3 PPT 1-5 PPT 1-10 PPT 1-11 PPT 1-11 PPT 1-13 PPT 1-14 PPT 1-14 PPT 1-14 PPT 1-15 PPT 1-16 PPT 1-16 PPT 1-16 PPT 1-17 PPT 1-17 PPT 1-17 PPT 1-18 PPT 1-19 PPT 1-19 PPT 1-22 PPT 1-22 PPT 1-23 PPT 1-23 PPT 1-24 PPT 1-24 PPT 1-26

Microsoft Office 2019 Introductory Contents vii

To Select a Group of Words To Bold Text To Increase Font Size To Underline Text Adding Slides, Changing Slide Layouts, and Changing the Theme To Add a New Slide and Enter a Slide Title and Headings To Change the Font To Add a Slide with the Title Only Layout To Enter a Slide Title To Change the Theme PowerPoint Views To Move to Another Slide in Normal View Inserting, Resizing, and Moving Pictures To Insert a Picture into a Slide without a Content Placeholder To Insert another Picture into a Slide without a Content Placeholder To Insert Another Picture into a Slide without a Content Placeholder To Insert a Picture into a Content Placeholder Resizing Photos and Illustrations To Proportionally Resize Pictures To Resize the Picture on Slide 2 To Resize the Picture on Slide 4 To Move Pictures To Insert Another Picture into a Slide without a Content Placeholder To Rotate a Picture To Nonproportionally Resize the Picture on Slide 2 To Move a Slide in Normal View To Save a Presentation with the Same File Name To Close a File Using Backstage View To Open a Recent File Using Backstage View Making Changes to Slide Text Content Replacing Text in an Existing Slide Deleting Text To Delete Text in a Placeholder To Change the Theme Colors To Add Notes Checking Spelling To Check Spelling Document Properties Changing Views To Change Views Viewing the Presentation in Slide Show View To Start Slide Show View To Move Manually through Slides in a Slide Show Saving and Printing Files To Save a File with a Different File Name To Print Full Page Slides To Preview and Print a Handout To Print Speaker Notes To Change the Print Color Using PowerPoint Help To Obtain Help Using the Search Box

PPT 1-26 PPT 1-27 PPT 1-27 PPT 1-27 PPT 1-28 PPT 1-28 PPT 1-30 PPT 1-31 PPT 1-32 PPT 1-32 PPT 1-34 PPT 1-34 PPT 1-36 PPT 1-36 PPT 1-38 PPT 1-38 PPT 1-39 PPT 1-39 PPT 1-40 PPT 1-41 PPT 1-41 PPT 1-42 PPT 1-43 PPT 1-43 PPT 1-44 PPT 1-46 PPT 1-46 PPT 1-47 PPT 1-47 PPT 1-48 PPT 1-49 PPT 1-49 PPT 1-49 PPT 1-50 PPT 1-51 PPT 1-52 PPT 1-53 PPT 1-54 PPT 1-55 PPT 1-55 PPT 1-56 PPT 1-56 PPT 1-58 PPT 1-59 PPT 1-59 PPT 1-59 PPT 1-61 PPT 1-62 PPT 1-63 PPT 1-64 PPT 1-64

Obtaining Help while Working in PowerPoint To Obtain Help Using the Tell Me Box To Sign Out of a Microsoft Account Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

PPT 1-66 PPT 1-67 PPT 1-67 PPT 1-68 PPT 1-69 PPT 1-71 PPT 1-72 PPT 1-73

MODULE TWO Enhancing Presentations with Shapes and SmartArt Objectives Introduction Projectâ&#x20AC;&#x201D;Presentation with SmartArt and Shapes Downloading a Theme and Editing Slides To Search for and Download an Online Theme To Save the Presentation To Delete a Slide To Create a Title Slide To Align a Paragraph To Create the First Text Slide To Insert a Symbol To Copy a Symbol To Add a Hyperlink to a Paragraph Creating and Formatting a SmartArt Graphic To Convert Text to a SmartArt Graphic To Edit SmartArt Shape Text Text Pane To Edit SmartArt Bulleted Text To Format Text Pane Characters To Change the SmartArt Layout To Edit the Title Text To Duplicate a Slide To Insert a SmartArt Graphic To Add Text to the SmartArt Graphic To Apply a SmartArt Style Inserting and Formatting a Shape To Insert a Shape Resizing Shapes To Resize a Shape Proportionally To Resize a Shape Nonproportionally by Entering an Exact Measurement To Select All Slide Content To Apply a Shape Style To Copy and Paste a Shape To Add Text to a Shape To Select Shapes To Format Shape Text To Change a Shape Fill Color Positioning Slide Elements Aligning and Distributing Objects To Display the Drawing Guides To Display the Ruler To Display the Gridlines To Position a Shape Using Guides, Gridlines, and the Ruler To Position the Remaining Shapes To Distribute Shapes To Align a Shape To Position the Arrow Shape

PPT 2-1 PPT 2-1 PPT 2-1 PPT 2-3 PPT 2-3 PPT 2-5 PPT 2-5 PPT 2-7 PPT 2-7 PPT 2-8 PPT 2-9 PPT 2-11 PPT 2-12 PPT 2-13 PPT 2-14 PPT 2-15 PPT 2-16 PPT 2-17 PPT 2-18 PPT 2-19 PPT 2-21 PPT 2-21 PPT 2-22 PPT 2-23 PPT 2-24 PPT 2-25 PPT 2-25 PPT 2-27 PPT 2-28 PPT 2-28 PPT 2-30 PPT 2-31 PPT 2-32 PPT 2-33 PPT 2-34 PPT 2-34 PPT 2-35 PPT 2-36 PPT 2-37 PPT 2-38 PPT 2-38 PPT 2-39 PPT 2-40 PPT 2-41 PPT 2-41 PPT 2-42 PPT 2-43

viii Contents Microsoft Office 2019 Introductory

To Flip a Shape To Change the Stacking Order To Group Objects To Insert Additional Shapes To Merge Shapes To Hide the Grid and Guides To Hide Rulers To Apply a Picture Fill to a Shape To Change a Shape Outline Weight To Change a Shape Outline Color To Change a Shape Outline Style To Apply an Effect to a Shape To Rotate a Shape to an Exact Value To Add a Slide Title To Add and Format a Shape Adding a Footer To Add a Footer with Fixed Information Adding a Transition To Add a Transition between Slides To Save and Print the Presentation Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

PPT 2-44 PPT 2-44 PPT 2-45 PPT 2-46 PPT 2-47 PPT 2-48 PPT 2-48 PPT 2-49 PPT 2-50 PPT 2-51 PPT 2-52 PPT 2-52 PPT 2-53 PPT 2-54 PPT 2-54 PPT 2-55 PPT 2-55 PPT 2-56 PPT 2-57 PPT 2-59 PPT 2-59 PPT 2-60 PPT 2-63 PPT 2-64 PPT 2-66

MODULE THREE Inserting WordArt, Charts, and Tables Objectives Introduction Projectâ&#x20AC;&#x201D;Presentation with WordArt, a Chart, and a Table Adding a Chart to a Slide and Formatting To Run PowerPoint, Apply a Theme, and Save the Presentation To Delete a Placeholder To Insert a Chart To Replace Sample Data To Resize a Chart To Align a Chart To Change a Chart Style To Change the Shape Outline Color To Change the Shape Outline Weight To Change the Title and Legend Font and Font Size Adding a Table to a Slide and Formatting Tables To Insert an Empty Table To Enter Data in a Table To Apply a Table Style To Add Borders to a Table To Add an Effect to a Table To Insert a Table Row To Insert a Table Column To Resize a Table To Align a Table To Add a Slide Title Inserting and Formatting a Text Box To Insert a Text Box and Format Text To Format Text Box Characters Inserting and Moving Slides To Reuse Slides from an Existing Presentation

PPT 3-1 PPT 3-1 PPT 3-1 PPT 3-3 PPT 3-3 PPT 3-4 PPT 3-5 PPT 3-6 PPT 3-8 PPT 3-9 PPT 3-10 PPT 3-11 PPT 3-12 PPT 3-13 PPT 3-13 PPT 3-14 PPT 3-14 PPT 3-15 PPT 3-16 PPT 3-17 PPT 3-18 PPT 3-19 PPT 3-20 PPT 3-21 PPT 3-22 PPT 3-23 PPT 3-23 PPT 3-23 PPT 3-24 PPT 3-26 PPT 3-27

To Move a Slide in Slide Sorter View Inserting Pictures and Adding Effects To Delete a Picture To Insert and Resize a Picture into a Slide without Content Placeholders To Crop a Picture Adjusting Picture Colors To Color a Picture To Add an Artistic Effect to a Picture To Change the Picture Softness To Apply a Picture Style To Size a Picture To Move a Picture To Align Pictures Creating and Formatting WordArt To Insert WordArt To Change the WordArt Shape To Change the WordArt 3-D Rotation Effect To Change the WordArt Text Fill Color To Change the WordArt Text Outline Color To Convert Text to WordArt To Resize WordArt Proportionally Animating Slide Content Custom Animations To Animate an Object Using an Entrance Effect To Change Animation Direction To Change the Animation Start Option To Preview an Animation Sequence To Change the Animation Duration To Animate Text To Change the Animation Sequence Effect Option Adding Media to Slides To Insert a Video File To Resize a Video Clip To Move a Video Clip To Change Video Contrast To Play a Video File Automatically To Add a Transition between Slides To Run a Slide Show with Animations and Video To Save and Print the Presentation Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

Microsoft

PPT 3-29 PPT 3-30 PPT 3-30 PPT 3-31 PPT 3-31 PPT 3-33 PPT 3-34 PPT 3-35 PPT 3-36 PPT 3-37 PPT 3-37 PPT 3-38 PPT 3-39 PPT 3-40 PPT 3-40 PPT 3-41 PPT 3-43 PPT 3-44 PPT 3-44 PPT 3-45 PPT 3-45 PPT 3-46 PPT 3-46 PPT 3-47 PPT 3-47 PPT 3-48 PPT 3-49 PPT 3-49 PPT 3-50 PPT 3-50 PPT 3-51 PPT 3-52 PPT 3-53 PPT 3-54 PPT 3-54 PPT 3-55 PPT 3-56 PPT 3-56 PPT 3-57 PPT 3-57 PPT 3-58 PPT 3-60 PPT 3-61 PPT 3-62

Excel 2019

MODULE ONE Creating a Worksheet and a Chart Objectives Introduction Project: Real Estate Budget Worksheet and Chart Starting and Using Excel What Is Excel? To Start Excel and Create a Blank Workbook The Excel Window

EX 1-1 EX 1-1 EX 1-1 EX 1-4 EX 1-4 EX 1-5 EX 1-7

Microsoft Office 2019 Introductory Contents ix

To Display a Different Tab on the Ribbon EX 1-12 Selecting a Cell EX 1-12 Entering Text EX 1-12 To Enter the Worksheet Titles EX 1-13 AutoCorrect EX 1-15 To Enter Column Titles EX 1-15 To Enter Row Titles EX 1-17 Entering Numbers EX 1-18 To Enter Numbers EX 1-18 Calculating Sums and Using Formulas EX 1-20 To Sum a Column of Numbers EX 1-20 Using the Fill Handle to Copy a Cell to Adjacent Cells EX 1-21 To Copy a Cell to Adjacent Cells in a Row EX 1-22 To Calculate Multiple Totals at the Same Time EX 1-24 Calculating Average, Maximum, and Minimum Values EX 1-25 To Enter a Formula Using the Keyboard EX 1-26 To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle EX 1-27 Saving the Project EX 1-27 To Save a Workbook EX 1-28 Formatting the Worksheet EX 1-30 Font Style, Size, and Color EX 1-32 To Change a Cell Style EX 1-32 To Change the Font EX 1-34 To Apply Bold Style to a Cell EX 1-35 To Increase the Font Size of a Cell Entry EX 1-36 To Change the Font Color of a Cell Entry EX 1-37 To Center Cell Entries across Columns by Merging Cells EX 1-38 To Format Rows Using Cell Styles EX 1-39 To Format Numbers in the Worksheet EX 1-41 To Adjust the Column Width EX 1-42 To Use the Name Box to Select a Cell EX 1-44 Other Ways to Select Cells EX 1-44 Adding a Pie Chart to the Worksheet EX 1-45 To Add a Pie Chart EX 1-46 To Apply a Style to a Chart EX 1-48 Changing the Sheet Tab Names and Colors EX 1-49 To Move a Chart to a New Sheet EX 1-49 To Change the Sheet Tab Name and Color EX 1-50 Document Properties EX 1-51 Printing a Worksheet EX 1-52 To Preview and Print a Worksheet in Landscape Orientation EX 1-53 Viewing Automatic Calculations EX 1-56 To Use the AutoCalculate Area to Determine a Maximum EX 1-56 Correcting Errors EX 1-57 Correcting Errors while Entering Data into a Cell EX 1-57 Correcting Errors after Entering Data into a Cell EX 1-57 Undoing the Last Cell Entry EX 1-59 Clearing a Cell or Range of Cells EX 1-59 Clearing the Entire Worksheet EX 1-60 Using Excel Help EX 1-60 To Obtain Help Using the Search Text Box EX 1-61 Obtaining Help while Working in an Office App EX 1-63 To Obtain Help Using the Tell Me Box EX 1-63 To Save a Workbook with a Different File Name EX 1-64 To Sign Out of a Microsoft Account EX 1-64

Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

EX 1-65 EX 1-66 EX 1-68 EX 1-69 EX 1-69

MODULE TWO Formulas, Functions, and Formatting Objectives Introduction Project: Worksheet with Formulas and Functions Entering the Titles and Numbers into the Worksheet To Enter the Worksheet Title and Subtitle To Enter the Column Titles To Enter the Salary Data Flash Fill To Use Flash Fill To Enter the Row Titles To Change the Sheet Tab Name and Color Entering Formulas To Enter a Formula Using the Keyboard Arithmetic Operations Order of Operations To Enter Formulas Using Point Mode To Copy Formulas Using the Fill Handle Option Buttons To Determine Totals Using the AutoSum Button To Determine the Total Tax Percentage Using the AVERAGE, MAX, MIN, and other Statistical Functions To Determine the Highest Number in a Range of Numbers Using the Insert Function Dialog Box To Determine the Lowest Number in a Range of Numbers Using the Sum Menu To Determine the Average of a Range of Numbers Using the Keyboard To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle Verifying Formulas Using Range Finder To Verify a Formula Using Range Finder Formatting the Worksheet To Change the Workbook Theme To Format the Worksheet Titles To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle To Apply a Cell Style to the Column Headings and Format the Total Rows To Format Dates and Center Data in Cells To Apply an Accounting Number Format and Comma Style Format Using the Ribbon To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box To Apply a Percent Style Format and Use the Increase Decimal Button Conditional Formatting To Apply Conditional Formatting Conditional Formatting Operators Changing Column Width and Row Height

EX 2-1 EX 2-1 EX 2-2 EX 2-4 EX 2-4 EX 2-5 EX 2-5 EX 2-6 EX 2-7 EX 2-8 EX 2-8 EX 2-9 EX 2-9 EX 2-10 EX 2-10 EX 2-11 EX 2-13 EX 2-14 EX 2-14 EX 2-15 EX 2-16

EX 2-16 EX 2-18 EX 2-20

EX 2-21 EX 2-22 EX 2-22 EX 2-23 EX 2-24 EX 2-25

EX 2-26 EX 2-27 EX 2-28 EX 2-29

EX 2-30 EX 2-31 EX 2-31 EX 2-32 EX 2-34 EX 2-35

x Contents Microsoft Office 2019 Introductory

To Change Column Width To Change Row Height Checking Spelling To Check Spelling on the Worksheet Additional Spelling Checker Considerations Printing the Worksheet To Change the Worksheet’s Margins, Header, and Orientation in Page Layout View To Print a Worksheet To Print a Section of the Worksheet Displaying and Printing the Formulas Version of the Worksheet To Display the Formulas in the Worksheet and Fit the Printout on One Page To Change the Print Scaling Option Back to 100% Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

EX 2-35 EX 2-38 EX 2-39 EX 2-40 EX 2-41 EX 2-41 EX 2-42 EX 2-44 EX 2-45 EX 2-46 EX 2-47 EX 2-48 EX 2-49 EX 2-50 EX 2-51 EX 2-52 EX 2-53

MODULE THREE Working with Large Worksheets, Charting, and What-If Analysis Objectives Introduction Project: Financial Projection Worksheet with What-If Analysis and Chart To Enter the Worksheet Titles and Apply a Theme Rotating Text and Using the Fill Handle to Create a Series To Rotate Text in a Cell To Use the Fill Handle to Create a Series of Month Names Using the Auto Fill Options Menu To Increase Column Widths To Enter and Indent Row Titles Copying a Range of Cells to a Nonadjacent Destination Area To Copy a Range of Cells to a Nonadjacent Destination Area Using the Paste Options Menu Using Drag and Drop to Move or Copy Cells Using Cut and Paste to Move Cells Inserting and Deleting Cells in a Worksheet To Insert a Row Inserting Columns Inserting Single Cells or a Range of Cells Deleting Columns and Rows To Enter Numbers with Format Symbols To Enter the Projected Monthly Sales To Enter and Format the System Date Absolute versus Relative Addressing To Enter a Formula Containing Absolute Cell References Making Decisions—The IF Function To Enter an IF Function To Enter the Remaining Formulas for January To Copy Formulas with Absolute Cell References Using the Fill Handle To Determine Row Totals in Nonadjacent Cells EX

EX 3-1 EX 3-1 EX 3-2 EX 3-5 EX 3-5 EX 3-5 EX 3-7 EX 3-8 EX 3-9 EX 3-10 EX 3-10 EX 3-11 EX 3-12 EX 3-12 EX 3-13 EX 3-13 EX 3-14 EX 3-15 EX 3-15 EX 3-16 EX 3-16 EX 3-17 EX 3-18 EX 3-20 EX 3-22 EX 3-24 EX 3-25 EX 3-26 EX 3-27 3-28

Nested Forms of the IF Function Adding and Formatting Sparkline Charts To Add a Sparkline Chart to the Worksheet To Change the Sparkline Style and Copy the Sparkline Chart To Change the Sparkline Type Customizing Sparkline Charts Formatting the Worksheet To Assign Formats to Nonadjacent Ranges To Format the Worksheet Titles To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell To Copy a Cell’s Format Using the Format Painter Button To Format the What-If Assumptions Table Adding a Clustered Column Chart to the Workbook To Draw a Clustered Column Chart on a Separate Chart Sheet Using the Recommended Charts Feature To Insert a Chart Title To Add Data Labels To Apply Chart Filters To Add an Axis Title to the Chart To Change the Chart Style To Modify the Chart Axis Number Format To Remove Filters and Data Labels Organizing the Workbook To Rename and Color Sheet Tabs To Reorder the Sheet Tabs To Check Spelling in Multiple Sheets To Preview and Print the Worksheet Changing the View of the Worksheet To Shrink and Magnify the View of a Worksheet or Chart To Split a Window into Panes To Remove the Panes from the Window To Freeze Worksheet Columns and Rows To Unfreeze the Worksheet Columns and Rows What-If Analysis To Analyze Data in a Worksheet by Changing Values Goal Seeking To Goal Seek Insights To Use the Smart Lookup Insight Accessibility Features Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

Microsoft

EX 3-29 EX 3-30 EX 3-30 EX 3-31 EX 3-32 EX 3-33 EX 3-33 EX 3-34 EX 3-36 EX 3-37 EX 3-38 EX 3-39 EX 3-39

EX 3-40 EX 3-42 EX 3-42 EX 3-43 EX 3-44 EX 3-45 EX 3-46 EX 3-47 EX 3-48 EX 3-48 EX 3-48 EX 3-49 EX 3-49 EX 3-50 EX 3-50 EX 3-52 EX 3-53 EX 3-53 EX 3-55 EX 3-55 EX 3-55 EX 3-56 EX 3-56 EX 3-58 EX 3-58 EX 3-59 EX 3-60 EX 3-61 EX 3-62 EX 3-64 EX 3-65

Access 2019

MODULE ONE Databases and Database Objects: An Introduction Objectives Introduction Project—Database Creation Creating a Database To Create a Database

AC 1-1 AC 1-1 AC 1-1 AC 1-4 AC 1-5

Microsoft Office 2019 Introductory Contents xi

To Create a Database Using a Template The Access Window Navigation Pane and Access Work Area Determining Tables and Fields Naming Tables and Fields Determining the Primary Key Determining Data Types for the Fields Creating a Table in Datasheet View To Modify the Primary Key To Define the Remaining Fields in a Table Making Changes to the Structure To Save a Table To View the Table in Design View Checking the Structure in Design View To Close the Table To Add Records to a Table Making Changes to the Data Navigation Buttons To Resize Columns in a Datasheet To Create a Table in Design View Correcting Errors in the Structure Populating the Patients Table To Close the Table To Resize Columns in a Datasheet Importing Additional Access Database Tables into an Existing Database Additional Database Objects Creating Queries To Use the Simple Query Wizard to Create a Query Using Queries Creating Forms To Create a Form Using a Form To Create a Report Using the Report Wizard Using Layout View in a Report Database Properties Special Database Operations Backup and Recovery Compacting and Repairing a Database Additional Operations To Exit Access Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

AC 1-6 AC 1-6 AC 1-6 AC 1-7 AC 1-7 AC 1-7 AC 1-7 AC 1-9 AC 1-10 AC 1-12 AC 1-13 AC 1-14 AC 1-15 AC 1-16 AC 1-16 AC 1-17 AC 1-20 AC 1-21 AC 1-21 AC 1-24 AC 1-25 AC 1-25 AC 1-26 AC 1-26 AC 1-26 AC 1-29 AC 1-29 AC 1-29 AC 1-31 AC 1-31 AC 1-31 AC 1-34 AC 1-34 AC 1-36 AC 1-37 AC 1-37 AC 1-37 AC 1-38 AC 1-39 AC 1-39 AC 1-40 AC 1-41 AC 1-42 AC 1-43 AC 1-44

MODULE TWO

AC 2-10 AC 2-12 AC 2-13 AC 2-14 AC 2-15 AC 2-16 AC 2-17 AC 2-17 AC 2-19 AC 2-19 AC 2-20 AC 2-21 AC 2-22 AC 2-22 AC 2-23 AC 2-23 AC 2-24 AC 2-26 AC 2-28 AC 2-29 AC 2-30 AC 2-32 AC 2-34 AC 2-35 AC 2-36 AC 2-36 AC 2-37 AC 2-37 AC 2-38 AC 2-40 AC 2-41 AC 2-42 AC 2-43 AC 2-43 AC 2-46 AC 2-47 AC 2-49 AC 2-51 AC 2-52 AC 2-53 AC 2-56 AC 2-56 AC 2-57 AC 2-59 AC 2-60 AC 2-61 AC 2-62

MODULE THREE

Querying a Database Objectives Introduction Project — Querying a Database Creating Queries To Create a Query in Design View To Add Records to the Database To Add Fields to the Design Grid Determining Criteria Running the Query To Use Text Data in a Criterion Using Saved Queries Wildcards

To Use a Wildcard To Use Criteria for a Field Not Included in the Results Creating a Parameter Query To Create and View a Parameter Query To Use a Parameter Query To Use a Number in a Criterion Comparison Operators To Use a Comparison Operator in a Criterion Using Compound Criteria To Use a Compound Criterion Involving AND To Use a Compound Criterion Involving OR Special Criteria Sorting To Clear the Design Grid To Import a Table To Sort Data in a Query To Omit Duplicates To Sort on Multiple Keys To Create a Top-Values Query Joining Tables To Join Tables To Change Join Properties To Create a Report from a Query To Print a Report Creating a Form for a Query To Create a Form for a Query Using a Form Exporting Data from Access to Other Applications To Export Data to Excel Text Files Adding Criteria to a Join Query To Restrict the Records in a Join Calculations To Use a Calculated Field in a Query To Change a Caption To Calculate Statistics To Use Criteria in Calculating Statistics To Use Grouping Crosstab Queries To Create a Crosstab Query Customizing the Navigation Pane To Customize the Navigation Pane Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Lab

AC 2-1 AC 2-1 AC 2-1 AC 2-3 AC 2-3 AC 2-5 AC 2-6 AC 2-7 AC 2-7 AC 2-7 AC 2-9 AC 2-9

Maintaining a Database Objectives Introduction Project — Maintaining a Database Updating Records To Create a Split Form To Use a Form to Add Records To Search for a Record To Update the Contents of a Record To Delete a Record Filtering Records To Use Filter By Selection

AC 3-1 AC 3-1 AC 3-1 AC 3-2 AC 3-3 AC 3-5 AC 3-5 AC 3-7 AC 3-7 AC 3-8 AC 3-9

xii Contents Microsoft Office 2019 Introductory

To Toggle a Filter To Clear a Filter To Use a Common Filter To Use Filter By Form To Use Advanced Filter/Sort Filters and Queries Changing the Database Structure To Change a Number Field Size in Design View To Add a New Field To Create a Lookup Field To Add a Multivalued Field To Add a Calculated Field To Save the Changes and Close the Table Mass Changes To Use an Update Query Validation Rules To Change a Field Size To Specify a Required Field To Specify a Range To Specify a Default Value To Specify a Collection of Legal Values To Save the Validation Rules, Default Values, and Formats Updating a Table That Contains Validation Rules Making Additional Changes to the Database To Change the Contents of a Field To Use a Lookup Field To Use a Multivalued Lookup Field

AC 3-10 AC 3-10 AC 3-11 AC 3-12 AC 3-13 AC 3-14 AC 3-15 AC 3-17 AC 3-19 AC 3-20 AC 3-22 AC 3-23 AC 3-25 AC 3-25 AC 3-26 AC 3-28 AC 3-28 AC 3-29 AC 3-29 AC 3-30 AC 3-30 AC 3-31 AC 3-32 AC 3-34 AC 3-34 AC 3-34 AC 3-35

Changing the Appearance of a Datasheet To Include Totals in a Datasheet To Remove Totals from a Datasheet To Change Gridlines in a Datasheet To Change the Colors and Font in a Datasheet Using the Datasheet Formatting Dialog Box To Close the Datasheet without Saving the Format Changes Multivalued Fields in Queries To Include Multiple Values on One Row of a Query To Include Multiple Values on Multiple Rows of a Query To Test an Existing Query with a Multivalued Field Referential Integrity To Specify Referential Integrity Effect of Referential Integrity To Use a Subdatasheet Handling Data Inconsistency Ordering Records To Use the Ascending Button to Order Records Summary Apply Your Knowledge Extend Your Knowledge Expand Your World In the Labs Index

AC 3-37 AC 3-37 AC 3-38 AC 3-39 AC 3-40 AC 3-41 AC 3-41 AC 3-42 AC 3-42 AC 3-43 AC 3-44 AC 3-44 AC 3-45 AC 3-48 AC 3-49 AC 3-51 AC 3-51 AC 3-52 AC 3-53 AC 3-54 AC 3-55 AC 3-56 AC 3-56 I-1