{"product_id":"mca-microsoft-office-specialist-office-365-and-office-2019-study-guide-excel-associate-exam-mo-200-paperback-softback-9781119718246","title":"MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide; Excel Associate Exam MO-200 (Paperback \/ softback) 9781119718246","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eMCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eExcel Associate Exam MO-200\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003eEric Butow (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781119718246, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 3 June 2021\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e240 pages\u003cbr\u003e23.1 x 18.5 x 1.5 cm, 0.386 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eMCA Microsoft Office Specialist (Office 365 and Office 2019)\u003c\/b\u003e \u003cb\u003eSTUDY GUIDE\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eYour complete guide to preparing for the Microsoft Office Specialist Excel exam\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe \u003ci\u003eMCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200\u003c\/i\u003e is your one-stop resource for preparing you to earn the Excel Associate certification. The exam measures your competencies in the fundamentals of Excel. This guide starts you off with an assessment test to measure what you already know and what you still need to learn. Then you move into professional scenarios and examples, practical exercises, and challenging chapter review questions. Finally, you can reinforce and retain what you’ve learned with the Sybex online learning environment and test bank. Get prepared for the Excel Associate Exam with Sybex.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCoverage of 100% of all exam objectives in this Study Guide means you’ll be ready to:\u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate and manage worksheets and workbooks\u003c\/li\u003e \u003cli\u003eApply formulas and functions\u003c\/li\u003e \u003cli\u003ePopulate tables with data\u003c\/li\u003e \u003cli\u003eCreate and edit a workbook with multiple sheets\u003c\/li\u003e \u003cli\u003eAdd a graphic element to represent data visually\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eInteractive learning environment\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTake your exam prep to the next level with Sybex’s superior interactive online study tools. To access our learning environment, simply visit \u003cb\u003ewww.wiley.com\/go\/sybextestprep\u003c\/b\u003e, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e\n\u003cb\u003eInteractive test bank\u003c\/b\u003e with a practice exam to help you identify areas where further review is needed. Get more than 90% of the answers correct, and you’re ready to take the certification exam.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003e100 electronic flashcards\u003c\/b\u003e to reinforce learning and last-minute prep before the exam.\u003c\/li\u003e \u003cli\u003e\n\u003cb\u003eComprehensive glossary\u003c\/b\u003e in PDF format gives you instant access to the key terms so you are fully prepared.\u003c\/li\u003e \u003c\/ul\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eIntroduction xv\u003c\/p\u003e \u003cp\u003eAssessment Test xix\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Managing Worksheets and Workbooks 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eImporting Data into Workbooks 2\u003c\/p\u003e \u003cp\u003eBringing in Data from TXT Files 3\u003c\/p\u003e \u003cp\u003eImporting Data from CSV Files 4\u003c\/p\u003e \u003cp\u003eNavigating Within Workbooks 8\u003c\/p\u003e \u003cp\u003eSearching for Data Within a Workbook 8\u003c\/p\u003e \u003cp\u003eNavigating to Named Cells, Ranges, or Workbook Elements 10\u003c\/p\u003e \u003cp\u003eInserting and Removing Hyperlinks 12\u003c\/p\u003e \u003cp\u003eFormatting Worksheets and Workbooks 20\u003c\/p\u003e \u003cp\u003eModifying Page Settings 20\u003c\/p\u003e \u003cp\u003eAdjusting Row Height and Column Width 22\u003c\/p\u003e \u003cp\u003eCustomizing Headers and Footers 30\u003c\/p\u003e \u003cp\u003eCustomizing Options and Views 36\u003c\/p\u003e \u003cp\u003eCustomizing the Quick Access Toolbar 37\u003c\/p\u003e \u003cp\u003eDisplaying and Modifying Workbook Content in Different Views 41\u003c\/p\u003e \u003cp\u003eFreezing Worksheet Rows and Columns 44\u003c\/p\u003e \u003cp\u003eChanging Window Views 46\u003c\/p\u003e \u003cp\u003eModifying Basic Workbook Properties 48\u003c\/p\u003e \u003cp\u003eDisplaying Formulas 49\u003c\/p\u003e \u003cp\u003eConfiguring Content for Collaboration 52\u003c\/p\u003e \u003cp\u003eSetting a Print Area 52\u003c\/p\u003e \u003cp\u003eSaving Workbooks in Other File Formats 54\u003c\/p\u003e \u003cp\u003eConfiguring Print Settings 54\u003c\/p\u003e \u003cp\u003eInspecting Workbooks for Issues 55\u003c\/p\u003e \u003cp\u003eSummary 59\u003c\/p\u003e \u003cp\u003eKey Terms 59\u003c\/p\u003e \u003cp\u003eExam Essentials 59\u003c\/p\u003e \u003cp\u003eReview Questions 61\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Using Data Cells and Ranges 63\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManipulating Data in Worksheets 64\u003c\/p\u003e \u003cp\u003ePasting Data by Using Special Paste Options 64\u003c\/p\u003e \u003cp\u003eFilling Cells by Using Auto Filling 68\u003c\/p\u003e \u003cp\u003eInserting and Deleting Multiple Columns or Rows 70\u003c\/p\u003e \u003cp\u003eAdding and Removing Cells 72\u003c\/p\u003e \u003cp\u003eFormatting Cells and Ranges 75\u003c\/p\u003e \u003cp\u003eMerging and Unmerging Cells 75\u003c\/p\u003e \u003cp\u003eModifying Cell Alignment, Orientation, and Indentation 76\u003c\/p\u003e \u003cp\u003eFormatting Cells by Using Format Painter 79\u003c\/p\u003e \u003cp\u003eWrapping Text Within Cells 80\u003c\/p\u003e \u003cp\u003eUsing Number Formatting 82\u003c\/p\u003e \u003cp\u003eApplying Cell Formatting from the Format Cells Dialog Box 83\u003c\/p\u003e \u003cp\u003eWorking with Cell Styles 84\u003c\/p\u003e \u003cp\u003eClearing Cell Formatting 86\u003c\/p\u003e \u003cp\u003eDefining and Referencing Named Ranges 88\u003c\/p\u003e \u003cp\u003eDefining a Named Range 88\u003c\/p\u003e \u003cp\u003eNaming a Table 93\u003c\/p\u003e \u003cp\u003eSummarizing Data Visually 95\u003c\/p\u003e \u003cp\u003eInserting Sparklines 95\u003c\/p\u003e \u003cp\u003eApplying Built-In Conditional Formatting 99\u003c\/p\u003e \u003cp\u003eRemoving Conditional Formatting 101\u003c\/p\u003e \u003cp\u003eSummary 105\u003c\/p\u003e \u003cp\u003eKey Terms 105\u003c\/p\u003e \u003cp\u003eExam Essentials 105\u003c\/p\u003e \u003cp\u003eReview Questions 107\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Working with Tables and Table Data 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating and Formatting Tables 110\u003c\/p\u003e \u003cp\u003eCreating Excel Tables from Cell Ranges 110\u003c\/p\u003e \u003cp\u003eApplying Table Styles 112\u003c\/p\u003e \u003cp\u003eConverting Tables to Cell Ranges 113\u003c\/p\u003e \u003cp\u003eModifying Tables 115\u003c\/p\u003e \u003cp\u003eAdding or Remove Table Rows and Columns 115\u003c\/p\u003e \u003cp\u003eConfiguring Table Style Options 118\u003c\/p\u003e \u003cp\u003eInserting and Configuring Total Rows 119\u003c\/p\u003e \u003cp\u003eFiltering and Sorting Table Data 122\u003c\/p\u003e \u003cp\u003eFiltering Records 122\u003c\/p\u003e \u003cp\u003eSorting Data by Multiple Columns 126\u003c\/p\u003e \u003cp\u003eSummary 128\u003c\/p\u003e \u003cp\u003eKey Terms 129\u003c\/p\u003e \u003cp\u003eExam Essentials 129\u003c\/p\u003e \u003cp\u003eReview Questions 130\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Performing Operations by Using Formulas and Functions 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eInserting References 134\u003c\/p\u003e \u003cp\u003eInserting Relative, Absolute, and Mixed References 135\u003c\/p\u003e \u003cp\u003eReferencing Named Ranges and Named Tables in Formulas 137\u003c\/p\u003e \u003cp\u003eCalculating and Transforming Datas 140\u003c\/p\u003e \u003cp\u003ePerforming Calculations Using the AVERAGE(), MAX(),  MIN(), and SUM() Functions 140\u003c\/p\u003e \u003cp\u003ePerform Conditional Operations by Using the IF() Function 151\u003c\/p\u003e \u003cp\u003eFormatting and Modifying Text 155\u003c\/p\u003e \u003cp\u003eFormatting Text Using the RIGHT(), LEFT(), and MID() Functions 155\u003c\/p\u003e \u003cp\u003eFormatting Text Using the UPPER(), LOWER(), and LEN() Functions 159\u003c\/p\u003e \u003cp\u003eFormatting Text Using the CONCAT() and TEXTJOIN() Functions 163\u003c\/p\u003e \u003cp\u003eSummary 166\u003c\/p\u003e \u003cp\u003eKey Terms 167\u003c\/p\u003e \u003cp\u003eExam Essentials 167\u003c\/p\u003e \u003cp\u003eReview Questions 168\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Managing Charts 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Charts 172\u003c\/p\u003e \u003cp\u003eBuilding Charts 172\u003c\/p\u003e \u003cp\u003eWorking with Chart Sheets 174\u003c\/p\u003e \u003cp\u003eModifying Charts 178\u003c\/p\u003e \u003cp\u003eAdding Data Series to Charts 178\u003c\/p\u003e \u003cp\u003eSwitching Between Rows and Columns in Source Data 181\u003c\/p\u003e \u003cp\u003eAdding and Modifying Chart Elements 182\u003c\/p\u003e \u003cp\u003eFormatting Charts 185\u003c\/p\u003e \u003cp\u003eUsing Chart Layouts 186\u003c\/p\u003e \u003cp\u003eApplying Chart Styles 194\u003c\/p\u003e \u003cp\u003eAdding Alternative Text to Charts for Accessibility 196\u003c\/p\u003e \u003cp\u003eSummary 198\u003c\/p\u003e \u003cp\u003eKey Terms 198\u003c\/p\u003e \u003cp\u003eExam Essentials 199\u003c\/p\u003e \u003cp\u003eReview Questions 200\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix: Answers to Review Questions 203\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Managing Worksheets and Workbooks 204\u003c\/p\u003e \u003cp\u003eChapter 2: Using Data Cells and Ranges 204\u003c\/p\u003e \u003cp\u003eChapter 3: Working with Tables and Table Data 205\u003c\/p\u003e \u003cp\u003eChapter 4: Performing Operations by Using Formulas and Functions 206\u003c\/p\u003e \u003cp\u003eChapter 5: Managing Charts 206\u003c\/p\u003e \u003cp\u003eIndex 209\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business applications [\u003ca title=\"See our other books on Business applications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20applications%20%5BUF%5D%22\"\u003eUF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Sybex","offers":[{"title":"Brand New","offer_id":52501180350744,"sku":"9781119718246","price":13.69,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781119718246.jpg?v=1786215435","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/mca-microsoft-office-specialist-office-365-and-office-2019-study-guide-excel-associate-exam-mo-200-paperback-softback-9781119718246","provider":"Freshly Printed Books","version":"1.0","type":"link"}