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

77-420 Microsoft Office Specialist Excel Core 2013
English version

Rely on TEST4U because it offers:
  • Variety - 333 exercises for MOS Excel 2013 77-420
  • 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 ?
  • Help - Incorporated Video-solutions ?
  • Plenitude - It covers 100% the certification syllabus
  • Adequacy - Same environment as the exams’
  • Flexibility - Practice on any Computer
  • Project-Based Questions (Version 2 - MOS Syllabus)
  • Challenging Questions (Beyond MOS Syllabus)
  • Prerequisites (Before MOS Syllabus)
  • Updates - Access to updated version
  • Certificate of Completion - Obtain it once you complete the training ?




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)
  • 325 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: 15 Nov 2017
Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152x864

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
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
 
  325 8 333
Prerequisites (Before MOS Syllabus) [?]
26 3 29
1.0. Create and Manage Worksheets and Workbooks 102 4 106
SECTION 1 1.1. Create Worksheets and Workbooks SAMPLE QUESTION 16 1 17
SECTION 2 1.2. Navigate through Worksheets and Workbooks SAMPLE QUESTION 6 0 6
SECTION 3 1.3. Format Worksheets and Workbooks SAMPLE QUESTION 12 0 12
SECTION 4 1.4. Customize Options and Views for Worksheets and Workbooks SAMPLE QUESTION 34 1 35
SECTION 5 1.5. Configure Worksheets and Workbooks to Print or Save SAMPLE QUESTION 34 2 36
2.0. Create Cells and Ranges 75 0 75
SECTION 1 2.1. Insert Data in Cells and Ranges SAMPLE QUESTION 26 0 26
SECTION 2 2.2. Format Cells and Ranges SAMPLE QUESTION 30 0 30
SECTION 3 2.3. Order and Group Cells and Ranges SAMPLE QUESTION 19 0 19
3.0. Create Tables 19 0 19
SECTION 1 3.1. Create a Table SAMPLE QUESTION 3 0 3
SECTION 2 3.2. Modify a Table SAMPLE QUESTION 3 0 3
SECTION 3 3.3. Filter and Sort a Table SAMPLE QUESTION 13 0 13
4.0. Apply Formulas and Functions 40 1 41
SECTION 1 4.1. Utilize Cell Ranges and References in Formulas and Functions SAMPLE QUESTION 10 1 11
SECTION 2 4.2. Summarize Data with Functions SAMPLE QUESTION 18 0 18
SECTION 3 4.3. Utilize Conditional Logic in Functions SAMPLE QUESTION 5 0 5
SECTION 4 4.4. Format and Modify Text with Functions SAMPLE QUESTION 7 0 7
5.0. Create charts and objects 57 0 57
SECTION 1 5.1. Create a Chart SAMPLE QUESTION 11 0 11
SECTION 2 5.2. Format a Chart SAMPLE QUESTION 37 0 37
SECTION 3 5.3. Insert and Format an Object SAMPLE QUESTION 9 0 9
Challenging Questions (Beyond MOS Syllabus) [?]
2 0 2
Project-Based Questions (as seen in the MOS 2013 exam) [?]
4 0 4

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