Microsoft Excel Exam 77-420

ISBN-10: 0735669201

ISBN-13: 9780735669208

Edition: 2014

Authors: Joan Lambert

List price: $15.99 Buy it from $2.41
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the 2013 Excel Microsoft Office Specialist (MOS) exam, this all-in-one study guide features:Full, objective-by-objective exam coverage Easy-to-follow procedures and illustrations to review essential skillsHands-on practice tasks to apply what you’ve learned; files includedOnline pre-test to assess your readinessUse the in-depth exam prep, practice, and review to help advance your proficiency with Microsoft Office—and earn the credential that proves it!
Used Starting from $11.81
New Starting from $17.94
eBooks Starting from $15.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Math Online content $4.95 $1.99
Customers also bought

Book details

List price: $15.99
Copyright year: 2014
Publisher: Microsoft Press
Publication date: 8/15/2013
Binding: Paperback
Pages: 166
Size: 7.50" wide x 9.00" long x 0.50" tall
Weight: 0.660
Language: English

Joan Lambert is the author of more than a dozen books on Windows® and Office, including several popular STEP BY STEP titles from Microsoft Press®.Joyce Cox has 20+ years of experience developing training materials on technical subjects for non-technical audiences, specializing in Office and Windows® technologies.

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
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
Managing worksheets
Managing worksheet content
Managing Excel tables
Managing data entries
Create and manage workbooks and worksheets
Create workbooks and worksheets
Creating new workbooks and worksheets
Reusing existing content
Practice tasks
Navigate through worksheets and workbooks
Locating data and worksheet elements
Inserting hyperlinks
Practice tasks
Format worksheets and workbooks
Modifying page setup
Inserting page elements
Changing workbook themes and colors
Modifying rows and columns
Configuring data validation
Practice tasks
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
Configure worksheets and workbooks to print or save
Printing workbook content
Saving workbooks
Practice tasks
Objective review
Manage cells and ranges
Insert data in cells and ranges
Creating data
Reusing data
Practice tasks
Format cells and ranges
Formatting cell structure
Formatting cell content
Applying number formats
Copying formatting
Practice tasks
Order and group cells and ranges
Modeling data
Creating named ranges
Working with data groups and summaries
Practice tasks
Objective review
Manage tables
Create tables
Practice tasks
Modify tables
Practice tasks
Filter and sort tables
Practice tasks
Objective review
Apply formulas and functions
Utilize cell ranges and references in formulas and functions
Referencing cells and cell ranges in formulas
Defining order of operations
Practice tasks
Summarize data by using functions
Practice tasks
Utilize conditional logic in functions
Practice tasks
Format and modify text by using functions
Practice tasks
Objective review
Create charts and objects
Create charts
Practice tasks
Format charts
Practice tasks
Insert and format objects
Adding pictures to sheets
Adding text boxes to sheets
Adding SmartArt graphics to sheets
Practice tasks
Objective review
About the author
Survey page
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.