Share
eBooks from Joan Lambert
All books and eBooks by Joan Lambert:
MOS 2010 Study Guide for...
by Joan Lambert and Joyce Cox
Taking a Microsoft Office Specialist Exam Desktop computing proficiency is increasingly important in today’s business world. As a result, when screening, hiring, and training employees, employers can feel reassured by relying on the objectivity and consistency of technology certification to ensure the competence of their workforce. As an employee or job seeker, you can use technology certification to prove that you already have the skills you need to succeed, saving current and future employers the trouble and expense of training you. Microsoft Office Specialist Certification Microsoft Office Specialist certification for Microsoft Office 2010 is designed to assist employees in validating their skills with programs in the Office 2010 software suite. The following certification paths are available: ● A Microsoft Office Specialist (MOS) is an individual who has demonstrated proficiency by passing a certification exam in one or more of the Office 2010 programs, including Microsoft Word, Excel, PowerPoint, Outlook, and
(2011)
MOS 2010 Study Guide for...
by Joan Lambert and Joyce Cox
Taking a Microsoft Office Specialist Exam Desktop computing proficiency is increasingly important in today’s business world. As a result, when screening, hiring, and training employees, employers can feel reassured by relying on the objectivity and consistency of technology certification to ensure the competence of their workforce. As an employee or job seeker, you can use technology certification to prove that you already have the skills you need to succeed, saving current and future employers the trouble and expense of training you. Microsoft Office Specialist Certification Microsoft Office Specialist certification for Microsoft Office 2010 is designed to assist employees in validating their skills with programs in the Office 2010 software suite. The following certification paths are available: ● A Microsoft Office Specialist (MOS) is an individual who has demonstrated proficiency by passing a certification exam in one or more of the Office 2010 programs, including Microsoft Word, Excel, PowerPoint, Outlook, and
(2011)
MOS 2010 Study Guide for...
by Joan Lambert and Joyce Cox
Taking a Microsoft Office Specialist Exam Desktop computing proficiency is increasingly important in today’s business world. As a result, when screening, hiring, and training employees, employers can feel reassured by relying on the objectivity and consistency of technology certification to ensure the competence of their workforce. As an employee or job seeker, you can use technology certification to prove that you already have the skills you need to succeed, saving current and future employers the trouble and expense of training you. Microsoft Office Specialist Certification Microsoft Office Specialist certification for Microsoft Office 2010 is designed to assist employees in validating their skills with programs in the Office 2010 software suite. The following certification paths are available: ● A Microsoft Office Specialist (MOS) is an individual who has demonstrated proficiency by passing a certification exam in one or more of the Office 2010 programs, including Microsoft Word, Excel, PowerPoint, Outlook, and
(2011)
Windows Vista™ Step by Step
by Joan Lambert and Joyce Cox
Setting Up Speakers 157 Setting Up Speakers Computer systems that are equipped with sound cards usually come with a set of exter nal speakers so that you can listen to music and other audio files. Some monitors come with built-in speakers that take the place of external speakers. If you’re a real audiophile, you might want to purchase fancy surround-sound speakers for your computer. Or if you want to listen to audio output privately, you can connect headphones either directly to your computer or through the external speakers. Most standard speaker systems consist of two speakers with one cord that connects them to each other, another that connects them to the computer, and a power cord that con nects them to the power source. One speaker might have a volume control (independent of the computer’s volume control) and a headset jack. In this exercise, you will connect speakers to your
(2009)
Windows Vista® Step by S...
by Joyce Cox and Joan Lambert
218 Chapter 6 Safely and Efficiently Accessing the Internet 13. Click any of the links in the Product Families list. Content Advisor again restricts you from displaying the page. Obviously, this type of constant restriction can be quite irritating. After you view a few other Web sites with your criteria in place, you might want to make adjustments to the Content Advisor settings to fine-tune the way it works. 14. To disable Content Advisor, click Internet Options on the Tools menu, and on the Content tab of the Internet Options dialog box, click Disable. To prevent other people from changing the restrictions you have set on your com- puter, after activating Content Advisor, you must enter the supervisor password to change its settings or disable it. 15. In the Supervisor Password Required message box, type P@ssw0rd in the Password box, and then click OK. If a message box notifies you
(2009)
Microsoft® Office Word 2...
by Joyce Cox and Joan Lambert
15 Chapter 6 Working with Graphics, Symbols, and Equations In this chapter, you will insert and modify pictures, create WordArt objects, and draw shapes to create a simple picture. You will modify the text-wrapping, position, and stacking order of pictures in a document. Finally, you will also insert a symbol and build a simple equation. See Also Do you need only a quick refresher on the topics in this chapter? See the Quick Reference section at the beginning of this book. Important Before you can use the practice files in this chapter, you need to install them from the book’s companion CD to their default location. See “Using the Companion CD” at the beginning of this book for more information. Troubleshooting Graphics and operating system–related instructions in this book reflect the Windows Vista user interface. If your computer is running Windows XP and you experi- ence trouble following the instructions
(2009)
Microsoft® Office Publis...
by Joyce Cox and Joan Lambert
Creating Calendars 85 After you choose a calendar template in the Getting Started window, you can specify whether each calendar page displays a month or a year, and which months or years the calendar includes. (If you don't select a year, Publisher creates a calendar for the current year.) Publisher creates a calendar consisting of one page specific to each month or year in the selected range. For example, setting a starting month of January and an ending month of June of the same year produces a six-page publication. You can also add a Schedule Of Events section, which is a text box next to the calendar grid on each page in which you can insert information. You can change the text box header to represent information other than events. See Also You can insert a one-month calendar object from the Design Gallery into any type of publication. For information,
(2009)
Microsoft® Office 2008 f...
by Joan Lambert
226 Chapter 7 Work with Word Document Content To insert the current date or time into a Word document: 1. On the Insert menu, click Date and Time. 2. In the Date and Time dialog box, under Available formats, click the date and/or time format you want. 3. To insert the date or time as a field rather than as static text, select the Update automatically check box. 4. Click OK. If you selected Update Automatically, Word inserts the current information as a field. When you click information that is stored in a field, gray highlighting appears, to indicate the extent of the field. To display the codes that control the information displayed in a field: ➜ Right-click the field, and then click Toggle Field Codes. Codes such as those shown here control the display and formatting of the date and time in a field. From the Field dialog
(2009)
Windows® 7 Step by Step
by Joan Lambert and Joyce Cox
Working with Tabs and Pages 221 5. In the Address box, replace www.otsi with movies.msn. Then press Alt+Enter to open the specified Web site on a new tab. Internet Explorer opens a new tab and submits the URL. Optional Compatibility View button Refresh button Internet Explorer displays the MSN Movies site on the new tab. 6. Click the Start button (or press the Windows logo key). When the Start menu opens, the cursor is already in the Start menu Search box in the lower-left corner of the menu. 7. In the Start menu Search box, type http:// money.msn.com. Then press Enter. The home page of the MSN Money site opens on a new tab of the existing Internet Explorer window. Tip Internet Explorer records the Web sites you visit on the History tab of your Favorites Center so that you can easily locate a site you have previously viewed. You
(2009)
Microsoft® Office Home a...
by Joyce Cox, Curtis Frye, and Joan Lambert
182 Chapter 7 Performing Calculations on Data When you click a named range, Excel 2007 displays the cells it encompasses in the Refers To field. Clicking the Edit button displays the Edit Name dialog box, which is a version of the New Name dialog box, enabling you to change a named range’s definition. You can also get rid of a name by clicking it, clicking the Delete button, and then clicking OK in the confirmation dialog box that opens. Important If your workbook contains a lot of named ranges, you can click the Filter button in the Name Manager dialog box and select a criterion to limit the names displayed in the Name Manager dialog box. In this exercise, you will create named ranges to streamline references to groups of cells. USE the VehicleMiles workbook. This practice file is located in the Documents\Microsoft Press\2007OfficeSBS_HomeStudent\ExcelFormulas folder. BE SURE TO start
(2009)
Microsoft® Certified App...
2007 Microsoft Office System Edition
by Joyce Cox and Joan Lambert
366 Exam 77-603 Using Microsoft Office PowerPoint 2007 ➤ To set the autofit behavior of the selected text box 1. Display the Text Box page of the Format Shape dialog box. 2. In the Autofit area, click the option you want, and then click Close. ➤ To set margins in the selected text box 1. Display the Text Box page of the Format Shape dialog box. 2. In the Internal margin area, adjust Left, Right, Top, and Bottom settings, and then click Close. ➤ To flow text in columns in the selected text box 1. Display the Text Box page of the Format Shape dialog box, and then click Columns. 2. In the Columns dialog box, adjust the Number and Spacing settings, click OK, and then click Close. See Also For information about character and paragraph formatting, see section 2.2, “Manipulate text.” See also Exam 77-601, section 2.1, “Format text
(2009)
Microsoft® Office Access...
by Steve Lambert, M. Lambert, and Joan Lambert
124 Chapter 5 Simplifying Data Entry by Using Forms 22. Scroll through a couple of records, and then click the combo box arrow to display the country list. 23. You don’t need the record selector—the gray bar along the left edge of the form—for this exercise, so return to Design view and display the Property Sheet pane for the entire form by clicking the Form selector (the box at the junction of the horizontal and vertical rulers) and pressing $ (if the sheet is not already dis- played). Then on the Format tab, change Record Selectors to No, and Scroll Bars to Neither. Then press $ again to close the Property Sheet pane. 24. Save the form’s new design, and then switch to Form view for a final look. CLOSE the AddControls database. Entering Data in a Form by Using VBA As you might suspect by now, almost everything in
(2009)
2007 Microsoft® Office S...
by Joyce Cox, Curtis Frye, M. Lambert, Steve Lambert, John Pierce, and Joan Lambert
13 Starting a New Presentation In this chapter, you will learn to: Quickly create a presentation. Create a presentation based on a ready-made design. Convert an outline to a presentation. Reuse existing slides. To work efficiently with Microsoft Office PowerPoint 2007, you must be able to decide the best way to start a presentation. The New Presentation window provides several options for creating a new presentation: If you need help with both the presentation’s content and its look, you can down- load a complete presentation from Microsoft Office Online and then customize it to meet your needs. If you have already created a presentation that is close enough in content and design to be a good starting point, you can use that presentation as the basis for the new one. If you have content ready but need help with the look of the presentation, you can base your presentation on
(2009)
Microsoft® Office PowerP...
by Joyce Cox and Joan Lambert
Inserting and Modifying Clip Art Images 119 6. On the Insert tab, in the Illustrations group, click the Clip Art button. The Clip Art task pane opens. 7. At the bottom of the task pane, click the Clip art on Office Online link. Your default Web browser opens and displays the Office Online Clip Art resource page. The following steps are for Windows Internet Explorer 7; if you are using a different Web browser, the steps might be slightly different but you should be able to follow along. Troubleshooting If you are not connected to the Internet, click Go to search your computer for clip art identified by the keyword concepts. concepts. . In the Search box on the Clip Art tab, type concepts, and then click the Search button. Office Online displays hundreds of clip art images associated with the word concepts. 9. Move through the pages by clicking
(2009)
