Weekend Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: get65

Microsoft 77-420 Exam Topics, Blueprint and Syllabus

Excel 2013

Last Update September 7, 2024
Total Questions : 30

Our Microsoft Office Specialist 77-420 exam questions and answers cover all the topics of the latest Excel 2013 exam, See the topics listed below. We also provide Microsoft 77-420 exam dumps with accurate exam content to help you prepare for the exam quickly and easily. Additionally, we offer a range of Microsoft 77-420 resources to help you understand the topics covered in the exam, such as Microsoft Office Specialist video tutorials, 77-420 study guides, and 77-420 practice exams. With these resources, you can develop a better understanding of the topics covered in the exam and be better prepared for success.

Free 77-420 Exam Questions Get Premium Access

77-420
PDF

$38.5  $109.99
 Add to Cart

77-420 Testing Engine

$45.5  $129.99
 Add to Cart

77-420 PDF + Testing Engine

$59.5  $169.99
 Add to Cart

Microsoft 77-420 Exam Overview :

Exam Name Excel 2013
Exam Code 77-420
Actual Exam Duration The Microsoft 77-420 exam is a 90 minutes.
Expected no. of Questions in Actual Exam 60
What exam is all about Microsoft 77-420 is an exam for the Microsoft Office 365 Identity and Services certification. It tests a candidate's knowledge and skills related to Office 365 services, including Exchange Online, SharePoint Online, Skype for Business Online, and Office 365 identity and hybrid identity.
Passing Score required The passing score for the Microsoft 77-420 exam is 700 out of 1000.
Competency Level required The Microsoft 77-420 exam is an entry-level exam that tests a candidate's knowledge of Microsoft Office 365. The exam is designed to assess a candidate's ability to configure, manage, and troubleshoot Office 365 services. To pass the exam, a candidate must demonstrate a fundamental understanding of Office 365 services and their associated features.
Questions Format The Microsoft 77-420 exam consists of multiple-choice questions.
Delivery of Exam The Microsoft 77-420 exam is available as a proctored online exam.
Language offered English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Italian, Japanese, Korean, Norwegian, Dutch, Polish, Portuguese (Brazil), Russian, Arabic (Saudi Arabia), Greek (Greece), Vietnamese (Vietnam)
Cost of exam The cost of the Microsoft 77-420 exam is $100 USD.
Target Audience The Microsoft 77-420 exam is intended for individuals who are looking to become certified in Microsoft Office Specialist (MOS) Word 2013. This certification is designed for individuals who have a basic understanding of the Microsoft Office suite and want to demonstrate their proficiency in using Word 2013. This certification is ideal for individuals who are looking to advance their career in the field of office productivity and demonstrate their knowledge of the Microsoft Office suite.
Average Salary in Market The average salary for someone with a Microsoft 77-420 certification is around $90,000 per year.
Testing Provider Microsoft does not provide the 77-420 exam for testing. The 77-420 exam is a certification exam that is used to assess a candidate's knowledge and skills related to Microsoft Office 365. Candidates must register and pay for the exam in order to take it.
Recommended Experience The recommended experience for the Microsoft 77-420 exam is a basic understanding of the Microsoft Office 365 suite of applications, including Word, Excel, PowerPoint, Outlook, OneNote, and SharePoint. Additionally, candidates should have a basic understanding of cloud concepts, including Office 365, Azure, and Exchange Online.
Prerequisite The Microsoft 77-420 exam requires that you have a basic understanding of Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, and Access. Additionally, you should have a basic understanding of Windows operating systems, including Windows 7, 8, and 10.
Retirement (If Applicable) The Microsoft Office Specialist (MOS) 2013 program will be retiring with the release of the new MOS 365 Apps exams. All 2013 exams in a given language will retire when the last MOS 365 Apps exam planned for that language is released. You can find the planned release timeframes for each MOS 365 Apps exam in each language on Certiport’s Exam Releases page.
Certification Track (RoadMap): The Microsoft 77-420 exam is part of the Microsoft Office Specialist (MOS) certification track. It is designed to test a candidate's knowledge and skills in using Microsoft Excel 2016. The exam covers topics such as creating and managing worksheets and workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions, and creating charts and objects. Passing the 77-420 exam will earn the candidate the Microsoft Office Specialist (MOS) Excel 2016 certification.
Official Information https://www.microsoft.com/en-us/learning/exam-77-420.aspx
See Expected Questions Microsoft 77-420 Expected Questions in Actual Exam
Take Self-Assessment Use Microsoft 77-420 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

Microsoft 77-420 Exam Topics :

Section Weight Objectives
Create and manage worksheets and workbooks   Create worksheets and workbooks
  • creating new blank workbooks; creating new workbooks using templates; importing files; opening non-native files directly in Excel; adding worksheets to existing workbooks; copying and moving worksheets
Navigate through worksheets and workbooks
  • searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box
Format worksheets and workbooks
  • changing worksheet tab color; modifying page setup; inserting and deleting columns and rows; changing workbook themes; adjusting row height and column width; inserting watermarks; inserting headers and footers; setting data validation
Customize options and views for worksheets and workbooks
  • hiding worksheets; hiding columns and rows; customizing the Quick Access toolbar; customizing the Ribbon; managing macro security; changing workbook views; recording simple macros; adding values to workbook properties; using zoom; displaying formulas; freezing panes; assigning shortcut keys; splitting the window
Configure worksheets and workbooks to print or save
  • setting a print area; saving workbooks in alternate file formats; printing individual worksheets; setting print scaling; repeating headers and footers; maintaining backward compatibility; configuring workbooks to print; saving files to remote locations
Create cells and ranges   Insert data in cells and ranges
  • appending data to worksheets; finding and replacing data; copying and pasting data; using AutoFill tool; expanding data across columns; inserting and deleting cells
Format cells and ranges
  • merging cells; modifying cell alignment and indentation; changing font and font styles; using Format Painter; wrapping text within cells; applying Number format; applying highlighting; applying cell styles; changing text to WordArt
Order and group cells and ranges
  • applying conditional formatting; inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsing groups of data in outlines; inserting subtotals
Create tables   Create a table
  • moving between tables and ranges; adding and removing cells within tables; defining titles
Modify a table
  • applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables
Filter and sort a table
  • filtering records; sorting data on multiple columns; changing sort order; removing duplicates
Apply formulas and functions   Utilize cell ranges and references in formulas and functions
  • utilizing references (relative, mixed, absolute); defining order of operations; referencing cell ranges in formulas
Summarize data with functions
  • utilizing the SUM function; utilizing the MIN and MAX functions; utilizing the COUNT function; utilizing the AVERAGE function Utilize conditional logic in functions
  • utilizing the SUMIF function; utilizing the AVERAGEIF function; utilizing the COUNTIF function
Format and modify text with functions
  • utilizing the RIGHT, LEFT and MID functions; utilizing the TRIM function; utilizing the UPPER and LOWER functions; utilizing the CONCATENATE function
Create charts and objects   Create a chart
  • creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis
Format a chart
  • adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs Insert and format an object
  • inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colors; modifying object properties; positioning objects