Questions and Answers

Lesson 1 Review

Page 6-11

1.	A user wants you to install Office Professional Edition 2003 on his computer. He uses Windows XP Home Edition and has a Pentium III processor, 512 MB of RAM, 40 GB of free hard disk space, and a generic plug-and-play Super VGA monitor capable of 800 x 600 resolution. Which of the following upgrades (if any) will be needed so that the program will run well (thus meeting recommended requirements)? (Choose all that apply.) Upgrade from Windows XP Home Edition to Windows XP Professional Edition. Upgrade to a Pentium 4 or equivalent. Add more RAM. Partition the hard disk into two 20-GB sections. Office cannot work with large disk drives. Install Service Packs 1 and 2. Upgrade to a flat-screen monitor or a monitor with resolution that can be configured at 1024 x 768. Nothing needs to be upgraded.
2.	Which of the following types of software would it be safe to run under Windows XP, using an application compatibility mode? A game that was written for Windows 95 Backup software that was written for Windows 98 Disk partitioning software that was written for Windows 2000 Antivirus software that was written for Windows 2000

Answers

1.	G is the correct answer. A, B, C, D, E, and F all meet recommended requirements.
2.	A is the only correct answer. B, C, and D are incorrect because you should never use a program compatibility mode to force system tools (such as antivirus or CD-burning software) that are written for another operating system to work under Windows XP.

Lesson 2 Review

Page 6-21

1.

The following table lists some common installation problems and their causes. To answer this question, match the installation problem on the left with the likely cause on the right.

1. The program installed correctly but fails online activation.	A. The program was probably downloaded from the Internet, and the download was not successful.
2. The error Can’t Copy File To Disk prevents installation from starting or completing.	B. The computer does not meet minimum hardware requirements.
3. The installation of the program stops, and an error message appears that states that some of the downloaded files are missing or corrupt.	C. An antivirus program is running.
4. Installation stops, hangs, or quits.	D. There might be a typographical error created by the user.
5. The validation code will not validate the software.	E. The program has already been installed on another computer, and licensing restrictions and requirements are preventing the successful installation of the program.

Answers

1.

1. E is correct. Programs that have been installed on another computer can sometimes be installed on a second computer, but activation will fail if licensing restrictions are imposed. 2. C is correct. Running antivirus programs while installing programs can cause these errors. 3. A is correct. Missing or corrupt file errors are usually caused by bad CDs or problematic downloads. 4. B is correct. When an installation hangs or quits, it is generally because of problems with the computer’s hardware, especially RAM or processors. 5. D is correct. Many validation code or product ID errors are caused because the user did not type the correct code.

Lesson 3 Review

Page 6-35

1.	An employee in the marketing department of your company works in Excel most of the day, but she spends an equal amount of time on the Internet. There she obtains product information and competitor prices from websites to create quotes. She is also pretty new to Excel and often has to access the Help and Support files. You want to help her work faster and smarter. What can you suggest? (Choose all that apply.) Add the Web toolbar to Excel. Customize the toolbars, and reset the menu and toolbar usage data. Add the Task pane to the Excel interface. Add the Formula Auditing toolbar to Excel.
2.	An employee in the graphics department of your company uses Microsoft Office PowerPoint Professional Edition 2003 to create documentation for company meetings with prospective clients. He reports that when he accesses a font from the font drop-down list on the Formatting toolbar, all of the fonts are listed, but he cannot tell what the font looks like by looking at it in the list. He would like the list of fonts to appear using the font that each item in the list represents. For instance, Arial uses Arial font, Century uses Century font, Lucida Sans uses Lucida Sans font, and so on. Is this possible, and if so, what needs to be done? It is not possible. It is possible only if the Microsoft Advanced Font Add-In is downloaded and installed. It is an option in the Customize dialog box on the Options tab. It is an option on the Fonts toolbar.
3.	A user reports that each time she opens Word 2003, the Startup Pane appears, and each time she clicks the X in the upper right corner of the pane to close it. She wants to avoid this extra step each time she opens Word and wants to configure the pane so that it does not open every time she opens the program. What do you tell her to do? (Select all correct procedures.) With Word open, click View, and clear the Task Pane command. With Word open, click View, point to Toolbars, and clear Task Pane. In the Task pane, click the X in the upper right corner. Click View, point to Toolbars, and verify that Task Pane is cleared. Click Tools, click Options, and on the View tab, clear the Startup Task Pane check box.

Answers

1.	A and C are correct. Adding the Web toolbar to Excel will allow the employee to access Favorites, the home page, previously visited sites, and hyperlinks within Excel. Adding the Task pane will offer a place for the employee to get help quickly from Microsoft Office Online. B will only reset the toolbars to their defaults and will not show the Web toolbar or offer help and support faster than before. D provides a toolbar used to circle invalid data and evaluate formulas, and it is not appropriate here.
2.	C is correct. Fonts can be shown in the fonts list. A is incorrect because C is correct. B is not a valid downloadable application. D is not correct because there is no Fonts toolbar.
3.	D is the correct answer. A and B will close the Task pane only temporarily, but the Task pane will open again when Word is restarted. C is incorrect because this will close the Task pane only during the current session.

Lesson 4 Review

Page 6-46

1.

