MOS 2013 Study Guide for Microsoft Excel

Cover
	Copyright page
Contents
Introduction
	Who this book is for
		How this book is organized
		Download the practice files
		Sidebar: Adapting exercise steps
		Ebook edition
		Get support and give feedback
			Errata
			We want to hear from you
			Stay in touch
Taking a Microsoft Office Specialist exam
	Microsoft Office Specialist certification
	Selecting a certification path
	Test-taking tips
	Certification benefits
	For more information
Exam 77-420: Microsoft Excel 2013
	Prerequisites
		Managing worksheets
		Managing worksheet content
		Managing Excel tables
		Managing data entries
	Objective 1: Create and manage workbooks and worksheets
		1.1 Create workbooks and worksheets
			Creating new workbooks and worksheets
			Reusing existing content
			Practice tasks
		1.2 Navigate through worksheets and workbooks
			Locating data and worksheet elements
			Inserting hyperlinks
			Practice tasks
		1.3 Format worksheets and workbooks
			Modifying page setup
			Inserting page elements
			Changing workbook themes and colors
			Modifying rows and columns
			Configuring data validation
			Practice tasks
		1.4 Customize options and views for worksheets and workbooks
			Displaying different views of worksheets
			Displaying multiple parts of a workbook
			Hiding and displaying workbook content
			Customizing the Quick Access Toolbar
			Customizing the ribbon
			Working with macros
			Modifying workbook properties
			Practice tasks
		1.5 Configure worksheets and workbooks to print  or save
			Printing workbook content
			Saving workbooks
			Practice tasks
		Objective review
	Objective 2: Manage cells and ranges
		2.1 Insert data in cells and ranges
			Creating data
			Reusing data
			Practice tasks
		2.2 Format cells and ranges
			Formatting cell structure
			Formatting cell content
			Applying number formats
			Copying formatting
			Practice tasks
		2.3 Order and group cells and ranges
			Modeling data
			Creating named ranges
			Working with data groups and summaries
			Practice tasks
		Objective review
	Objective 3: Manage tables
		3.1 Create tables
			Practice tasks
		3.2 Modify tables
			Practice tasks
		3.3 Filter and sort tables
			Practice tasks
		Objective review
	Objective 4: Apply formulas and functions
		4.1 Utilize cell ranges and references in formulas and functions
			Referencing cells and cell ranges in formulas
			Defining order of operations
			Practice tasks
		4.2 Summarize data by using functions
			Practice tasks
		4.3 Utilize conditional logic in functions
			Practice tasks
		4.4 Format and modify text by using functions
			Practice tasks
		Objective review
	Objective 5: Create charts and objects
		5.1 Create charts
			Practice tasks
		5.2 Format charts
			Practice tasks
		5.3 Insert and format objects
			Adding pictures to sheets
			Adding text boxes to sheets
			Adding SmartArt graphics to sheets
			Practice tasks
		Objective review
Index
About the author
Survey page