noscript
  1. Home Page
  2. /
  3. /
  4. E.C.D.L./I.C.D.L Base Spreadsheets - English version

E.C.D.L./I.C.D.L Base Spreadsheets
English version

Last updated: 30 Nov 2020
Rely on TEST4U because it offers:
  • Variety - 230 exercises for E.C.D.L. / I.C.D.L. Base Spreadsheets
  • Help - 216 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, German, Italian.

E.C.D.L./I.C.D.L. Base - Spreadsheets

 

You have realized the need for an IT Certificate which proves your skills in using a Spreadsheets Application and you have decided to pursue the E.C.D.L. Spreadsheets Certification, which is provided by PeopleCert Certification Body.

So, how will you become 100% ready for the exam? With the adequate TEST4U module.

Congratulations! The “hard” part is over.

TEST4U will train you properly

 

TEST4U includes everything that you’ll need in order to not only pass the exam and become Certified, but also acquire the necessary level of competencies and skills to be able to manage Spreadsheets in order to perform your daily tasks and manage the various office files.

 

Operating a Spreadsheets application is a must-have skill for a wide range of professionals, such as managers, accountants, financial managers, freelancers, scientists and researchers, as well as students, pupils and everyday users.

 

This is so cool, however, what the Candidate needs to know is as simple as:

“Upon successful completion of the module Spreadsheets will I have learnt...?”

  • How to add data and format a spreadsheet
  • How to manage effectively the data in a spreadsheet
  • How to prepare a spreadsheet for print
  • How to create beautiful charts
  • How to use formulas and functions

The answer to all of the above is: YES! You will have learnt how to perform all these tasks and many more, since TEST4U has specifically adjust each module to the requirements of each exam. TEST4U covers 100% the syllabus with targeted questions for every module, so as to match the level of difficulty, relevance, customization etc. We reassure you that we have gathered all the training tools you will need in TEST4U!

Quiz Questions

 

Free Practice
TEST4U includes many Live-in-the-app Questions and some Quiz Questions.
Here are some TEST4U Quiz Questions.
Take a look!

 

_
X  
TRY IT

CORRECT
Success stories
Success story of Mariam Mtsariashvili
Mariam Mtsariashvili

Amazing course! Exam questions were incredibly similar to this one. Course teaches you the software so thoroughly that the actual exam will seem super easy for you. It teaches you everything in depth and most importantly time management. I was mostly worried about time and I finished the exam in 35 minutes. Thank you for your support ❤️ and wish you the best of luck.

Update: Turns out I won regional championship. I'm going to New York!! Thank you again Annita ❤️

Read the review on Facebook

Why is TEST4U so effective?

 

An innovative method of learning

TEST4U was initially released in Greece, in 2003, introducing an innovative way of learning by practicing on in-application questions. What does that mean? That the way of learning is based on the understanding of how to approach each question by actually performing tasks on the real (installed) application, as opposed to learning by heart the right answers.

The Online Collaboration syllabus includes topics that can only be covered by closed type questions, and not in-application ones. As a result, the TEST4U Online Collaboration Module covers 100% the respective syllabus with closed type questions only.

 

TEST4U interface is identical to the exam interface

What would be the point of preparing you for an examination environment which is different from the one where you will be examined? None! This is why we have designed TEST4U in such a way, so as to maximize your familiarization with the exams and minimize your anxiety.

 

No question remains unanswered

TEST4U includes a distinct video-solution for each one of the questions it includes. This way, in case your answer to a question is wrong, or in case you don’t know how to answer a question or how to approach a task, all you need to do is watch the brief accompanying video-solution that we have prepared. It will show you the steps you need to follow in order to approach each question the right way, and ultimately learn how to use the application appropriately.

 

Can I become certified by TEST4U?

TEST4U is a training software which delivers the promise to prepare you adequately for the Certification exams. This is the reason why more than 700.000 users have trusted TEST4U since 2003 for their IT training.

