MCA Microsoft Office Specialist Word Study Guide: Exam Mo-100, Butow Eric

Your complete guide to preparing for the Microsoft Office Specialist Excel exam

The MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200 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.

Coverage of 100% of all exam objectives in this Study Guide means you'll be ready to:

• Create and manage worksheets and workbooks
• Apply formulas and functions
• Populate tables with data
• Create and edit a workbook with multiple sheets
• Add a graphic element to represent data visually

Interactive learning environment

Take your exam prep to the next level with Sybex's superior interactive online study tools. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:

• Interactive test bank 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.
• 100 electronic flashcards to reinforce learning and last-minute prep before the exam.
• Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared.

MCA Microsoft 365 Azure Administrator Study Guide Exam AZ-104 prepares readers to take the AZ-104 Exam and to fully understand the role of a Microsoft 365 Azure Administrator. The book takes a practical and straightforward approach to Microsoft Azure, ensuring that you understand both the realities of working as an Administrator and the techniques and skills necessary to succeed on the AZ-104 Exam.

In addition to providing you with access to the online Sybex test bank that includes hundreds of practice questions, flashcards, and a glossary of terms, the study guide comprehensively explains all the following topics:

How to manage Azure subscriptions and resources Implementing and managing storage Deploying and managing virtual machines Managing and configuring virtual networks How to Manage identities

Perfect for anyone considering a career as a Microsoft Azure Administrator or preparing for the AZ-104 Exam, MCA Microsoft 365 Azure Administrator Study Guide: Exam AZ-104 also belongs on the bookshelves of practicing administrators who wish to brush up on the fundamentals of their profession.

Microsoft's Modern Desktop integrates Windows 10, Office 365, and advanced security capabilities. Microsoft 365 Certified Associate (MCA) Modern Desktop certification candidates need to be familiar with Microsoft 365 workloads and demonstrate proficiency in deploying, configuring, and maintaining Windows 10 and non-Windows devices and technologies. The new Exam MD-101: Managing Modern Desktops measures candidate's ability to deploy and update operating systems, manage policies and profiles, manage and protect devices, and manage apps and data. Candidates are required to know how to perform a range of tasks to pass the exam and earn certification.

The MCA Modern Desktop Administrator Study Guide: Exam MD-101 provides in-depth examination of the complexities of Microsoft 365. Focusing on the job role of IT administrators, this clear, authoritative guide covers 100% of the new exam objectives. Real-world examples, detailed explanations, practical exercises, and challenging review questions help readers fully prepare for the exam. Sybex's comprehensive online learning environment--in which candidates can access an assessment test, electronic flash cards, a searchable glossary, and bonus practice exams--is included to provide comprehensive exam preparation. Topics include:

• Planning and implementing Windows 10 using dynamic deployment and Windows Autopilot
• Upgrading devices to Windows 10 and managing updates and device authentication
• Managing access polices, compliance policies, and device and user profiles
• Implementing and managing Windows Defender and Intune device enrollment
• Deploying and updating applications and implementing Mobile Application Management (MAM)

The move to Windows 10 has greatly increased the demand for qualified and certified desktop administrators in corporate and enterprise settings. MCA Modern Desktop Administrator Study Guide: Exam MD-101: Managing Modern Desktops is an invaluable resource for IT professionals seeking MCA certification.

Quick, focused review for MD-100 and MD-101

Microsoft's new Certified Associate Modern Desktop qualification verifies your skill as an administrator of Windows 10 technologies and modern desktop management. With a focus on the intricacies of Microsoft 365, this certification is in high demand. The 2 practice exams PLUS domain-by-domain questions in this book will help you target your study and sharpen your focus--1000 questions total So now tackle the certification exam with confidence. Expertly crafted questions cover 100% of the objectives for both the MD-100 and MD-101 exams, enabling you to be fully prepared.

Coverage of 100% of all exam objectives in these practice tests means you'll be ready for:

• Desktop and Device Deployment
• Windows Management and Monitoring
• OS Updates and Upgrades
• Core Services Support
• Data Access and Usage
• Networking Security
• Driver and Device Installation
• Remote Access Configuration
• System Backup and Restore

Interactive learning environment

Take your exam prep to the next level with Sybex's superior interactive online study tools. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register to receive your unique PIN, and instantly gain one year of FREE access to the interactive test bank with two practice exams and domain-by-domain questions. 1000 questions total

• Interactive test bank Use the interactive online version of the book's 2 practice exams 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. 100 questions total

ABOUT THE MCA PROGRAM

Microsoft's Modern Desktop integrates Windows 10, Office 365, and advanced security capabilities. Microsoft 365 Certified Associate (MCA) Modern Desktop certification candidates need to be familiar with Microsoft 365 workloads and demonstrate proficiency in deploying, configuring, and maintaining Windows 10 and non-Windows devices and technologies. The new Exam MD-101: Managing Modern Desktops measures candidate's ability to deploy and update operating systems, manage policies and profiles, manage and protect devices, and manage apps and data. Candidates are required to know how to perform a range of tasks to pass the exam and earn certification.

The MCA Modern Desktop Administrator Study Guide: Exam MD-101 provides in-depth examination of the complexities of Microsoft 365. Focusing on the job role of IT administrators, this clear, authoritative guide covers 100% of the new exam objectives. Real-world examples, detailed explanations, practical exercises, and challenging review questions help readers fully prepare for the exam. Sybex's comprehensive online learning environment--in which candidates can access an assessment test, electronic flash cards, a searchable glossary, and bonus practice exams--is included to provide comprehensive exam preparation. Topics include:

• Planning and implementing Windows 10 using dynamic deployment and Windows Autopilot
• Upgrading devices to Windows 10 and managing updates and device authentication
• Managing access polices, compliance policies, and device and user profiles
• Implementing and managing Windows Defender and Intune device enrollment
• Deploying and updating applications and implementing Mobile Application Management (MAM)

The move to Windows 10 has greatly increased the demand for qualified and certified desktop administrators in corporate and enterprise settings. MCA Modern Desktop Administrator Study Guide: Exam MD-101: Managing Modern Desktops is an invaluable resource for IT professionals seeking MCA certification.

And with this edition you also get Practice Labs virtual labs that run from your browser. The registration code is included with the book and gives you 6 months unlimited access to Practice Labs Exam MD-101: Managing Modern Desktops Labs with 29 unique lab modules to practice your skills.

NOTE: The title requires an active Microsoft 365 subscription. This subscription will be needed to complete specific tasks in the labs. A free 30-day trial account can be created at the Microsoft 365 website.