Required skills when taking the MOS Excel exam

MOS Excel is a certification that certifies you as an expert in the skills of using Microsoft Excel. This is one of the certifications about the ability to use Microsoft Office 2019, 2016, 2013 and 365 tools. So what's in an Excel MOS exam, what skills will you need to prepare before the exam. Let TipsMake.com find out details through this article.

Structure of the MOS Excel exam

In the MOS Excel exam 2019, 2016, 2013 and 365, there will be 5 main contents. In which the content of each part as well as the percentage of scores of the sections are as follows:

1. Manage worksheets and workbooks – Manage worksheets and workbooks: 10-15%
2. Manage data cells and ranges
3. Manage tables and table data – Manage tables and data tables: 10-15%
4. Perform operations by using formulas and functions – Perform operations using formulas and functions: 20-25%
5. Manage charts – Manage charts: 20-25%

Summary of skills required to take the MOS Excel exam

As mentioned above, you will need 5 key skills to be able to complete the MOS Excel exam. Within each of these skills, there are small skills that you need to master to complete the test. As follows:

Manage worksheets and workbooks – Manage worksheets and workbooks

Import data into workbooks – Import data into Workbooks

1. Import data from a .txt file.
2. Import data from a .csv file.

Navigate within workbooks – Navigate inside workbooks

1. Find data inside a workbook.
2. Navigate to cell names, ranges, or numerical factors.
3. Insert and remove links.

Format worksheets and workbooks – Format worksheets and workbooks

1. Edit page settings.
2. Adjust row height and column width.
3. Customize headers and footers.

Customize options and views – Customize options and views

1. Customize the quick access toolbar.
2. Display and edit workbook contents with different views.
3. Freeze rows and columns in a spreadsheet.
4. Change the window mode, edit basic properties of the spreadsheet.
5. Display function formulas.

Configure content for collaboration

1. Set the print area.
2. Save numbers with multiple format versions.
3. Configure print settings.
4. Check the workbook at some issue.

Manage data cells and ranges

Manipulate data in worksheets – Manipulate data and spreadsheets

1. Paste data using many special options.
2. Fill multiple cells using autofill.
3. Insert and delete multiple columns and multiple rows.
4. Insert and delete multiple cells.

Format cells and ranges – Formats multiple cells and ranges

1. Merge and unmerge multiple cells.
2. Edit cell alignment, page orientation, and indentation, multi-cell formatting.
3. Using the copy formatting tool, break lines in cells.
4. Apply number formatting, apply cell formatting from the format cells dialog box.
5. Apply cell style, clear cell formatting.

Define and reference named ranges

1. Define a namespace, name a table.

Summarize data seemingly – Summarize data visually

1. Insert sparkline.
2. Apply predefined conditional formatting.
3. Remove conditional formatting.

Manage tables and table data – Manage tables and data tables

Create and format tables – Create and format tables

1. Create new excel sheet from cell range.
2. Apply the style of the table.
3. Convert table to cell range.
4. Edit a table, add or remove table rows and columns.
5. Option to configure the table's style.
6. Insert and configure the total line.

Filter and sort table data – Filter and sort table data

1. Filter records, sort by multiple columns.

Perform operations by using formulas and functions – Perform operations using formulas and functions

Insert references – Insert references

1. Insert relative, absolute, and mixed references.
2. Referencing the namespace and the name of the table in the formula.

Calculate and transform datas – Calculate and transform data

1. Perform calculations using the AVERAGE(), MAX(), MIN() and SUM() functions.
2. Count cells using the COUNT(), COUNTA(), and COUNTBANK() functions.
3. Perform calculations using the IF() function.

Format and modify text – Format and modify text

1. Format text using functions: RIGHT(), LEFT(), MID().
2. Format text using the UPPER(), LOWER(), and LEN() functions.
3. Format text using the CONCAT() and TEXTJOIN() functions.

Manage charts – Manage charts

Create charts – Create charts

1. Create charts, create chart spreadsheets.
2. Edit chart.
3. Add a data series to the chart.

Switch between rows and columns in source data – Switch between rows and columns in source data

1. Add and edit chart elements.

Format charts – Format charts

1. Apply chart views, apply chart styles, add alternate assets to the chart.

Hopefully, through the content of this article, readers have been able to better understand MOS Excel as well as how to achieve the highest score in the exam.

Isabella Humphrey

Update 17 February 2023