100+ Free MO-200 Practice Questions

Manage worksheets and workbooks

Import data from text and CSV files; navigate workbooks using named ranges, Go To and hyperlinks; format worksheets and workbooks including page setup, headers and footers, and row and column visibility; customize options and views such as freeze panes, custom views, gridlines and zoom; and configure content for collaboration and printing by setting print areas, saving alternative file formats, configuring print settings and inspecting workbooks for issues.

Manage data cells and ranges

Manipulate data with paste special and Auto Fill; insert and delete cells, columns and rows; format cells and ranges by merging and unmerging, adjusting alignment, orientation and indentation, using Format Painter, wrapping text, applying number formats and cell styles, and clearing formats; apply conditional formatting; and define named ranges.

Manage tables and table data

Convert cell ranges to Excel tables and back to ranges; apply table styles; configure table style options such as header row, total row and banded rows; add and remove table rows and columns; and filter and sort table data.

Perform operations by using formulas and functions

Use relative, absolute and mixed cell references; reference named ranges and named tables in formulas; calculate and transform data with AVERAGE, MAX, MIN, SUM, COUNT, COUNTA, COUNTBLANK and IF; and format and modify text with RIGHT, LEFT, MID, UPPER, LOWER, LEN, CONCAT and TEXTJOIN.

Manage charts

Create charts and chart sheets; add new data series to a chart; switch between rows and columns in source data; add and modify chart elements such as titles, legends, data labels and axes; apply chart layouts and styles; and add alternative text to charts for accessibility.