March Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Microsoft Updated 77-420 Exam Blueprint, Syllabus and Topics

Excel 2013

Last Update Mar 28, 2024
Total Questions : 30

You will be glad to know that we serve better with the real exam topics related to your subject. We give you Microsoft Office Specialist 77-420 questions answers. You can prepare them easily and quickly. Microsoft 77-420 exam dumps are also available with accurate exam content. All Exam questions of Microsoft Office Specialist 77-420 Exam are related to latest Excel 2013 topics, let’s take a look:

77-420 pdf

77-420 PDF

$38.5  $109.99
77-420 Engine

77-420 Testing Engine

$45.5  $129.99
77-420 PDF + Engine

77-420 PDF + Testing Engine

$59.5  $169.99

Microsoft 77-420 Exam Overview :

Exam Name Excel 2013
Exam Code 77-420
Actual Exam Duration 90 minutes
Expected no. of Questions in Actual Exam 60
Exam Registration Price $100
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

77-420 Exam Topics | 77-420 Questions answers | 77-420 Test Prep | Excel 2013 Exam Questions PDF | 77-420 Online Exam | 77-420 Practice Test | 77-420 PDF | 77-420 Test Questions | 77-420 Study Material | 77-420 Exam Preparation | 77-420 Valid Dumps | 77-420 Real Questions | Microsoft Office Specialist 77-420 Exam Questions