Microsoft Office 365: In Practice, 2019 Edition
- Length: 1248 pages
- Edition: 1
- Language: English
- Publisher: McGraw-Hill Education
- Publication Date: 2019-03-18
- ISBN-10: 1260079902
- ISBN-13: 9781260079906
- Sales Rank: #149761 (See Top 100 Books)
Microsoft® Office365/2019: In Practice offers a fresh approach to teaching today’s students Microsoft® Officeskills by clearly introducing skills in logical order: 1) Topic 2) Instructionand 3) Practice.
Nordell’s TIP approach builds a foundation for success by helpingstudents apply what they learn, and provides transferable skills that allowstudents to grasp critical thinking beyond the textbook assignments.
In Practice seamlessly integrates with SIMnet,McGraw-Hill Education’s learning and assessment solution, which houses contentto help students practice and master computing concepts and Microsoft® Officeskills. In Practice auto-graded projects allow students to practicetheir skills in a live Office application, and upon completion receiveimmediate feedback and insights.
The integration of the In Practice textbook series with SIMnet,helps meet the diverse needs of students and accommodate individual learningstyles.
Cover Microsoft® Office 365: IN PRACTICE: 2019 dedication brief contents contents about the authors preface instructor walkthrough acknowledgments windows & office Intro Chapter: Windows 10, Office 365/2019, and File Management Chapter Overview Student Learning Outcomes (SLOs) Case Study Intro. 1—Using Windows 10 Windows 10 Microsoft Account Windows Desktop and Taskbar Start Menu Add Apps Customize the Start Menu Customize the Taskbar File Explorer OneDrive OneDrive Online Cortana Task View Settings Action Center Intro. 2—Using Microsoft Office Office 2019 and Office 365 Office 365 Products, Versions, and Update Channels Office Desktop Apps, Office Mobile Apps, and Office Online Open an Office Desktop Application Office Start Page Backstage View Office Help—Tell Me Mouse and Pointers Touch Mode and Touch-Screen Gestures Intro. 3—Creating, Saving, Closing, and Opening Office Files Create a New File Save a File AutoSave Create a New Folder When Saving a File Save As a Different File Name Office File Types Close a File Open an Existing File Pause & Practice Intro-1 Intro. 4—Working with Files File Views Change Display Size Manage Multiple Open Files and Windows Snap Assist Intro. 5—Printing, Sharing, and Customizing Files Print a File Export as a PDF File Document Properties Share a File Program Options Intro. 6—Using the Ribbon, Tabs, and Quick Access Toolbar The Ribbon, Tabs, and Groups Ribbon Display Options Buttons, Drop-Down Lists, and Galleries Dialog Boxes, Task Panes, and Launchers ScreenTips Radio Buttons, Check Boxes, and Text Boxes Quick Access Toolbar Customize the Quick Access Toolbar Intro. 7—Using Context Menus, the Mini Toolbar, and Keyboard Shortcuts Context Menu Mini Toolbar Keyboard Shortcuts Function Keys on a Laptop Pause & Practice Intro-2 Intro. 8—Organizing and Customizing Folders and Files Create a Folder Move and Copy Files and Folders Rename Files and Folders Delete Files and Folders Create a Zipped (Compressed) Folder Extract a Zipped (Compressed) Folder Pause & Practice Intro-3 Chapter Summary Using Microsoft Windows 10 and Office 365 Guided Project Intro-1 Guided Project Intro-2 Independent Project Intro-3 Independent Project Intro-4 Challenge Project Intro-5 Challenge Project Intro-6 word CHAPTER 1: Creating and Editing Documents Chapter Overview Student Learning Outcomes (SLOs) Case Study 1.1—Creating, Saving, and Opening Documents Create a New Document Save a Document AutoSave Save As a Different File Name Open a Document Pin a Frequently Used Document 1.2—Entering and Selecting Text Type Text and Use Word Wrap Show/Hide Formatting Symbols Select Text AutoComplete AutoCorrect and AutoFormat AutoCorrect Smart Tag Add Custom AutoCorrect Entry 1.3—Using Paragraph Breaks, Line Breaks, and Non-Breaking Spaces Paragraph Breaks Line Breaks Spaces and Non-Breaking Spaces Pause & Practice: Word 1-1 1.4—Moving and Copying Text Move Text Copy Text Paste Text and Paste Options Clipboard Pane Undo Change Redo and Repeat Change 1.5—Changing Fonts, Font Sizes, and Attributes Font and Font Size Bold, Italic, and Underline Font Styles Other Font Style Buttons Change Case Font Dialog Box Font Color Underline Style and Color Font Effects Character Spacing Text Effects Format Painter Clear All Formatting Change Default Font and Font Size Pause & Practice: Word 1-2 1.6—Changing Text Alignment, Line Spacing, and Paragraph Spacing Default Settings Paragraph Alignment Line Spacing Paragraph Spacing Paragraph Dialog Box Change Default Line and Paragraph Spacing 1.7—Using Smart Lookup and Proofreading Tools Smart Lookup and the Smart Lookup Pane Automatic Spelling and Grammar Notifications Editor Pane Customize the Dictionary The Thesaurus Word Count Read Aloud Learning Tools 1.8—Customizing Document Properties Document Properties Advanced Properties Print Document Properties Pause & Practice: Word 1-3 Chapter Summary Check for Understanding Using Microsoft Word 365 Guided Project 1-1 Guided Project 1-2 Guided Project 1-3 Independent Project 1-4 Independent Project 1-5 Independent Project 1-6 Improve It Project 1-7 Challenge Project 1-8 Challenge Project 1-9 Challenge Project 1-10 CHAPTER 2: Formatting and Customizing Documents Chapter Overview Student Learning Outcomes (SLOs) Case Study 2.1—Customizing Margins and Page Layout Page Layout Settings Margin Settings Page Setup Dialog Box Page Orientation Paper Size Vertical Alignment Use the Ruler Page Movement 2.2—Setting, Using, and Editing Tab Stops Set a Tab Stop Set a Tab Stop Using the Tabs Dialog Box Set a Tab Stop Using the Ruler Move a Tab Stop Remove a Tab Stop Add a Tab Leader Change Default Tab Stops 2.3—Using Indents Left and Right Indents First Line and Hanging Indents Remove Indents Pause & Practice: Word 2-1 2.4—Inserting Page Numbers, Headers, and Footers Page Numbering Insert Page Number Edit Page Number in Header or Footer Different First Page Page Number Format Remove Page Number Insert Header and Footer Content Number of Pages Field Date and Time Document Properties Built-In Headers, Footers, and Page Numbers Pause & Practice: Word 2-2 2.5—Using Page and Section Breaks Page Breaks Section Breaks Edit Page and Section Breaks 2.6—Using Bulleted, Numbered, and Multilevel Lists Create a Bulleted List Customize a Bulleted List Create a Numbered List Customize a Numbered List Multilevel Lists 2.7—Using Styles and Themes Style Gallery Apply a Built-In Style Modify a Style Apply a Theme Pause & Practice: Word 2-3 2.8—Using Find and Replace and Resume Assistant Find Find and Replace Go To Resume Assistant 2.9—Using Borders, Shading, and Hyperlinks Apply Built-In Borders Customize Borders Apply Shading Apply a Page Border Insert a Horizontal Line Create a Hyperlink Edit or Remove a Hyperlink Pause & Practice: Word 2-4 Chapter Summary Check for Understanding Using Microsoft Word 365 Guided Project 2-1 Guided Project 2-2 Guided Project 2-3 Independent Project 2-4 Independent Project 2-5 Independent Project 2-6 Improve It Project 2-7 Challenge Project 2-8 Challenge Project 2-9 Challenge Project 2-10 CHAPTER 3: Collaborating with Others and Working with Reports Chapter Overview Student Learning Outcomes (SLOs) Case Study 3.1—Using Comments Change User Name Insert a Comment Ink Comments Review Comments Reply to a Comment Resolve Comment Edit and Delete Comments 3.2—Using Track Changes and Sharing Track Changes Display for Review Views Accept and Reject Changes Reviewing Pane Share an Online File Create a Sharing Link Pause & Practice: Word 3-1 3.3—Using Footnotes and Endnotes Insert a Footnote Insert an Endnote View Footnotes and Endnotes Customize Footnotes and Endnotes Modify Footnote and Endnote Format Modify Footnote and Endnote Styles Convert Footnotes and Endnotes Move Footnotes and Endnotes Delete Footnotes and Endnotes 3.4—Creating a Bibliography and Inserting Citations Report Styles Bibliography Styles Add a New Source Insert a Citation Insert a Placeholder Manage Sources Edit Citations and Sources Use the Researcher Insert a Bibliography Pause & Practice: Word 3-2 3.5—Inserting a Table of Contents Use Heading Styles for a Table of Contents Insert a Built-In Table of Contents Insert a Custom Table of Contents Modify a Table of Contents Update a Table of Contents Remove a Table of Contents 3.6—Inserting a Cover Page Insert a Built-In Cover Page Customize Cover Page Content Customize Document Property Content Add or Remove Document Property Fields Customize Content Control Fields Remove a Cover Page 3.7—Using Advanced Headers and Footers Page and Section Breaks Built-In Headers, Footers, and Page Numbers Customize Header and Footer Content Different First Page Header and Footer Different Odd and Even Pages Link to Previous Header or Footer Format Page Numbers Navigate between Headers and Footers Remove a Header or Footer Pause & Practice: Word 3-3 Chapter Summary Check for Understanding Using Microsoft Word 365 Guided Project 3-1 Guided Project 3-2 Guided Project 3-3 Independent Project 3-4 Independent Project 3-5 Independent Project 3-6 Improve It Project 3-7 Challenge Project 3-8 Challenge Project 3-9 Challenge Project 3-10 CHAPTER 4: Using Tables,Columns, and Graphics Chapter Overview Student Learning Outcomes (SLOs) Case Study 4.1—Creating and Editing Tables Tables Navigate within a Table Table Tools Layout Tab Select Table and Text Add Rows and Columns Merge and Split Cells Copy or Move Columns and Rows Delete Columns and Rows Delete a Table 4.2—Arranging Text in Tables Resize Columns and Rows AutoFit a Table Distribute Rows and Columns Text Alignment Cell Margins Table Properties Dialog Box Sort Data in Tables Pause & Practice: Word 4-1 4.3—Formatting and Editing Tables Table Tools Design Tab Table Borders View Gridlines Table Shading Table Styles Table Style Options Insert a Formula in a Table Update a Formula Convert Text to a Table Pause & Practice: Word 4-2 4.4—Using Columns Preset Column Settings Customize Columns Convert Text to Columns Insert a Column Break Balance Columns Pause & Practice: Word 4-3 4.5—Working with Graphics Pictures and Online Pictures Insert a Picture Use Alt Text Insert an Online Picture Resize a Graphic Wrap Text around a Graphic Position a Graphic Insert a Caption Group Graphic Objects 4.6—Working with Other Graphic Objects Insert and Customize a Shape Insert and Customize SmartArt Insert and Customize WordArt Modify Graphics with Styles Insert Icons and 3D Models Insert Online Video Insert Symbols and Special Characters Pause & Practice: Word 4-4 Chapter Summary Check for Understanding Using Microsoft Word 365 Guided Project 4-1 Guided Project 4-2 Guided Project 4-3 Independent Project 4-4 Independent Project 4-5 Independent Project 4-6 Improve It Project 4-7 Challenge Project 4-8 Challenge Project 4-9 Challenge Project 4-10 excel CHAPTER 1: Creating and Editing Workbooks Chapter Overview Student Learning Outcomes (SLOs) Case Study 1.1—Creating, Saving, and Opening a Workbook Create a New Workbook Save and Close a Workbook Open a Workbook Save a Workbook with a Different File Name Workbook File Formats 1.2—Entering and Editing Data Enter Labels and Values Edit Cell Contents Replace or Clear Cell Contents Align and Indent Cell Contents Select Cells The Fill Handle AutoComplete Cut, Copy, and Paste Cell Contents Move or Cut Cell Contents The Office Clipboard Copy Cell Contents Paste Options Pause & Practice: Excel 1-1 1.3—Using the SUM Function Function Syntax Copy the SUM Function Edit the Function Argument 1.4—Formatting a Worksheet Font Face, Size, Style, and Color The Format Painter Number Formats Borders and Fill Cell Styles Workbook Themes Pause & Practice: Excel 1-2 1.5—Modifying Columns and Rows Adjust Column Width and Row Height AutoFit Columns and Rows Wrap Text, Merge Cells, and Center Across Selection Insert and Delete Columns and Rows Hide and Unhide Columns and Rows 1.6—Inserting, Deleting, and Moving Worksheets Insert and Delete Worksheets Rename Worksheets and Change Tab Color Move and Copy Worksheets Pause & Practice: Excel 1-3 1.7—Modifying the Appearance of a Workbook Workbook Views Zoom Options Freeze Panes Split a Worksheet into Panes Hide or Unhide Worksheets Switch Windows Command View Multiple Worksheets 1.8—Finalizing a Workbook Check Spelling Document Properties The Properties Dialog Box The Page Setup Dialog Box Margins, Page Orientation, and Paper Size Headers and Footers Page Breaks Preview and Move a Page Break Remove a Manual Page Break Customize Print Settings Scale to Fit Print Area Print a Worksheet or Workbook Pause & Practice: Excel 1-4 Chapter Summary Check for Understanding Using Microsoft Excel 365 Guided Project 1-1 Guided Project 1-2 Guided Project 1-3 Independent Project 1-4 Independent Project 1-5 Independent Project 1-6 Improve It Project 1-7 Challenge Project 1-8 Challenge Project 1-9 Challenge Project 1-10 CHAPTER 2: Working with Formulas and Functions Chapter Overview Student Learning Outcomes (SLOs) Case Study 2.1—Building and Editing a Formula Type a Formula Point and Click to Build a Formula Edit a Formula 2.2—Setting Mathematical Order of Operations Multiple Operators in a Formula 2.3—Using Absolute, Mixed, Relative, and 3D References Copy a Formula with a Relative Reference Build and Copy a Formula with an Absolute Reference Build and Copy a Formula with a Mixed Reference Create a Formula with a 3D Reference Range Names and Formula AutoComplete 2.4—Using Formula Auditing Tools The Formula Auditing Group Trace Precedents and Dependents The Formula Correction Message Window Circular Reference Pause & Practice: Excel 2-1 2.5—Working with Statistical and Date & Time Functions Average Function Count Functions Max and Min Functions AutoCalculate Today and Now Functions Pause & Practice: Excel 2-2 2.6—Working with Financial, Logical, and Lookup Functions The Function Arguments Dialog Box PMT Function IF Function Lookup Functions 2.7—Using Math & Trig Functions Round Function Sumif Function SUMPRODUCT Function Pause & Practice: Excel 2-3 Chapter Summary Check for Understanding Using Microsoft Excel 365 Guided Project 2-1 Guided Project 2-2 Guided Project 2-3 Independent Project 2-4 Independent Project 2-5 Independent Project 2-6 Improve It Project 2-7 Challenge Project 2-8 Challenge Project 2-9 Challenge Project 2-10 CHAPTER 3: Creating and Editing Charts Chapter Overview Student Learning Outcomes (SLOs) Case Study 3.1—Creating a Chart Object and a Chart Sheet Create a Chart Object Excel Chart Types Size and Position a Chart Object Create a Chart Sheet 3.2—Using Quick Layouts and Chart Styles Apply a Quick Layout Apply a Chart Style Change Chart Colors Print a Chart Pause & Practice: Excel 3-1 3.3—Editing Chart Elements and Data Add and Remove Chart Elements Chart and Axes Titles Data Labels Data Table Trendlines Switch Row and Column Data Change the Chart Type Filter Source Data Edit Source Data 3.4—Formatting Chart Elements Apply a Shape Style Apply Shape Fill, Outline, and Effects The Format Task Pane 3.5—Using Pictures, Shapes, and WordArt in a Chart Use a Picture as Shape Fill Insert Shapes Use WordArt in a Chart Pause & Practice: Excel 3-2 3.6—Building Pie and Combination Charts Create a 3-D Pie Chart Pie Chart Elements and Options Create a Combination Chart Combination Chart Elements and Options 3.7—Creating Sunburst and Waterfall Charts Create a Sunburst Chart Create a Waterfall Chart 3.8—Inserting and Formatting Sparklines Insert Sparklines Sparkline Design Tools Clear Sparklines Pause & Practice: Excel 3-3 Chapter Summary Check for Understanding Using Microsoft Excel 365 Guided Project 3-1 Guided Project 3-2 Guided Project 3-3 Independent Project 3-4 Independent Project 3-5 Independent Project 3-6 Improve It Project 3-7 Challenge Project 3-8 Challenge Project 3-9 Challenge Project 3-10 CHAPTER 4: Formatting, Organizing, and Getting Data Chapter Overview Student Learning Outcomes (SLOs) Case Study 4.1—Creating and Formatting an Excel Table Create an Excel Table Table Styles and Options The Table Tools and Properties Groups Structured References and Table Formulas 4.2—Applying Conditional Formatting Highlight Cells Rules Top/Bottom Rules Use a Formula for a Rule Data Bars, Color Scales, and Icon Sets Manage Conditional Formatting Rules Pause & Practice: Excel 4-1 4.3—Sorting Data Sort Options Sort Data by One Column Sort Data by Multiple Columns Sort Data by Cell Attribute Sort Data in an Excel Table 4.4—Filtering Data AutoFilters Custom AutoFilter Advanced Filter 4.5—Using Subtotals, Groups, and Outlines The Subtotal Command Outline Buttons Create an Auto Outline Define Groups Pause & Practice: Excel 4-2 4.6—Importing Data Text Files Word Documents Access Database Files Web Site Data Workbook Queries and Connections Flash Fill 4.7—Exporting Data Export Data as a Text File Export Data via the Clipboard SharePoint Lists Pause & Practice: Excel 4-3 4.8—Building and Formatting PivotTables Create a PivotTable The PivotTable Fields Pane Field Settings Format a PivotTable PivotTable Layout Refresh a PivotTable Calculated Fields Create a PivotChart Pause & Practice: Excel 4-4 Chapter Summary Check for Understanding Using Microsoft Excel 365 Guided Project 4-1 Guided Project 4-2 Guided Project 4-3 Independent Project 4-4 Independent Project 4-5 Independent Project 4-6 Improve It Project 4-7 Challenge Project 4-8 Challenge Project 4-9 Challenge Project 4-10 access CHAPTER 1: Creating a Database and Tables Chapter Overview Student Learning Outcomes (SLOs) Case Study 1.1—Understanding Database Concepts Organize Data The Access Interface Examine Access Objects Use the Navigation Pane Use Datasheet and Design View of a Table Pause & Practice: Access 1-1 1.2—Creating and Managing a Database Templates Database Properties Create a Blank Database Access Naming Rules Data Types Create and Save Database Objects Open Database Objects Rename Database Objects Delete Database Objects Close and Open a Database Back Up and Recover a Database 1.3—Creating and Using a Table in Datasheet View Create a New Table in Datasheet View Edit the Default Primary Key Add New Fields Add New Fields by Entering Field Names Add New Fields by Entering Data Delete Fields Edit Properties in Datasheet View Add a Table Description Save a Table Close a Table Open a Table Rename a Table Add, Edit, and Delete Records Pause & Practice: Access 1-2 1.4—Importing Data Records from Excel 1.5—Exploring Datasheet View Navigation Buttons Refine the Datasheet Layout Modify the Field Order Select a Display Font Face and Font Size Modify the Row Height Modify the Column Width Modify the Field Alignment Display Gridlines Display Alternate Row Colors Use the Datasheet Formatting Dialog Box Hide and Unhide Table Fields Add Total Rows Save Changes Pause & Practice: Access 1-3 1.6—Using Search, Sort, and Filter Tools to Find Records in a Table Search Data in a Table Sort Data in a Table with Datasheet View Sort Data on a Single Field Sort Data on Multiple Fields Remove Sorting Criteria Filter Data in a Table with Datasheet View Create a Filter by Selection Create a Text Filter, Number Filter, or Date Filter Create Compound Filter Criteria Remove Filter Criteria Pause & Practice: Access 1-4 Chapter Summary Check for Understanding Using Microsoft Access 365 Guided Project 1-1 Guided Project 1-2 Guided Project 1-3 Independent Project 1-4 Independent Project 1-5 Independent Project 1-6 Improve It Project 1-7 Challenge Project 1-8 Challenge Project 1-9 Challenge Project 1-10 CHAPTER 2: Using Design View, Data Validation, and Relationships Chapter Overview Student Learning Outcomes (SLOs) Case Study 2.1—Creating a Table in Design View Create a New Table in Design View Add New Fields Define a Primary Key Delete Fields in a Table Save, Close, Rename, and Open a Table Property Update Options Smart Tag Switch between Datasheet and Design Views 2.2—Setting Field Properties Set the Field Size The Format Property Number and Currency Field Formats Date/Time Field Formats Yes/No Field Formats Short Text and Long Text Field Formats The Caption Property Set the Default Value The Required Property The New Values Property Pause & Practice: Access 2-1 2.3—Understanding Data Integrity and Data Validation 2.4—Integrating Data Validation in Tables Field Validation Rules Record Validation Rules Test Validation Rules Create Validation Text Create a Lookup Field Define an Input Mask 2.5—Changing Field Properties after Records Are Added into a Table Pause & Practice: Access 2-2 2.6—Understanding and Designing Relational Databases Relational Principles The Steps to Design a Relational Database Three Types of Relationships One-to-One Relationship One-to-Many Relationship Many-to-Many Relationship Understand a Foreign Key Create Relationships between Tables Define a Relationship Using the Relationships Window Enforce Referential Integrity Cascade Updates Cascade Deletes Save a Relationship Delete a Relationship between Tables Edit a Relationship between Tables 2.7—Printing the Contents of a Table Preview the Data Records Print the Data Records without Previewing 2.8—Using the Compact & Repair Database Utility Pause & Practice: Access 2-3 Chapter Summary Check for Understanding Using Microsoft Access 365 Guided Project 2-1 Guided Project 2-2 Guided Project 2-3 Independent Project 2-4 Independent Project 2-5 Independent Project 2-6 Improve It Project 2-7 Challenge Project 2-8 Challenge Project 2-9 Challenge Project 2-10 CHAPTER 3: Creating and Using Queries Chapter Overview Student Learning Outcomes (SLOs) Case Study 3.1—Understanding Queries and Using the Simple Query Wizard 3.2—Creating, Running, and Editing a Query in Design View Create a Query Based on a Single Table Add Fields into a Query Run a Query Switch between Datasheet and Design Views Save and Close a Query Open a Saved Query Rename a Query Create a Query Based on Multiple Tables Edit Fields in Query Design 3.3—Adding a Criterion to a Query Single Criterion Comparison Operators Use Wildcards in Criteria The ? Wildcard Character The * Wildcard Character The Wildcard Character Pause & Practice: Access 3-1 3.4—Controlling the Display of Query Results Unique Values Property Show Option for Query Fields Apply Sorting 3.5—Defining Multiple Criteria in a Query The AND Operator The OR Operator Combine the AND and OR Operators Pause & Practice: Access 3-2 3.6—Creating and Using a Simple Parameter Query Create a Parameter The Parameter Data Type Use Wildcards in a Parameter Query 3.7—Adding Calculated Fields to a Query Enter a Formula in a Calculated Field Troubleshoot Calculated Fields Functions in a Calculated Field Pause & Practice: Access 3-3 3.8—Creating and Using a Summary Query Aggregate Functions Build a Summary Query Pause & Practice: Access 3-4 Chapter Summary Check for Understanding Using Microsoft Access 365 Guided Project 3-1 Guided Project 3-2 Guided Project 3-3 Independent Project 3-4 Independent Project 3-5 Independent Project 3-6 Improve It Project 3-7 Challenge Project 3-8 Challenge Project 3-9 Challenge Project 3-10 CHAPTER 4: Creating and Using Forms and Reports Chapter Overview Student Learning Outcomes (SLOs) Case Study 4.1—Creating and Working with a Simple Form The Form Wizard The Form Button The Split Form View or Modify a Form Save a Form Open a Saved Form Delete a Form Pause & Practice: Access 4-1 4.2—Creating and Customizing a Form in Layout View Create a Form Using the Blank Form Button Form Controls Form Control Layouts Add Fields to a Control Layout Delete Fields from a Control Layout Customize a Form in Layout View Change Control Layouts Adjust Control Widths and Heights Add and Delete Rows and Columns in a Control Layout Move a Control within a Layout Adjust Control Positioning on a Form Add a Title, Date, or Logo to a Form Create a Form from a Template with Application Parts 4.3—Facilitating Data Input with a Form Restrict a Form to Data Entry Limit Edits and Deletions on a Form Add a Command Button Test a Form Pause & Practice: Access 4-2 4.4—Creating and Working with a Simple Report The Report Wizard View or Modify a Report Save a Report Open a Saved Report Delete a Report 4.5—Creating and Customizing a Report in Layout View The Blank Report Button Report Controls Report Control Layouts Add and Delete Fields in a Control Layout Customize a Report in Layout View Change Control Layouts Adjust Column Widths Add and Delete Rows and Columns in a Control Layout Move a Control within a Layout Adjust Control Positioning on a Report Add a Title, Logo, Date, or Page Numbers to a Report Pause & Practice: Access 4-3 4.6—Adding Grouping, Sorting, and Totals Sorting Add a Group to a Report Group and Sort Options Add Totals to a Report 4.7—Using Conditional Formatting in a Report Conditional Formatting Rules Add Conditional Formatting to a Report Manage Conditional Formatting Rules 4.8—Printing a Report Preview a Report Print a Report without Print Preview Format and Print a Report with Multiple Columns Pause & Practice: Access 4-4 Chapter Summary Check for Understanding Using Microsoft Access 365 Guided Project 4-1 Guided Project 4-2 Guided Project 4-3 Independent Project 4-4 Independent Project 4-5 Independent Project 4-6 Improve It Project 4-7 Challenge Project 4-8 Challenge Project 4-9 Challenge Project 4-10 powerpoint CHAPTER 1: Creating and Editing Presentations Chapter Overview Student Learning Outcomes (SLOs) Case Study 1.1—Creating, Opening, and Saving Presentations PowerPoint Start and Open Pages Views Save and Close a Presentation Share and Export Options 1.2—Working with Slides, Layouts, Placeholders, and Text Add Slides and Choose Layouts Enter Text in Placeholders Align, Move, and Resize Placeholders Edit Text Change Text Case Change List Bullet Symbols The Format Painter Reuse Slides from Another Presentation Check Spelling and Word Usage Use PowerPoint Designer with Listed Information Use PowerPoint QuickStarter to Research Content 1.3—Navigating between Slides and Organizing Content Navigate between Slides Copy, Paste, and Duplicate Slides Select Multiple Slides Rearrange Slide Order Delete Slides Pause & Practice: Powerpoint 1-1 1.4—Changing Theme Colors and Fonts Change Theme Colors Change Theme Fonts Use the Slide Master to Change Theme Colors and Fonts 1.5—Inserting Headers and Footers Create a Slide Footer Create a Notes and Handouts Header Pause & Practice: Powerpoint 1-2 1.6—Working with a Picture from a File Insert a Picture and Select a Design Ideas Layout Resize a Picture Align a Picture 1.7—Applying and Modifying Transitions Select Effect Options 1.8—Exploring Print Options Preview a Presentation Print a Slide Print a Handout Print an Outline 1.9—Applying Properties Pause & Practice: Powerpoint 1-3 Chapter Summary Check for Understanding Using Microsoft PowerPoint 365 Guided Project 1-1 Guided Project 1-2 Guided Project 1-3 Independent Project 1-4 Independent Project 1-5 Independent Project 1-6 Improve It Project 1-7 Challenge Project 1-8 Challenge Project 1-9 Challenge Project 1-10 CHAPTER 2: Illustrating with Pictures and Information Graphics Chapter Overview Student Learning Outcomes (SLOs) Case Study 2.1—Working with Shapes, Styles, Effects, and Colors Shapes and Text Boxes Style Galleries and Effect Options Outline Weight and Style Solid and Gradient Colors Custom Colors Color Matching with the Eyedropper Picture, Texture, or Pattern Fills WordArt Styles and Text Effects 2.2—Working with Icons and 3D Models Insert and Format Icons Insert and Adjust 3D Models 2.3—Working with Pictures Apply Picture Styles and Effects Crop a Picture Change Picture Colors Set a Transparent Color Compress Pictures Insert Online Pictures and Illustrations Creative Commons Licensing Pause & Practice: Powerpoint 2-1 2.4—Creating a Table Insert and Draw Methods Move and Select Insert and Delete Rows and Columns Merge and Split Cells Adjust Sizing 2.5—Formatting a Table Table Style Options and Effects Shading and Border Colors Cell Alignment Cell Margins and Text Direction Pause & Practice: Powerpoint 2-2 2.6—Creating a SmartArt Graphic SmartArt Layouts Add Text 2.7—Formatting a SmartArt Graphic SmartArt Styles Change Colors Change Layouts Add Shapes Pause & Practice: Powerpoint 2-3 2.8—Creating a Chart Enter Data and Edit Change Chart Type 2.9—Formatting a Chart Chart Styles and Colors Format Chart Elements Legend and Data Labels Explode a Pie Slice Pause & Practice: Powerpoint 2-4 Chapter Summary Check for Understanding Using Microsoft PowerPoint 365 Guided Project 2-1 Guided Project 2-2 Guided Project 2-3 Independent Project 2-4 Independent Project 2-5 Independent Project 2-6 Improve It Project 2-7 Challenge Project 2-8 Challenge Project 2-9 Challenge Project 2-10 CHAPTER 3: Preparing for Delivery and Using a Slide Presentation Chapter Overview Student Learning Outcomes (SLOs) Case Study 3.1—Creating Custom Theme and Background Colors Custom Theme Colors Custom Background Colors Format a Background with Pattern and Gradient Fills Format a Background with Picture and Texture Fills 3.2—Applying Animation Add Entrance, Exit, and Emphasis Effects Effect Options, Timing, and Duration 3.3—Linking to an Online Video Format an Online Video Play an Online Video Obtain Permission Pause & Practice: Powerpoint 3-1 3.4—Using Rehearsal Techniques Speaker Notes Rehearse Timings Set Timings Manually Prepare for Mishaps 3.5—Controlling Display Options Adjust Slide Size Presenter View Pause & Practice: Powerpoint 3-2 3.6—Presenting Using Projection Equipment Position Equipment Navigate in a Slide Show Control Slide Display Blank Slides Hide and Reveal Slides Use Keyboard Shortcuts Remote Control and Laser Pointer 3.7—Using Annotation Pens Pause & Practice: Powerpoint 3-3 3.8—Preparing a Self-Running Presentation Record a Slide Show with Narration Set Up a Kiosk Presentation with Looping 3.9—Packaging a Presentation for CD or Folder Pause & Practice: Powerpoint 3-4 Chapter Summary Check for Understanding Using Microsoft PowerPoint 365 Guided Project 3-1 Guided Project 3-2 Guided Project 3-3 Independent Project 3-4 Independent Project 3-5 Independent Project 3-6 Improve It Project 3-7 Challenge Project 3-8 Challenge Project 3-9 Challenge Project 3-10 appendices APPENDIX A: Microsoft Office Shortcuts glossary index
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.