You support end users who create documents in Word 2003 on computers running Windows XP Professional. They often call with problems relating to proofing, editing, and summarizing documents. Common service calls are listed on the left; match them with the appropriate solution on the right.

1. A user is late for a meeting and needs to create a cheat sheet containing the main points in the document he received last week. What should he do?	A. Configure AutoCorrect.
2. A user confides in you that she is not a good speller and that she always misspells the same words over and over. Instead of right-clicking and choosing the correct spelling of these words time after time, she would like to know if she can set Word 2003 to automatically correct these words each time she misspells them. What should she do?	B. Configure AutoFormat.
3. A user creates documents that contain hyperlinks to network resources. These documents are posted on the company’s internal website, and users access them when they need help and support. The user complains that he has to manually create the hyperlinks and wants Word to create them automatically. What should he do?	C. Use AutoSummarize, and create a summary that highlights the key points.
4. A user is writing a children’s book, and several of the words she is using are not real words. She wants to add these words to the dictionary because the underlining throughout the document makes it hard to concentrate. What should she do?	D. Configure spelling options on the Spelling & Grammar tab.

Answers

1.

1. C is correct. AutoSummarize can be used to highlight and list the main points in a document. 2. A is correct. AutoCorrect can be configured so that misspelled words (when repeatedly misspelled) are corrected automatically. 3. B is correct. AutoFormat options can be set so that hyperlinks are automatically created. 4. D is correct. One of the spelling options is Hide Spelling Errors In This Document.

Case Scenario Exercises: Scenario 6.1

Page 6-48

1.

The company you work for is named Contoso Pharmaceuticals. Users complain that every time they create a document in Word, PowerPoint, Excel, or another Microsoft Office application, the company name is underlined because it is believed to be misspelled. Users want this behavior to stop. In addition, users want the entire company name typed automatically each time they type in the first few letters of it. They are tired of typing the words Contoso Pharmaceuticals every time they want to type the company name. What should you tell each user in the company to do?

1. Add the word Contoso to the dictionary. Add Contoso Pharmaceuticals to the AutoText list.

2. Add the word Contoso to the AutoText list. Add Contoso Pharmaceuticals to the AutoCorrect list.

3. Add both Contoso and Pharmaceuticals to the AutoCorrect list.

4. Add both Contoso and Pharmaceuticals to the AutoText list.

Answers

1.

A is the only correct answer. Adding Contoso to the dictionary will prevent the word from appearing misspelled in documents. Adding Contoso Pharmaceuticals to the AutoText list will cause it to be automatically offered after the first few letters of the company name are typed. The others are incorrect because AutoCorrect is used to correct misspelled words as a user types, and AutoText is used to automatically offer suggestions for the text typed.

Case Scenario Exercises: Scenario 6.2

Page 6-48

1.

A small business owner wants you to install Microsoft Office Professional Edition 2003 on the computers in his office. He reports that he has 10 computers, 3 of which use Windows 98, 2 of which use Windows Me, and 5 that use Windows XP Professional. They are configured as a workgroup. Each of these computers runs Microsoft Office 2000. He purchased five Microsoft Office CDs because a friend told him that he installed his Microsoft Office CD on his desktop PC and his laptop, and they both run like a charm. He figures he will just use the five CDs to install Office Professional Edition 2003 on the 10 computers. Where is the flaw in his logic? (Pick two.)

1. There is a problem with the licensing requirements. Although a user can install Office Professional Edition 2003 on a desktop PC and a laptop, it cannot be installed on two different computers for two different users.

2. Office Professional Edition 2003 can only be installed on computers running Windows XP.

3. Office Professional Edition 2003 cannot be installed on the computers running Windows 98 or Windows Me.

4. Office Professional Edition 2003 cannot be installed on workgroup computers, only on computers in a domain. He will need to purchase Microsoft Office Standard Edition 2003.

Answers

1.

A and C are correct. A correctly describes the licensing agreement, and C correctly describes the operating systems on which the Office System can be installed. B is incorrect because the Office System can be installed on a computer running Windows 2000 (Service Pack 3). D is incorrect because all Microsoft Office editions can be installed on computers, no matter their network configuration.

Troubleshooting Lab

Page 6-49

1.

The accounting group at a company named Contoso often has to collaborate on documents created in Excel. The documents are financial and laden with XY scatter charts, line graphs, and flow charts. One of your users wants to create a custom menu named Charting to assist with creating and editing these items and has asked for your help.

Furthermore, accounting group members collaborate in groups on the documents. They need to be able to save and load documents from a network share. To keep strict track of what document is being worked on by whom and when, they check the documents in and out. The user would like your help creating a custom toolbar named Collaboration that contains the Check In and Check Out, Send For Review, and Reply With Changes commands.

Note

The answer that follows is just a sample; the answer can vary.

Answers

1.

In this sample answer, a Charting menu was created with the graphing and flow chart functions that are commonly used. Figure 6-21 shows this menu with Flowchart selected.

Figure 6-21: Use the Charting custom menu with Flowchart selected.

Also, a custom toolbar was created with the Check In, Check Out, Send For Review, and Reply With Changes commands, as shown in Figure 6-22.

Figure 6-22: The custom Collaboration toolbar is a sample solution.