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

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

Rely on TEST4U because it offers:


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!

For Enterprises

If your job is about computer education, 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.


What does TEST4U offer?

TEST4U Excel Expert Test is an interactive, highly customizable tool that will satisfy your personal educational 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 and
  • DIPLOMA level Questions, available for practice on actual working environment conditions.

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, ECDL-ICDL, Microsoft Certiport, Cambridge e.tc.). It covers 100% the syllabus of DIPLOMA Certification Body (DIPLOMA Expert Office) and other Certifications Bodies: Ecdl Icdl (new profile), Vellum Cambridge, Acta, Key-cert. MOS 2007 (Exam: 77-851).

For questions about participation fees (price per unit), please refer to one of the certified examination centers of the Certification Body.

Last updated: 03 Jan 2018
Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152x864

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 2003, 2007, 2010, 2013 or 2016 - English Version (Fully Functional) must be installed
Continuous Internet connection is required
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 0 193
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 0 19
SECTION 12DIPLOMA level questions SAMPLE QUESTION 6 0 6
ECDL
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  202 1 203
1 Formatting 31 0 31
SECTION 1 1.1 Cells SAMPLE QUESTION 22 0 22
1.1.1 Apply an autoformat/table style to a cell range.
6 0 6
1.1.2 Apply conditional formatting based on cell content.
10 0 10
1.1.3 Create and apply custom number formats.
6 0 6
SECTION 2 1.2 Worksheets SAMPLE QUESTION 9 0 9
1.2.1 Copy, move worksheets between spreadsheets.
2 0 2
1.2.2 Split a window. Move, remove split bars.
2 0 2
1.2.3 Hide, show rows, columns, worksheets.
5 0 5
2 Functions and Formulas 46 1 47
SECTION 1 2.1 Using Functions and Formulas SAMPLE QUESTION 46 1 47
2.1.1 Use date and time functions: today, now, day, month, year.
9 0 9
2.1.2 Use mathematical functions: rounddown, roundup, sumif.
6 0 6
2.1.3 Use statistical functions: countif, countblank, rank.
3 0 3
2.1.4 Use text functions: left, right, mid, trim, concatenate.
6 0 6
2.1.5 Use financial functions: fv, pv, pmt.
3 0 3
2.1.6 Use lookup functions: vlookup, hlookup.
5 0 5
2.1.7 Use database functions: dsum, dmin, dmax, dcount, daverage.
5 0 5
2.1.8 Create a two-level nested function.
3 0 3
2.1.9 Use a 3-D reference within a sum function.
2 0 2
2.1.10 Use mixed references in formulas.
4 1 5
3 Charts 17 0 17
SECTION 1 3.1 Creating Charts SAMPLE QUESTION 7 0 7
3.1.1 Create a combined column and line chart.
1 0 1
3.1.2 Add a secondary axis to a chart.
1 0 1
3.1.3 Change the chart type for a defined data series.
1 0 1
3.1.4 Add, delete a data series in a chart.
4 0 4
SECTION 2 3.2 Formatting Charts SAMPLE QUESTION 10 0 10
3.2.1 Re-position chart title, legend, data labels.
5 0 5
3.2.2 Change scale of value axis: minimum, maximum number to display, major interval.
1 0 1
3.2.3 Change display units on value axis without changing data source: hundreds, thousands, millions.
1 0 1
3.2.4 Format columns, bars, plot area, chart area to display an image.
3 0 3
4 Analysis 41 0 41
SECTION 1 4.1 Using Tables SAMPLE QUESTION 16 0 16
4.1.1 Create, modify a pivot table/datapilot.
7 0 7
4.1.2 Modify the data source and refresh the pivot table/datapilot.
2 0 2
4.1.3 Filter, sort data in a pivot table/datapilot.
1 0 1
4.1.4 Automatically, manually group data in a pivot table/datapilot and rename groups.
4 0 4
4.1.5 Use one-input, two-input data tables/multiple operations tables.
2 0 2
SECTION 2 4.2 Sorting and Filtering SAMPLE QUESTION 21 0 21
4.2.1 Sort data by multiple columns at the same time.
5 0 5
4.2.2 Create a customized list and perform a custom sort.
1 0 1
4.2.3 Automatically filter a list in place.
5 0 5
4.2.4 Apply advanced filter options to a list.
4 0 4
4.2.5 Use automatic sub-totalling features.
5 0 5
4.2.6 Expand, collapse outline detail levels.
1 0 1
SECTION 3 4.3 Scenarios SAMPLE QUESTION 4 0 4
4.3.1 Create named scenarios.
1 0 1
4.3.2 Show, edit, delete scenarios.
2 0 2
4.3.3 Create a scenario summary report.
1 0 1
5 Validating and Auditing 13 0 13
SECTION 1 5.1 Validating SAMPLE QUESTION 2 0 2
5.1.1 Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time.
1 0 1
5.1.2 Enter input message and error alert.
1 0 1
SECTION 2 5.2 Auditing SAMPLE QUESTION 11 0 11
5.2.1 Trace precedent, dependent cells. Identify cells with missing dependents.
5 0 5
5.2.2 Show all formulas in a worksheet, rather than the resulting values.
2 0 2
5.2.3 Insert, edit, delete, show, hide comments/notes.
4 0 4
6 Enhancing Productivity 35 0 35
SECTION 1 6.1 Naming Cells SAMPLE QUESTION 5 0 5
6.1.1 Name cell ranges, delete names for cell ranges.
4 0 4
6.1.2 Use named cell ranges in a function.
1 0 1
SECTION 2 6.2 Paste Special SAMPLE QUESTION 6 0 6
6.2.1 Use paste special options: add, subtract, multiply, divide.
2 0 2
6.2.2 Use paste special options: values /numbers, transpose.
4 0 4
SECTION 3 6.3 Templates SAMPLE QUESTION 3 0 3
6.3.1 Create a spreadsheet based on an existing template.
1 0 1
6.3.2 Modify a template.
2 0 2
SECTION 4 6.4 Linking, Embedding and Importing SAMPLE QUESTION 17 0 17
6.4.1 Insert, edit, remove a hyperlink.
2 0 2
6.4.2 Link data within a spreadsheet, between spreadsheets, between applications.
7 0 7
6.4.3 Update, break a link.
6 0 6
6.4.4 Import delimited data from a text file.
2 0 2
SECTION 5 6.5 Automation SAMPLE QUESTION 4 0 4
6.5.1 Record a simple macro like: change page setup, apply a custom number format, apply autoformats to a cell range, insert fields in worksheet header, footer.
2 0 2
6.5.2 Run a macro.
1 0 1
6.5.3 Assign a macro to a custom button on a toolbar.
1 0 1
7 Collaborative Editing 19 0 19
SECTION 1 7.1 Tracking and Reviewing SAMPLE QUESTION 6 0 6
7.1.1 Turn on, off track changes. Track changes in a worksheet using a specified display view.
3 0 3
7.1.2 Accept, reject changes in a worksheet.
1 0 1
7.1.3 Compare and merge spreadsheets.
2 0 2
SECTION 2 7.2 Security SAMPLE QUESTION 13 0 13
7.2.1 Add, remove password protection for a spreadsheet: to open, to modify.
7 0 7
7.2.2 Protect, unprotect cells, worksheet with a password.
5 0 5
7.2.3 Hide, unhide formulas.
1 0 1

TEST4U premium quality
Check the quality
of our questions
Enter your e-mail address below and we will immediately send you 55 questions