1. Home Page 
  2. /
  3. e-tests 
  4. / TEST4U Microsoft Excel Expert 365, 2019, 2016, 2013, 2010, 2007, 2003 - English version

TEST4U Microsoft Excel Expert

365, 2019, 2016, 2013, 2010, 2007, 2003

English version

Last updated: 14 May 2020
Rely on TEST4U because it offers:
  • Variety - 194 exercises for MS Excel Expert
  • Help - 193 incorporated Video Solutions?, a unique one for each Question
  • Training Hours - Purchase hours for practice according to your individual needs
  • Unlimited Tests - No limit to the times a question runs, unlike competitive software
  • Classification - Distinct subcategories ?
  • Feedback - Immediate evaluation of answers ?
  • Plenitude - It covers 100% the certification syllabus
  • Adequacy - Same environment as the exams’
  • Flexibility - Practice on any Computer
  • Updates - Access to updated version
  • More than 700.000 candidates have trusted TEST4U since 2003


Available languages: Greek, English.

For individuals

Master Microsoft Excel.

Upgrade your knowledge and skills to the latest 2016 version to boost your career.

Let TEST4U guide you from the convenience of your home, and you will become an expert in no time!

TEST4U Microsoft Excel Expert 365, 2019, 2016, 2013, 2010, 2007, 2003 English version

For Enterprises

If your job is about computer training, then you stand just one step away from providing the best possible services! TEST4U, the most popular application for learning office software assists educational institutions, enterprises and the public sector. If your job is about Computer Education, then TEST4U will provide you with extra tools and guarantee the result.

TEST4U Microsoft Excel Expert 365, 2019, 2016, 2013, 2010, 2007, 2003 English version
More than 700.000 Candidates have trusted TEST4U for their Training since 2003.
This is what they say:

What does TEST4U offer?

TEST4U Excel Expert Test is an interactive, highly customizable tool that will satisfy your personal training goals. During the media-rich TEST4U experience, you will broaden your understanding of MS Excel, the most famous and flexible spreadsheet software, part of Microsoft Office Suite, at an Expert level.


TEST4U Excel Expert Test will help you improve your skills because it contains:
  • 193 Live in ates Questions
  • DIPLOMA level Questions, available for practice on actual working environment conditions.
TEST4U Microsoft Excel Expert 365, 2019, 2016, 2013, 2010, 2007, 2003 English version


TEST4U Excel Expert Test is not just another e-lesson with a few multiple choice questions, TEST4U makes the difference! The questions it contains require a series of moves to be made. For each question, you are asked to take some actions, which TEST4U will evaluate.

This is how TEST4U mimics the actual working conditions: You can’t make educated guesses! In order to answer correctly, you must know which buttons to use.

If your knowledge of a topic is limited, you can watch our video-solutions which guide you step-by-step.

In case you feel that your MS Excel skill level is not sufficient, we propose that, prior to practicing at TEST4U, you should watch our online video-lessons (e-courses).

MS-Excel TEST4U Expert Module covers topics such as learning how to use charts, Sortings, Filters, Macros, Template and goes deep down into formulas and special functions. By successfully completing our MS-Excel Expert TEST4U Module you will be able to operate Microsoft Excel professionally and upgrade your skills to the latest 2016 version.

Our team of experts has incorporated the years of classroom training experience and teaching techniques into TEST4U. As a result, TEST4U Excel Expert Test contains exercises adjusted to the certification examinations of various Certification Bodies (e.g. DIPLOMA, E.C.D.L.-I.C.D.L., Microsoft Certiport, Cambridge e.tc.). It covers 100% the syllabus of DIPLOMA Certification Body (DIPLOMA Expert Office) and other Certifications Bodies: E.C.D.L. I.C.D.L. (new profile), Vellum Cambridge, Acta, Key-cert. MOS 2007 (Exam: 77-851).

Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1280x720 (size of text, apps and other items 100%)

Operating system: Windows XP / Vista / 7 / 8 / 8.1 / 10 (updated with newer service pack - Region Format: English (United States))
Internet Explorer: 7.0+
MS Office Excel 365, 2019, 2016, 2013, 2010, 2007 or 2003 - English Version (Fully Functional) must be installed - There must be only one version installed
Continuous Internet connection is required
Last updated: 14 May 2020
TEST4U premium quality
Check the quality
of our questions
Enter your e-mail address below and we will immediately send you 55 questions
Syllabus
This product covers the following syllabus. You can see the sections covered as well as the number of questions by clicking on each tab.
TEST4U
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  193 1 194
SECTION 1First steps SAMPLE QUESTION 3 0 3
SECTION 2Basic Settings SAMPLE QUESTION 19 0 19
SECTION 3Cells SAMPLE QUESTION 4 0 4
SECTION 4Formulas and Functions SAMPLE QUESTION 34 0 34
SECTION 5Formatting SAMPLE QUESTION 12 0 12
SECTION 6Charts SAMPLE QUESTION 22 0 22
SECTION 7Special functions 1 SAMPLE QUESTION 20 0 20
SECTION 8Special functions 2 SAMPLE QUESTION 19 0 19
SECTION 9Images SAMPLE QUESTION 3 0 3
SECTION 10Data SAMPLE QUESTION 32 0 32
SECTION 11Sortings, Filters, Macros, Templates SAMPLE QUESTION 19 1 20
SECTION 12DIPLOMA level questions SAMPLE QUESTION 6 0 6
E.C.D.L.
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  202 2 204
1 Formatting 34 1 35
SECTION 1 1.1 Cells SAMPLE QUESTION 21 0 21
SECTION 2 1.2 Worksheets SAMPLE QUESTION 13 1 14
2 Functions and Formulas 47 1 48
SECTION 1 2.1 Using Functions and Formulas SAMPLE QUESTION 47 1 48
2.1.1 Use date and time functions
9 0 9
2.1.2 Use logical functions
2 0 2
2.1.3 Use mathematical functions
6 0 6
2.1.4 Use statistical functions
3 0 3
2.1.5 Use text functions
6 0 6
2.1.6 Use financial functions
3 0 3
2.1.7 Use lookup functions
5 0 5
2.1.8 Use database functions
5 0 5
2.1.9 Create a two-level nested function
3 0 3
2.1.10 Use a 3-D reference within a sum, average, minimum, maximum function
2 0 2
2.1.11 Use mixed references in formulas
4 1 5
3 Charts 18 0 18
SECTION 1 3.1 Creating Charts SAMPLE QUESTION 8 0 8
SECTION 2 3.2 Formatting Charts SAMPLE QUESTION 10 0 10
4 Analysis 41 0 41
SECTION 1 4.1 Using Tables SAMPLE QUESTION 16 0 16
SECTION 2 4.2 Sorting and Filtering SAMPLE QUESTION 23 0 23
SECTION 3 4.3 Scenarios SAMPLE QUESTION 4 0 4
5 Validating and Auditing 13 0 13
SECTION 1 5.1 Validating SAMPLE QUESTION 2 0 2
SECTION 2 5.2 Auditing SAMPLE QUESTION 11 0 11
6 Enhancing Productivity 34 0 34
SECTION 1 6.1 Naming Cells SAMPLE QUESTION 6 0 6
SECTION 2 6.2 Paste Special SAMPLE QUESTION 7 0 7
SECTION 3 6.3 Linking, Embedding and Importing SAMPLE QUESTION 17 0 17
SECTION 4 6.4 Automation SAMPLE QUESTION 4 0 4
7 Collaborative Editing 15 0 15