1. Home Page 
  2. /
  3. e-tests 
  4. /
  5. Microsoft Office Specialist (MOS)  
  6. / 77-420 Microsoft Office Specialist Excel Core 2013 - German version

77-420 Microsoft Office Specialist Excel Core 2013
German 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 empower your knowledge, train you on the latest version of MS Excel and prepare you for the Certiport, Microsoft Office Specialist Excel 2013 Exam 77-420.

TEST4U MOS Excel 2013 77-420 Test contains exercises which cover the entire syllabus of Certiport Certification Body Exam 77-420. The test uses the new examination environment V2.


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 and prepares them for the Certiport, Microsoft Office Specialist Excel 2013 Exam 77420.

TEST4U MOS Excel 2013 77-420 Test contains exercises which cover the entire syllabus of Certiport Certification Body Exam 77420. The test uses the new examination environment V2.


What does TEST4U offer?

TEST4U MOS Excel 2013 77-420 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 MOS Excel 2013 77-420 Test will help you improve your skills because it contains:

  • Project-Based Questions (Version 2 - MOS Syllabus)
  • 319 Live in ates Questions
  • 8 Quiz Questions
  • Challenging Questions (Beyond MOS Syllabus)

Instead of being just another e-lesson with a few multiple choice questions, TEST4U MOS Excel 2013 77-420 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.

By successfully completing our MS-Excel TEST4U Module, you will know how to create and manage workbooks and worksheets, 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 2013 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 Certiport Certification Body (Exam: 77-420).

Download the MOS Excel 2013 77-420 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: 1024x768 (size of text, apps and other items 100%)

Operating system: 7 / 8 / 8.1 / 10(updated with newer service pack - Region Format: German (Germany))
Internet Explorer: 7.0+
MS Office Excel 2013 - German 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.
Microsoft Office Specialist 2013
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  319 8 327
Voraussetzungen (unterhalb der MOS-Lernziele) [?]
26 3 29
1.0. Erstellen und Verwalten von Arbeitsblättern und Arbeitsmappen 101 4 105
SECTION 1 1.1. Erstellen von Arbeitsblättern und Arbeitsmappen SAMPLE QUESTION 16 1 17
SECTION 2 1.2. Navigieren durch Arbeitsblätter und Arbeitsmappen SAMPLE QUESTION 6 0 6
SECTION 3 1.3. Formatieren von Arbeitsblättern und Arbeitsmappen SAMPLE QUESTION 12 0 12
SECTION 4 1.4. Anpassen der Optionen und Ansichten für Arbeitsblätter und Arbeitsmappen SAMPLE QUESTION 33 1 34
SECTION 5 1.5. Konfigurieren der Arbeitsblätter und Arbeitsmappen zum Drucken oder Speichern SAMPLE QUESTION 34 2 36
2.0. Erstellen von Zellen und Bereichen 75 0 75
SECTION 1 2.1. Einfügen von Daten in Zellen und Bereiche SAMPLE QUESTION 26 0 26
SECTION 2 2.2. Formatieren von Zellen und Bereichen SAMPLE QUESTION 30 0 30
SECTION 3 2.3. Ordnen und Gruppieren von Zellen und Bereichen SAMPLE QUESTION 19 0 19
3.0. Tabellen erstellen 19 0 19
SECTION 1 3.1. Erstellen einer Tabelle SAMPLE QUESTION 3 0 3
SECTION 2 3.2. Ändern einer Tabelle SAMPLE QUESTION 3 0 3
SECTION 3 3.3. Filtern und Sortieren einer Tabelle SAMPLE QUESTION 13 0 13
4.0. Anwenden von Formeln und Funktionen 40 1 41
SECTION 1 4.1. Verwenden von Zellenbereichen und Referenzen in Formeln und Funktionen SAMPLE QUESTION 10 1 11
SECTION 2 4.2. Zusammenfassung der Daten mithilfe von Funktionen SAMPLE QUESTION 18 0 18
SECTION 3 4.3. Verwenden bedingter Logik in Funktionen SAMPLE QUESTION 5 0 5
SECTION 4 4.4. tieren und Ändern von Text mithilfe von Funktionen SAMPLE QUESTION 7 0 7
5.0. Erstellen von Diagrammen und Objekten 57 0 57
SECTION 1 5.1. Erstellen eines Diagramms SAMPLE QUESTION 11 0 11
SECTION 2 5.2. Formatieren eines Diagramms SAMPLE QUESTION 37 0 37
SECTION 3 5.3. Einfügen und Formatieren eines Objekts SAMPLE QUESTION 9 0 9
Projektorientierte Abfrage (wie bei MOS 2013-Prüfung) [?]
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