You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application modifies a Microsoft Office Excel custom workbook. The custom workbook displays the data that is contained in an XML file named Salesorder.xml. The Salesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both the Salesorder.xml file and the Salesorder.xsd file are located in the C:\Data folder. You need to ensure that the data in the Salesorder.xml file is available for mapping. Which code segment should you use?

• A. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• B. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• C. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• D. Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);

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.)

• A. Microsoft .NET Framework 2.0
• B. Microsoft Office 2003 Primary Interop Assemblies
• C. Microsoft .NET Framework 1.1
• D. Microsoft Visual Studio 2005

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.
Private Sub NotifyChanges _
(ByVal Sh As Object, ByVal Target As Excel.Range)
'Notify changes
End Sub
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?

• A. AddHandler Globals.ThisWorkbook.SheetSelectionChange, _ AddressOf Me.NotifyChanges
• B. AddHandler Globals.ThisWorkbook.SheetChange, _ AddressOf Me.NotifyChanges
• C. AddHandler Globals.ThisWorkbook.Application. _ SheetSelectionChange, Add ressOf Me.NotifyChanges
• D. AddHandler Globals.ThisWorkbook.Application.SheetChange, _ AddressOf Me.NotifyChanges

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in customizes the Ribbon user interface (UI). The add-in contains a file named Ribbon1.xml that has the following markup for two buttons.
<button id="Btn1" onAction =" DoOperation " />
<button id="Btn2" onAction =" DoOperation " />
You need to create a callback function that runs different code for the buttons.
Which code segment should you use?

• A. public void DoOperation ( Office.IRibbonControl control) { if ( control.Tag == "Btn1") { //Btn1 click } else { //Btn2 click } }
• B. public void DoOperation ( Office.IRibbonControl control) { if ( control.Id == "Btn1") { //Btn1 click } else { //Btn2 click } }
• C. public void DoOperation (Control control ) { if ( control.Text == "Btn1") { //Btn1 click } else { //Btn2 click } }
• D. public void DoOperation (Control control ) { if ( control.ProductName.Equals ("Btn1")) { //Btn1 click } else { //Btn2 click } }