# MS Excel (Office 365) (with PivotTables) Assessment

## Description
The MS Excel (Office 365) (with PivotTables) assessment is a skills and knowledge test designed to evaluate the proficiency of job candidates and employees in using Microsoft Excel within the Office 365 environment, including the use of PivotTables. It is intended for use in pre-hire selection, employee development, and promotion selection decisions, making it a versatile tool for assessing software skills across various stages of the employment lifecycle. The assessment covers a broad range of MS Excel competencies, including creating and managing files, applying formulas and arithmetic, using VLOOKUP, formatting cells, sorting and searching data, creating 2D charts, collaborating and sharing files, working with worksheets, and viewing and recording macros, among others. PivotTable coverage focuses on foundational topics such as PivotTable Basics and Fields.

The test is delivered using multiple choice and multiple correct answer questions, providing a thorough evaluation of practical Excel knowledge. Questions are drawn from a large pool to minimize the risk of cheating and ensure assessment integrity, and one or more questions include time limits to further deter dishonesty and enhance the predictive validity of results.

## Competencies Measures
- MS Excel
- PivotTables

## Metadata
- **Duration:** 15.0 Minutes
- **Language:** English (US)
- **Type:** Skills/Knowledge Assessment (Test)
- **Last Updated:** September 12, 2026

## Catalog Link
View additional details or to administer the assessment to a candidate here:
[View in Online Test Catalog](https://www.hravatar.com/ta/tests/5278/ms-excel-office-365-with-pivottables.html)