Excel Associate Exam Format

Download Presentation File

Download Workshop Files

Excel Associate Exam MO-200 Skills Measured

Import data from .txt files

Import data from .csv files

Search for data within a workbook

Navigate to named cells, ranges, or workbook elements

Insert and remove hyperlinks

Modify page setup

Adjust row height and column width

Customize headers and footers

Customize the Quick Access toolbar

Customize Options and Views

Modify basic workbook properties

Inspect and Save in alternative file format

Configure print Setting and set a print area

Paste data by using special paste options

Fill cells by using Auto Fill

Insert and delete multiple columns or rows

Format cells and ranges

Define and reference named ranges

Insert Sparklines

Apply Conditional Formatting

Manage tables and table data

Reference named ranges and named tables in formulas

Formula using relative and absolute references

Perform Calculations using AVERAGE() MAX() MIN() SUM() COUNT() Functions

Perform conditional operations by using IF statement

Split text using LEFT() MID() RIGHT() CONCAT() TEXTJOIN() Functions

Format text by using UPPER(), LOWER(), and PROPER() functions

Clean text using TRIM() LEN() Functions

Create charts and chart sheets

Modify charts

Format charts and Trendline

Practice Test Instructions

Download Practice Test files

Practice Test Solution

Course Evaluation تقييم الدورة

Congrats! Conclusion