How does this test work?
The Spreadsheets with Microsoft Excel module measures your ability to navigate and modify an Excel workbook, visualize trends and patterns using conditional formats and standard charts, analyze data, and create reports using PivotTables and PivotCharts. Your performance on this module demonstrates your skill in Spreadsheets with Microsoft Excel by sorting and filtering options as well as statistical functions; customizing the look and feel of a workbook using cell formatting tools; writing cell formulas to evaluate conditional statements; combining data from multiple worksheets; manipulating fields formatted as dates, values, or text; and nesting multiple functions together to create dynamic formulas.
How long does this take?
This process should only take about 8 minutes.