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

ECDL Base Excel 2016, 2013, 2010, 2007, 2003
English version

Rely on TEST4U because it offers:


For individuals

MS Excel is the most popular spreadsheet program, used in order to calculate, arrange and store data. Whether this is your first acquaintance with MS Excel or you have already been using it and you are looking to upgrade your skills, TEST4U will enable you to empower your knowledge.

For Enterprises

If your job is around Computer Education, TEST4U is the right tool for you. TEST4U is the most popular and interactive learning tool for office software because it goes beyond a simple e-Course. It helps the students consolidate everything they have just watched!


What does TEST4U offer?

TEST4U ECDL / ICDL Base Spreadsheets Test is an interactive, highly customizable tool that meets your personal learning needs. During the media-rich TEST4U experience, you will amplify your understanding of MS Excel, the most famous and flexible spreadsheet software, part of Microsoft Office Suite.

TEST4U ECDL / ICDL Base Spreadsheets Test will help you improve your skills because it contains:

  • 215 Live in ates Questions
  • 14 Quiz Questions

Instead of being just another e-lesson with a few multiple choice questions, TEST4U ECDL / ICDL Base Spreadsheets Test makes the difference! The questions it contains require actual tasks to be performed. For each question, you are asked to take some actions, which TEST4U will evaluate. Much like 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 are totally ignorant of MS Excel, we propose that, prior to practicing at TEST4U, you should watch our online video-lessons (e-courses).

By successfully completing our MS-Excel TEST4U Module, you will know how to perform the basic settings, work with cells, use formulas and functions, create and modify charts, apply formattings e.tc. If you are used to working with an older version, you will upgrade your skills to the latest 2016 version.

We have incorporated in TEST4U all our years of classroom training experience and teaching techniques. As a result, TEST4U covers 100% the syllabus of DIPLOMA Certification Body (DIPLOMA Business Office and DIPLOMA Basic Office) and other Certification Bodies: Ecdl Icdl (new profile, core, start 5.0), Microsoft Infotest, Vellum Cambridge, Acta, Key-cert, ICT, Globalcert, Certiport MOS 2007 (Exam: 77-602).

Download the ECDL / ICDL Base Spreadsheets Test which contains tests and exercises for practice.

If you have questions about participation fees (price per unit), please contact one of the certified examination centers of the Certification Body.