In order to obtain a Certification, however, you will need to address a local representative of the Certification Body of your choice. There are various Certification Bodies, such as Knowledge Pillars, Certiport, E.C.D.L./I.C.D.L. to name a few.

For questions related to the examination fees (price per exam), availability etc. you will need to contact an Authorized Testing Center of the Certification Body of your choice.

14 reasons why TEST4U is all you need to pass the E.C.D.L. Base Spreadsheets Exam

 

  1. More than an E-course
    TEST4U is very different from an e-course. TEST4U will let you actively participate in the learning process, instead of just watching a video-lesson.
  2. Exams are performance-based. So is TEST4U
    The exams are performance-based, therefore Candidates are expected to be able to perform under a high-pressure environment.
  3. TEST4U is a Tutor, only virtual
    Who doesn’t need instant feedback about how they just answered a question? Immediate evaluation of each of the answers you submit is the core idea behind TEST4U.
  4. Covers 100% the Objective Domains by E.C.D.L.
    With TEST4U you will cover 100% all the Objective Domains:
    • Using the Application
    • Cells
    • Managing Worksheets
    • Formulas and Functions
    • Formatting
    • Charts
    • Prepare Outputs
  5. Includes 230 quiz questions for E.C.D.L. Base Spreadsheets
    Not only are there too many questions to practice on, but they are of the same level of difficulty as compared to what you will face at the exams. Ok, yeah, some of them are slightly trickier, but the point is to learn, right?
    Solving them all will give you an increased sense of self-confidence during the exam and will help you learn how to manage your time better.
  6. Target your training
    Ok, you are familiar with Online Collaboration. But not with everything. This is why TEST4U has broken down into categories the entire Syllabus, to help you personalize your training and focus in the less-known areas.
  7. Repeat, repeat, repeat
    As many times as you feel that you need to. There are no limits. You may practice on the same question again and again until you are satisfied with your results.
  8. Experience matters, but a brush-up is always a good idea
    Even if you are an experienced user, you will upgrade your knowledge to Spreadsheets.
  9. Trust the Experts
    TEST4U is not another e-learning material. TEST4U is different. Our years of classroom training experience and teaching techniques have been incorporated in TEST4U. As a result, TEST4U covers 100% the syllabus of E.C.D.L. Certification Body.
  10. Choose the option that suits you best
    A 15-hour training package is ideal for the Candidates with a prior familiarization with Online Collaboration, but this is not the case with all of the Candidates out there. If your experience is limited, or if you haven’t participated in an exam lately, the 25-hour training package will allow you to train at your own pace.
  11. Access to the latest updates
    TEST4U provides access to the latest updated version of the TEST4U module you selected, all features included (new questions, updates e.tc.). Just login and the updated version will install automatically.
  12. Access TEST4U from anywhere!
    Do you need to access TEST4U from more than one PCs or locations? We encourage you to do so! TEST4U is the most flexible training platform, that allows you to train according to your account and does not commit you to a specific PC or Workstation.
  13. Access TEST4U with any device
    The Online Collaboration course can be run either by the TEST4U windows application, or by its web-based counterpart. This means you can run all the questions in a browser in your MacOS, iOS, Linux, Windows or Android device.
  14. Take your time to try it!
    Download the TEST4U Demo which contains tests and exercises for practice, to try it out.
  15. TEST4U is more than widespread around the globe
    More than 700.000 Candidates have trusted TEST4U for their exam preparation since 2003. Be the next one.
Last updated: 30 Nov 2020
More than 700.000 Candidates have trusted TEST4U for their Training since 2003.
This is what they say:

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: 30 Nov 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
 
  216 14 230
SECTION 1First steps SAMPLE QUESTION 15 6 21
SECTION 2Basic Settings SAMPLE QUESTION 17 0 17
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
E.C.D.L. v6.0
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  227 19 246
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 33 3 36
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 12 0 12
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.
2 0 2
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 26 1 27
SECTION 1 3.1. Rows and Columns SAMPLE QUESTION 17 0 17
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.
4 0 4
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 39 0 39
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 13 0 13
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.
4 0 4
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