Microsoft Word Exam MO-100 1st edition by Joan Lambert – Ebook PDF Instant Download/Delivery: 0136627390, 9780136627395
Full download Microsoft Word Exam MO-100 1st edition after payment
Product details:
ISBN 10: 0136627390
ISBN 13: 9780136627395
Author: Joan Lambert
Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.
Microsoft Word Exam MO-100 1st Table of contents:
Objective Group 1: Manage Worksheets and Workbooks
-
Objective 1.1: Import Data into Workbooks
Importing data from external sources like CSV files, databases, or web data. -
Objective 1.2: Navigate within Workbooks
Using Excel’s tools to move around within a workbook efficiently, including keyboard shortcuts and the Go To feature. -
Objective 1.3: Format Worksheets and Workbooks
Formatting cells, rows, columns, and applying themes or styles to make data easy to read and presentable. -
Objective 1.4: Customize Options and Views
Setting up Excel options for user preferences and customizing views like Split View or Freeze Panes for better navigation. -
Objective 1.5: Configure Content for Collaboration
Sharing workbooks, protecting content, and managing comments or notes for collaborative efforts.
Objective Group 2: Manage Data Cells and Ranges
-
Objective 2.1: Manipulate Data in Worksheets
Adding, deleting, and editing data within cells and ranges. This could include sorting, inserting, or moving data. -
Objective 2.2: Format Cells and Ranges
Using formatting options such as number formatting, alignment, font settings, borders, and colors to enhance data visibility. -
Objective 2.3: Define and Reference Named Ranges
Creating named ranges to make formulas easier to read and manage by using meaningful names for specific data ranges. -
Objective 2.4: Summarize Data Visually
Using summary tools like subtotals, grouping, and PivotTables to analyze and display data in a more understandable way.
Objective Group 3: Manage Tables and Table Data
-
Objective 3.1: Create and Format Tables
Converting ranges to tables and applying table styles for better organization and presentation of data. -
Objective 3.2: Modify Tables
Editing table data, adding or removing columns/rows, and working with structured references. -
Objective 3.3: Filter and Sort Table Data
Using table tools to sort data in ascending or descending order and applying filters for easier data analysis.
Objective Group 4: Perform Operations Using Formulas and Functions
-
Objective 4.1: Insert References in Formulas
Using cell references (relative, absolute, and mixed) in formulas to refer to data within the workbook. -
Objective 4.2: Calculate and Transform Data Using Functions
Utilizing built-in functions (e.g., SUM, AVERAGE, IF) to calculate or transform data based on specific conditions. -
Objective 4.3: Format and Modify Text Using Functions
Using text functions like CONCATENATE, LEFT, RIGHT, and TEXT to manipulate and format text in cells.
Objective Group 5: Manage Charts
-
Objective 5.1: Create Charts
Creating various types of charts (e.g., bar, line, pie) to visualize data in a meaningful way. -
Objective 5.2: Modify Charts
Changing chart elements like titles, axes, or series, and resizing or moving charts for better presentation. -
Objective 5.3: Format Charts
Formatting charts with colors, styles, and labels to make the data more comprehensible and visually appealing.
People also search for Microsoft Word Exam MO-100 1st:
exam mo 100 microsoft word office 2019
microsoft word exam questions and answers
100 words in word
how to get word count microsoft word
exam mo-100 microsoft word (word and word 2019)
Tags:
Joan Lambert,Microsoft Word,Exam MO