Assessment: Excel Basic
Excel is used by a wide range of professions for the analysis of numerical data, making the professionals who use it invaluable in today’s job market.
By successful completion of this assessment, the candidates demonstrate that they are competent in organizing and analyzing data using Excel.
In practice the successful candidates should be able to create professional looking financial statements and budgets with charts and enter and manipulate data in a workbook.
To pass this assessment, candidates need to have the skills required to create, format and manage workbooks, worksheets, cells, cells ranges and tables.
The assessment syllabus also covers standard formulas and functions and data visualization with the use of graphical elements and charts.
- Manage Worksheets and Workbooks
(Sheet headers, sheet movement, manage rows and columns, manage sheet views and printings) - Manage Data Cells and Ranges
(Formatting and conditional formatting, cell naming, find and replace) - Tables – Sorting and Filtering
- Formulas and Functions
(SUM, AVERAGE, COUNT, PROPER, UPPER, LOWER) - Charts
(Create, delete and modify charts)
TEST4U Desktop version
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office: Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft Office 2024, Microsoft 365.
TEST4U Cloud version
This assessment can also be taken online, in the browser, with nothing to install. The TEST4U Cloud version tests the same skills. Online assessments are available in English and Greek.




