Microsoft Excel 2013 77-420 Certified Exam Dumps

77-420 Exam Dumps

Microsoft Excel 2013 77-420 real exam questions and online practice test engine by FreeCram. Try 77-420 exam questions for free. You can also download a free demo of the 77-420 exam PDF version.

Microsoft's 77-420 actual exam materials brought to you by FreeCram group of Microsoft certification experts.
View all 77-420 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest Microsoft Excel 2013 77-420 exam premium questions.

Certification Provider: Microsoft
Exam Code / Number: 77-420
Exam Name: Excel 2013
Exam Questions: 30
Last Updated: Jul 01, 2026
Corresponding Certification: Microsoft Office Specialist (MOS)

Go To 77-420 Questions

(344 Up Votes)

Exam Details for Microsoft 77-420

As part of the Microsoft Office Specialist program, 77-420 exam lasts for 50 minutes. On top of that, there will be an additional 10 minutes of seat time. For the number of questions, this could range from 40 to 60. The passing score is about 700 out of 1000, and the registration fee is $100.

What to Expect with Microsoft 77-420

As for the details of this exam, it is relatively brief, and you are expected to finish it within 50 minutes. Also, it intends to measure such skills as creating and managing worksheets and workbooks, making up cells and ranges, outlining tables, applying various formulas & functions, and creating charts in addition to objects. The exam is available in a large array of languages such as English, Simplified and Traditional Chinese, German, Spanish, French, Italian, Japanese, Korean, Dutch if to name a few. To add more, this test has a $100 fee in the USA, although this may differ in other countries. Also, in the official validation, you will have to complete 40-60 items with the passing score of 700 points.

Microsoft 77-420 Exam Syllabus Topics:

TopicDetails
Topic 1
  • Maintaining backward compatibility; configuring workbooks to print
  • Setting a print area; saving workbooks in alternate file formats
Topic 2
  • searching for data within a workbook; inserting hyperlinks
  • Adding worksheets to existing workbooks; copying and moving worksheets
Topic 3
  • Modifying cell alignment and indentation; changing font and font styles
  • creating new blank workbooks; creating new workbooks using templates
Topic 4
  • Inserting watermarks; inserting headers and footers; setting data validation
  • Hiding worksheets; hiding columns and rows; customizing the Quick Access toolbar
Topic 5
  • Utilizing the RIGHT, LEFT and MID functions; utilizing the TRIM functions
  • Inserting and deleting columns and rows; changing workbook themes
Topic 6
  • Utilizing the SUMIF function; utilizing the AVERAGEIF functions
  • Create worksheets and workbooks
Topic 7
  • Inserting text boxes; inserting SmartArt; insertingimages; adding borders to objects
  • Changing worksheet tab color; modifying page setup

Reference: https://www.microsoft.com/en-us/learning/exam-77-420.aspx



0
0
0
10