Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) - 070-543 Exam Practice Test
You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a custom task pane named MyPane. MyPane is docked by default on the right of the Word application frame. You need to prevent users from changing the default docked position of MyPane. Which code segment should you use?
Correct Answer: B
Vote an answer
You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?
Correct Answer: B
Vote an answer
You create an add-in for Microsoft Office Outlook by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must set up a WindowSelectionChange event for the Outlook e-mail messages by using Microsoft Office Word as the editor.
You write the following lines of code. (Line numbers are included for reference only.)
01 Imports Word = Microsoft.Office.Interop.Word
02 Private Sub WindowSelectionChange ( ByVal Sel As _ Word.Selection )
03 Dim ins As Outlook.Inspector = Application.ActiveInspector
04 If ins.EditorType = Outlook.OlEditorType.olEditorWord Then
05 ...
06 AddHandler app.WindowSelectionChange , AddressOf _
Me.WindowSelectionChange 07 End If 08 End Sub
You need to bind the event to the Word application object.
Which code segment should you insert at line 05
You write the following lines of code. (Line numbers are included for reference only.)
01 Imports Word = Microsoft.Office.Interop.Word
02 Private Sub WindowSelectionChange ( ByVal Sel As _ Word.Selection )
03 Dim ins As Outlook.Inspector = Application.ActiveInspector
04 If ins.EditorType = Outlook.OlEditorType.olEditorWord Then
05 ...
06 AddHandler app.WindowSelectionChange , AddressOf _
Me.WindowSelectionChange 07 End If 08 End Sub
You need to bind the event to the Word application object.
Which code segment should you insert at line 05
Correct Answer: B
Vote an answer
You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add the following method to the workbook class.
void NotifyChanges (object Sh , Excel.Range Target) {
//No tify changes
}
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?
You add the following method to the workbook class.
void NotifyChanges (object Sh , Excel.Range Target) {
//No tify changes
}
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?
Correct Answer: B
Vote an answer
You create an add-in for Microsoft Office Visio by using Visual Studio Tools for the Microsoft Office System (VSTO). You install the add-in in a secure environment where local assemblies are not granted the FullTrust permission. You need to ensure that the add-in acquires the FullTrust permission after installation. What should you do?
Correct Answer: C
Vote an answer
You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains an instance of a data island named SalesDataSet. You create an instance of the CachedDataHostItemCollection object named HC in the add-in. You need to load the content from a CachedDataHostItem object in HC into SalesDataSet. Which code segment should you use?
Correct Answer: B
Vote an answer
You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will create a local database during the installation process. The add-in will extract data from the database. The add-in must be installed only on computers that have Microsoft SQL Server 2005 Express Edition. You need to configure the default setup project for the add-in. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Correct Answer: A,D
Vote an answer
You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains a NamedRange control named MyRange. MyRange is associated with cell D1. You need to change MyRange to use the cells A1 and B1. Which code segment should you use?
Correct Answer: D
Vote an answer
You create an add-in for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You install Microsoft VSTO 2005 Second Edition and Microsoft Office 2003 Professional with its default settings on computers that run Microsoft Windows XP Professional. You also install the add-in on the computers. Users report that they are unable to access the add-in. You need to configure the computers to run the add-in correctly. What should you install on the computers? (Each correct answer presents part of the solution. Choose two.)
Correct Answer: A,B
Vote an answer