Last updated: 10 Apr 2018
Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152x864 (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 2003, 2007, 2010, 2013 or 2016 - English Version (Fully Functional) must be installed - There must be only one version 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
 
  215 14 229
SECTION 1First steps SAMPLE QUESTION 15 6 21
SECTION 2Basic Settings SAMPLE QUESTION 16 0 16
SECTION 3Cells 1 SAMPLE QUESTION 25 0 25
SECTION 4Cells 2 SAMPLE QUESTION 24 0 24
SECTION 5WorkSheets SAMPLE QUESTION 9 1 10
SECTION 6Formulas and Functions SAMPLE QUESTION 37 4 41
SECTION 7Formatting SAMPLE QUESTION 29 0 29
SECTION 8Charts SAMPLE QUESTION 23 1 24
SECTION 9Output: Setup and Print SAMPLE QUESTION 20 2 22
SECTION 10Functions SAMPLE QUESTION 14 0 14
SECTION 11Images SAMPLE QUESTION 3 0 3
ECDL v6.0
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  228 19 247
1. Using the Application 34 8 42
SECTION 1 1.1. Working with Spreadsheets SAMPLE QUESTION 18 5 23
1.1.1. Open, close a spreadsheet application. Open, close spreadsheets.
4 0 4
1.1.2. Create a new spreadsheet based on default template, other available template locally or online.
2 1 3
1.1.3. Save a spreadsheet to a location on a local, online drive. Save a spreadsheet under another name to a location on a local or online drive.
3 4 7
1.1.4. Save a spreadsheet as another file type like: text file, pdf, csv, software specific file extension.
8 0 8
1.1.5. Switch between open spreadsheets.
1 0 1
SECTION 2 1.2. Enhancing Productivity SAMPLE QUESTION 16 3 19
1.2.1. Set basic options/preferences in the application: user name, default folder to open, save spreadsheets.
3 0 3
1.2.2. Use available Help resources.
1 1 2
1.2.3. Use magnification/zoom tools.
3 0 3
1.2.4. Display, hide built-in toolbars. Restore, minimize the ribbon.
9 0 9
1.2.5. Recognise good practice in navigating within a spreadsheet: use shortcuts, go to tool.
0 1 1
1.2.6. Use go to tool to navigate to a specific cell.
0 1 1
2. Cells 34 3 37
SECTION 1 2.1 Insert, Select SAMPLE QUESTION 8 3 11
2.1.1. Understand that a cell in a worksheet should contain only one element of data, for example, quantity in one cell, description in adjacent cell.
0 1 1
2.1.2. Recognize good practice in creating lists: avoid blank rows and columns in the main body of list, ensure cells bordering list are blank.
1 2 3
2.1.3. Enter a number, date, text in a cell.
3 0 3
2.1.4. Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet.
4 0 4
SECTION 2 2.2. Edit, Sort SAMPLE QUESTION 13 0 13
2.2.1. Edit cell content, modify existing cell content.
4 0 4
2.2.2. Use the undo, redo command.
2 0 2
2.2.3. Use a simple search command for specific content in a worksheet.
3 0 3
2.2.4. Use a simple replace command for specific content in a worksheet.
1 0 1
2.2.5. Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order.
3 0 3
SECTION 3 2.3. Copy, Move, Delete SAMPLE QUESTION 13 0 13
2.3.1. Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
3 0 3
2.3.2. Use the autofill tool/copy handle tool to copy, increment data, formula, funtion.
6 0 6
2.3.3. Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets.
2 0 2
2.3.4. Delete cell contents.
2 0 2
3. Managing Worksheets 25 1 26
SECTION 1 3.1. Rows and Columns SAMPLE QUESTION 16 0 16
3.1.1. Select a row, range of adjacent rows, range of non-adjacent rows.
2 0 2
3.1.2. Select a column, range of adjacent columns, range of non-adjacent columns.
3 0 3
3.1.3. Insert, delete rows and columns.
2 0 2
3.1.4. Modify column widths, row heights to a specified value, to optimal width or height.
6 0 6
3.1.5. Freeze, unfreeze row and/or column titles.
3 0 3
SECTION 2 3.2. Worksheets SAMPLE QUESTION 9 1 10
3.2.1. Switch between worksheets.
1 0 1
3.2.2. Insert a new worksheet, delete a worksheet.
1 0 1
3.2.3. Recognize good practice in naming worksheets: use meaningful worksheet names rather than accept default names.
0 1 1
3.2.4. Copy, move a worksheet within a spreadsheet, between spreadsheets. Rename a worksheet.
7 0 7
4. Formulas and Functions 42 4 46
SECTION 1 4.1. Arithmetic Formulas SAMPLE QUESTION 11 4 15
4.1.1. Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas.
0 1 1
4.1.2. Create formulas using cell references and arithmetic operators (addition, subtraction, multiplication, division).
5 0 5
4.1.3. Identify and understand standard error values associated with using formulas: #NAME?, #DIV/0!, #REF!, #VALUE!.
2 1 3
4.1.4. Understand and use relative, absolute cell referencing in formulas.
4 2 6
SECTION 2 4.2. Functions SAMPLE QUESTION 31 0 31
4.2.1. Use sum, average, minimum, maximum, count, counta, round functions.
24 0 24
4.2.2. Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <.
7 0 7
5. Formatting 40 0 40
SECTION 1 5.1. Numbers / Dates SAMPLE QUESTION 9 0 9
5.1.1. Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands.
6 0 6
5.1.2. Format cells to display a date style, currency symbol.
2 0 2
5.1.3. Format cells to display numbers as percentages.
1 0 1
SECTION 2 5.2. Contents SAMPLE QUESTION 14 0 14
5.2.1. Apply text formatting to cell contents: font sizes, font types.
2 0 2
5.2.2. Apply formatting to cell contents: bold, italic, underline, double underline.
1 0 1
5.2.3. Apply different colours to cell content, cell background.
2 0 2
5.2.4. Apply an autoformat/table style to a cell range.
5 0 5
5.2.5. Copy the formatting from a cell, cell range to another cell, cell range.
4 0 4
SECTION 3 5.3. Alignment, Border Effects SAMPLE QUESTION 17 0 17
5.3.1. Apply, remove text wrapping to contents within a cell, cell range.
2 0 2
5.3.2. Align cell contents: horizontally, vertically. Adjust cell content orientation.
5 0 5
5.3.3. Merge cells and centre a title in a merged cell. Unmerge cells.
4 0 4
5.3.4. Apply, remove border effects to a cell, cell range: lines, colours.
6 0 6
6. Charts 28 1 29
SECTION 1 6.1. Create SAMPLE QUESTION 12 1 13
6.1.1. Understand the uses of different types of chart: column chart, bar chart, line chart, pie chart.
0 1 1
6.1.2. Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart.
3 0 3
6.1.3. Select a chart.
1 0 1
6.1.4. Change the chart type.
1 0 1
6.1.5. Move, resize, delete a chart.
7 0 7
SECTION 2 6.2. Edit SAMPLE QUESTION 16 0 16
6.2.1. Add, remove, edit a chart title.
1 0 1
6.2.2. Add, remove a chart legend.
2 0 2
6.2.3. Add, remove data labels to a chart: values/numbers, percentages.
3 0 3
6.2.4. Change chart area background colour, legend fill colour.
2 0 2
6.2.5. Change the column, bar, line, pie slice colours in the chart.
3 0 3
6.2.6. Change font size and colour of chart title, chart axes, chart legend text.
5 0 5
7. Prepare Outputs 25 2 27
SECTION 1 7.1. Setup SAMPLE QUESTION 10 0 10
7.1.1. Change worksheet margins: top, bottom, left, right.
1 0 1
7.1.2. Change worksheet orientation: portrait, landscape. Change paper size.
3 0 3
7.1.3. Adjust page setup to fit worksheet contents on a specified number of pages.
2 0 2
7.1.4. Add, edit, delete text in headers, footers in a worksheet.
1 0 1
7.1.5. Insert, delete fields: page numbering, date, time, file name, worksheet name into headers, footers.
3 0 3
SECTION 2 7.2. Check and Print SAMPLE QUESTION 15 2 17
7.2.1. Check and correct spreadsheet calculations and text.
2 0 2
7.2.2. Turn on, off display of gridlines, display of row and column headings for printing purposes.
3 0 3
7.2.3. Apply automatic title row(s) printing on every page of a printed worksheet.
1 0 1
7.2.4. Preview a worksheet.
1 2 3
7.2.5. Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.
8 0 8

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