MOS Excel Core 2013 — Exam:77-420

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)
  • 324 Live in ates Questions
  • 10 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 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.

Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152×864
Operating system: Windows 7 / 8 / 8.1 / 10(updated with newer service pack – Region Format: English (United States))
Internet Explorer: 7.0+
MS Office Excel 2013 – English Version (Fully Functional) must be installed
Continuous Internet connection is required


This product covers the following syllabus.

324 10 334
Prerequisites (Before MOS Syllabus)
26 4 30
1.0. Create and Manage Worksheets and Workbooks 102 4 106
1.1. Create Worksheets and Workbooks 16 1 17
1.2. Navigate through Worksheets and Workbooks 6 0 6
1.3. Format Worksheets and Workbooks 12 0 12
1.4. Customize Options and Views for Worksheets and Workbooks 34 1 35
1.5. Configure Worksheets and Workbooks to Print or Save 34 2 36
2.0. Create Cells and Ranges 75 0 75
2.1. Insert Data in Cells and Ranges 26 0 26
2.2. Format Cells and Ranges 30 0 30
2.3. Order and Group Cells and Ranges 19 0 19
3.0. Create Tables 19 0 19
3.1. Create a Table 3 0 3
3.2. Modify a Table 3 0 3
3.3. Filter and Sort a Table 13 0 13
4.0. Apply Formulas and Functions 40 2 42
4.1. Utilize Cell Ranges and References in Formulas and Functions 10 2 12
4.2. Summarize Data with Functions 18 0 18
4.3. Utilize Conditional Logic in Functions 5 0 5
4.4. Format and Modify Text with Functions 7 0 7
5.0. Create charts and objects 56 0 56
5.1. Create a Chart 11 0 11
5.2. Format a Chart 36 0 36
3 5.3. Insert and Format an Object 9 0 9
Challenging Questions (Beyond MOS Syllabus)
2 0 2
Project-Based Questions (as seen in the MOS 2013 exam)
4 0 4
  • Release Date: 25 October, 2017

  • Price: 25.79

  • Category: