Assessment: Administrative Staff
IT Skills assessment for Executives, Administrative support staff, Human Resources managers
Administrative managers in an organization are the ones who take care of the smooth operation on a daily basis. In order to complete their tasks, apart from their special talents, a series of skills for handling office applications is necessary. These skills are a common denominator regardless of specialization of the manager.
It is not uncommon that these executives form the entire department by themselves, or they are part of an entire team of specialized executives that run the organization.
The day-to-day responsibilities of the people holding these positions involve:
- Handling documents (e.g. for preparing reports, letters, contracts)
- Email and calendar management
- Using spreadsheets (e.g. for the preparation of financial data, expenses, consolidated data)
- Preparing presentations (as supporting material to other executives, clients, etc.)
- Typing a large amount of data
- Writing reports and analyzing data
- Supervising and controlling the work of associates / subordinates
- Maintaining communication between departments
- Presenting ideas / strategies
- Preparing reports, brochures, training files, etc.
- Preparing interviews
In order to perform their duties properly, these executives must have a profound knowledge of how to operate various applications so as to produce the desired result.
Job positions with similar typical skills
Jobs with similar formal qualifications include: Executives of various levels, Administrative Assistants, Secretariats, Law Office Secretaries, After Sales / Back-office clerks, Department / Branch Managers, Area Managers, Assistant Directors, consultants, Human Resources Executives, office workers, etc.
What does TEST4U recommend?
These jobs require a very good level of skills in operating a variety of office applications. For a clearer result and a better picture, we suggest the assessing the candidates’ skills in the applications:
- Formatting
(Styles, paragraph settings, wrapping style, picture layout) - Referencing and Columns
(Columns, table of contents, bookmarks, captions) - Enhancing Productivity
(Text to table, table to text, table formulas, sections, macros, mail merging) - Collaborative Editing and Fields
(Insert and modify fields, track changes, document protection)
- Mail Creation
- Mail Organizing
- Outlook Settings and Printing
- Calendar
- Contacts
- Mail Management
- 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)
- Manage Slides
(Views, themes, layout, printing, slide transitions) - Manage and Format Text
(Alignment, fonts, hyperlinks, dates, textbox, footer) - Tables and Charts
(Insert and format tables, charts and SmartArt) - Graphical Objects
(Grouping, alignment, formatting and copying of graphical objects)
Suggested:
Combine the skills assessment in applications with the touch-typing speed assessment
The assessment uses Microsoft Office 2019
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 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.