MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide

ERIC BUTOW has developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. Eric has also been a professional technical writer and started using Word, Excel, and PowerPoint professionally in 1994. He is the owner of Butow Communications Group (https://www.butow.net). BCG offers website development, online marketing, and technical writing services.

Select Guide Rating

• Introduction xvAssessment Test xixChapter 1 Managing Worksheets and Workbooks 1Importing Data into Workbooks 2Bringing in Data from TXT Files 3Importing Data from CSV Files 4Navigating Within Workbooks 8Searching for Data Within a Workbook 8Navigating to Named Cells, Ranges, or Workbook Elements 10Inserting and Removing Hyperlinks 12Formatting Worksheets and Workbooks 20Modifying Page Settings 20Adjusting Row Height and Column Width 22Customizing Headers and Footers 30Customizing Options and Views 36Customizing the Quick Access Toolbar 37Displaying and Modifying Workbook Content in Different Views 41Freezing Worksheet Rows and Columns 44Changing Window Views 46Modifying Basic Workbook Properties 48Displaying Formulas 49Configuring Content for Collaboration 52Setting a Print Area 52Saving Workbooks in Other File Formats 54Configuring Print Settings 54Inspecting Workbooks for Issues 55Summary 59Key Terms 59Exam Essentials 59Review Questions 61Chapter 2 Using Data Cells and Ranges 63Manipulating Data in Worksheets 64Pasting Data by Using Special Paste Options 64Filling Cells by Using Auto Filling 68Inserting and Deleting Multiple Columns or Rows 70Adding and Removing Cells 72Formatting Cells and Ranges 75Merging and Unmerging Cells 75Modifying Cell Alignment, Orientation, and Indentation 76Formatting Cells by Using Format Painter 79Wrapping Text Within Cells 80Using Number Formatting 82Applying Cell Formatting from the Format Cells Dialog Box 83Working with Cell Styles 84Clearing Cell Formatting 86Defining and Referencing Named Ranges 88Defining a Named Range 88Naming a Table 93Summarizing Data Visually 95Inserting Sparklines 95Applying Built-In Conditional Formatting 99Removing Conditional Formatting 101Summary 105Key Terms 105Exam Essentials 105Review Questions 107Chapter 3 Working with Tables and Table Data 109Creating and Formatting Tables 110Creating Excel Tables from Cell Ranges 110Applying Table Styles 112Converting Tables to Cell Ranges 113Modifying Tables 115Adding or Remove Table Rows and Columns 115Configuring Table Style Options 118Inserting and Configuring Total Rows 119Filtering and Sorting Table Data 122Filtering Records 122Sorting Data by Multiple Columns 126Summary 128Key Terms 129Exam Essentials 129Review Questions 130Chapter 4 Performing Operations by Using Formulas and Functions 133Inserting References 134Inserting Relative, Absolute, and Mixed References 135Referencing Named Ranges and Named Tables in Formulas 137Calculating and Transforming Datas 140Performing Calculations Using the AVERAGE(), MAX(),  MIN(), and SUM() Functions 140Perform Conditional Operations by Using the IF() Function 151Formatting and Modifying Text 155Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 155Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 159Formatting Text Using the CONCAT() and TEXTJOIN() Functions 163Summary 166Key Terms 167Exam Essentials 167Review Questions 168Chapter 5 Managing Charts 171Creating Charts 172Building Charts 172Working with Chart Sheets 174Modifying Charts 178Adding Data Series to Charts 178Switching Between Rows and Columns in Source Data 181Adding and Modifying Chart Elements 182Formatting Charts 185Using Chart Layouts 186Applying Chart Styles 194Adding Alternative Text to Charts for Accessibility 196Summary 198Key Terms 198Exam Essentials 199Review Questions 200Appendix: Answers to Review Questions 203Chapter 1: Managing Worksheets and Workbooks 204Chapter 2: Using Data Cells and Ranges 204Chapter 3: Working with Tables and Table Data 205Chapter 4: Performing Operations by Using Formulas and Functions 206Chapter 5: Managing Charts 206Index 209