Internet Fixes Office 2000 News Letter

Oct 15, 2004http://internetfixes1.brinkster.net/chat!/chat.asp
 
Create a question-and-answer form using hidden text (Word 97-2000-2001-2002)
When you create quizzes, tests, and other types of Q&A forms, you'll often want to create an answer key that you can use to correct it. Instead of saving a test and its answer key as two separate files, or manually deleting the answers so you can print a clean test, you can kill two birds with one stone by putting hidden text to the task. By applying the hidden-text format to each answer, you can easily hide and display them at will. To apply the hidden-text format, select the text you'd like to hide, and then choose Format | Font from the menu bar, or press [Ctrl]D ([command]D in Word 2001). In the Font dialog box, click on the Font tab, select the Hidden check box in the Effects panel, and then click OK. When you return to your document, Word automatically hides the selected text from view. However, you can toggle its onscreen display by clicking the Show/Hide button on the Standard toolbar. When hidden text is in view, it's accompanied by a dotted underline.

Keep in mind that by default, Word doesn't print hidden text. However, you can print your answer key by enabling hidden text printing. To do so, choose File | Print from the menu bar, then click the Options button to access the Print property sheet. (Note: You can also access this property sheet by choosing Tools | Options from the menu bar (Edit | Preferences in Word 2001) and clicking on the Print tab.) Select the Hidden Text check box, and then click OK. Specify any additional printing options as desired, and then click OK to print the document and its hidden text. (Note: After you enable hidden-text printing, it remains enabled until you disable it.)
Customizing "Division by 0" Error Messages in Excel 2000
When using complex worksheets, you may have encountered that annoying "#DIV/0!" error when the divisor of your formula is a zero. Using the built-in IF function, you can create your own message for display when you divide by zero.

=IF (DIVISOR = 0,"Your Text", DIVIDED/DIVISOR)

The IF function evaluates the first parameter (DIVISOR = 0). If it's TRUE, then it places the second parameter ("Your Text") in the cell. If it's FALSE, it places the third parameter (DIVIDED/DIVISOR) in the cell.

This helps you control the message that's displayed when your formula produces a zero value that is then used to divide another value.
How to Recolor a Picture in Powerpoint
Let's suppose that you have inserted a ClipArt picture onto a PowerPoint slide. The picture is just what you want, except that the dress the cartoon woman is wearing is red and you'd rather it be green. No problem (or least, no big problem). All you have to do is right click the picture and choose Format Picture. When the Format Picture dialog box appears, click the Picture tab and then click Recolor.

When the Recolor Picture dialog box opens, click the arrows at the right side of the "New" color list boxes and select your new colors. When you finish, click OK. Back in the Format Picture dialog box, click OK again to close the dialog box and record your selections.
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers come from a Database with 42 Topics and over 8000 entries. This came from over 8 years of online help. Couple that with over 5000 documents on various subjects we have the ability to answer most of your questions.