Picture Yourself Learning Microsoft Office 2010
Diane Koers
Language: English
Pages: 512
ISBN: 1598638904
Format: PDF / Kindle (mobi) / ePub
Featured in the four-color, visual Picture Yourself series, PICTURE YOURSELF LEARNING MICROSOFT OFFICE 2010 is a valuable resource for all readers, beginner to intermediate. Clear, step-by-step instructions walk you through the basics of each application from beginning to end. Helpful tips provide additional information and advice to enhance your Office 2010 experience and help meet your needs. PICTURE YOURSELF LEARNING MICROSOFT OFFICE 2010 is packed with information useful to those who have purchased their first computer and are learning Office 2010 for the first time. Those who have experience with older versions of Office will find this book an excellent way to help them get up to speed on their computing experience, by way of the over 1,000 screenshots to guide your way. You have the option of reading the book from cover to cover, or simply reading the individual programs you are interested in.
your Figure 3-2 Changing font sizes. Keyboard Shortcut The keyboard shortcut for Grow Font is Ctrl+Shift+> and for Shrink Font it’s Ctrl+Shift+<. 39 Applying Formatting Attributes Applying formatting attributes such as bold, italic, or underline calls attention to particular parts of your text. Additionally, you can assign a superscript or subscript notation to any text that makes it appear above or below the standard text, such as a copyright or trademark symbol. You can easily access these
deleting rows or columns from your table. Table 5-1 illustrates some of the different ways you can change the table size. Adjusting Column Width and Row Height When you begin typing in a cell, you saw that as you type, the text wraps to the next line in the same cell. You may find that you don’t want the data to wrap around, but the column is not wide enough to hold your data. You can easily change the width of columns or the height of rows. You can manage the task with the mouse or you can
names cannot include spaces or special characters except the underscore character (_). Now instead of scrolling through the document to locate the text, you can quickly jump to it. Click Insert>Links>Bookmark which displays the Bookmark dialog box along with a list of all the bookmarks in your document. Select the bookmark you want and click Go To. Optionally, you can get to a bookmark by using the Go To option, found on the Find and Replace dialog box. Choose Home>Editing and then click the
features. This section shows you how to get the basic data into your worksheet. Worksheet data is made up of three components: labels, values, and formulas. This section discusses entering labels and values, and you’ll learn about creating and entering formulas in Chapter 9, “Working with Formulas and Functions.” When you are ready to enter data into a worksheet cell, you must first click on the cell in which you want the information. Entering Labels Labels are traditionally descriptive pieces
Data>Data Tools and click the arrow next to Data Validation. Choose Circle Invalid Data. Excel places circles around any invalid data (see Figure 8-30). Figure 8-28 Picking from a data validation list. Tip Cells that contain invalid data may display a small green triangle in the upper-left corner. If you need to locate which cells in the worksheet contain data validation, you can tell Excel to show you which ones. You can also tell Excel to show you only the cells that contain invalid data.