Conventions and Features

You can save time when you use this book by understanding how the Step by Step series shows special instructions, keys to press, buttons to click, and so on.

Convention	Meaning
1	Numbered steps guide you through hands-on exercises in each topic.
2
	A round bullet indicates an exercise that has only one step.
	This icon at the beginning of a chapter lists the files that the lesson will use and explains any file preparation that needs to take place before starting the lesson.
OPEN: Practice File	Practice files that you’ll need to use in a topic’s procedure are shown.
	This icon indicates a section that covers a Microsoft Office Specialist (MOS) exam objective.
	This icon indicates a new or greatly improved feature in this version of Microsoft Excel.
Tip	This section provides a helpful hint or shortcut that makes working through a task easier.
Important	This section points out information that you need to know to complete the procedure.
Troubleshooting	This section shows you how to fix a common problem.
	When a button is referenced in a topic, a picture of the button appears in the margin area with a label.
	A plus sign (+) between two key names means that you must press those keys at the same time. For example, “Press means that you hold down the Alt key while you press Tab.
Boldface type	Program features that you click or press are shown in black boldface type.
Blue italic type	Terms that are explained in the glossary at the end of the book are shown in blue italic type within the chapter.
Blue type	Text that you are supposed to type appears in blue boldface type in the procedures.