No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. All other marks are property of their respective owners.

Microsoft and the trademarks listed at en-us.aspx are trademarks of the Microsoft group of companies. If you need support related to this book, email Microsoft Press Book Support at Please tell us what you think of this book at. First Printing Microsoft Press books are available through booksellers and distributors worldwide. Library of Congress Control Number: 2013939519 ISBN: 978-0-7356-6920-8 Printed and bound in the United States of America. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399 Copyright © 2013 by Joan Lambert All rights reserved. n experience with the techrequired to successfully pass t Certification exams. Oft Office Specialist (MOS) ion validates your proficiency rosoft Office programs, rating you can meet globally ed performance standards. Note This content also published as MOS 2013 Study Guide for Excel Available at your favorite booksellers ISBN 978-0-7356-6920-8 spine =.

Referencing cells and cell ranges in formulasĤ.3 Utilize conditional logic in functionsĤ.4 Format and modify text by using functions Objective 4: Apply formulas and functionsĤ.1 Utilize cell ranges and references in formulas and functions Objective 1: Create and manage workbooks and worksheetsġ.2 Navigate through worksheets and workbooksġ.4 Customize options and views for worksheets and workbooksġ.5 Configure worksheets and workbooks to print or save Microsoft Office Specialist certification Taking a Microsoft Office Specialist exam

Mos excel 2013