Modify the po q4 worksheet so gridlines will print

Microsoft®

Excel 2016 Comprehensive

Boston Columbus Indianapolis New York San Francisco Hoboken Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montréal Toronto

Delhi Mexico City São Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo

Series Editor Mary Anne Poatsy Mulbery | Davidson

Series Created by Dr. Robert T. Grauer

(ex•ploring) 1. Investigating in a systematic way: examining. 2. Searching into or ranging over for the purpose of discovery.

S E R I E S

Vice President of Career Skills: Andrew Gilfillan Senior Editor: Samantha Lewis Team Lead, Project Management: Laura Burgess Project Manager: Laura Karahalis Program Manager: Emily Biberger Development Editor: Barbara Stover Editorial Assistant: Michael Campbell Director of Product Marketing: Maggie Waples Director of Field Marketing: Leigh Ann Sims Product Marketing Manager: Kaylee Carlson Field Marketing Managers: Molly Schmidt & Joanna Sabella Marketing Coordinator: Susan Osterlitz Senior Operations Specialist: Diane Peirano Senior Art Director: Diane Ernsberger Interior and Cover Design: Diane Ernsberger Cover Photo: Courtesy of Shutterstock® Images Associate Director of Design: Blair Brown Senior Product Strategy Manager: Eric Hakanson Product Manager, MyITLab: Zachary Alexander Media Producer, MyITLab: Jaimie Noy Digital Project Manager, MyITLab: Becca Lowe Media Project Manager, Production: John Cassar Full-Service Project Management: Jenna Vittorioso, Lumina Datamatics, Inc. Composition: Lumina Datamatics, Inc. Efficacy Curriculum Manager: Jessica Sieminski

Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on the appropriate page within text.

Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the documents and related graphics published as part of the services for any purpose. All such documents and related graphics are provided “as is” without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information, including all warranties and conditions of merchantability, whether express, implied or statutory, fitness for a particular purpose, title and non-infringement. In no event shall Microsoft and/or its respective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of information available from the services.

The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes are periodically added to the information herein. Microsoft and/or its respective suppliers may make improvements and/or changes in the product(s) and/or the program(s) described herein at any time. Partial screen shots may be viewed in full within the software version specified.

Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation.

Copyright © 2017 by Pearson Education, Inc. All rights reserved. Manufactured in the United States of America. This publication is protected by copyright and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms and the appropriate contacts within the Pearson Education Global Rights & Permissions department, please visit www.pearsoned.com/permissions/.

Many of the designations by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps.

Library of Congress Control Number: 2015956945

10 9 8 7 6 5 4 3 2 1

ISBN 10: 0-13-447944-0 ISBN 13: 978-0-13-447944-6

Dedications

For my husband, Ted, who unselfishly continues to take on more than his share to support me throughout the process; and for my children, Laura, Carolyn, and Teddy, whose encouragement and love have been inspiring.

Mary Anne Poatsy

I dedicate this book to three people who had a significant impact on my career. Penny Sumpter, my high school business teacher, taught me about professionalism and paying attention to details; she inspired me to become a business educator. Dr. Amanda Copeland, the department chair while I completed my bachelor’s degree, was an excellent mentor and visionary. Barbra Hoge, my first department chair at Utah Valley State College, was a strong leader and advocate for her faculty; her leadership serves as a role model for me in my capacity as department chair today.

Keith Mulbery