You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The template contains a custom XML part that consumes data from an XML source. The XML source contains the following XML fragment.
<Products> mother board, memory, hard drive,
floppy drive, DVD drive </Products>
You need to display the Products element as a comma-separated list within a paragraph of text.
Which code segment should you use?

• A. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlCombobox, range)
• B. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlText, range)
• C. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlRichText, range)
• D. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlDropdownList, range)

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy the solution. You also need to ensure that users have access to previous versions of the solution. What should you do?

• A. Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and reinstall the solution.
• B. Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• C. Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.
• D. Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.

You create a Microsoft Office Excel 2007 workbook.
You save the workbook in the C:\Data folder as an OpenXML package. You copy a file named Data.xml from the C:\Data folder to the CustomXML folder in the package. You rename the copied file to Item1.xml.
You add the following XML fragment to the Document.xml.rels file in the package.
<Relationship Id="rId1"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/CustomXML "
Target="..." />
You need to ensure that the workbook can use the custom XML document part.
Which value should you use for the Target attribute in the XML fragment?

• A. /Data/Data.xml
• B. C:/Data/CustomXML/Item1.xml
• C. /CustomXML/Item1.xml
• D. C:/Data/Data.xml

You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in has a custom task pane named MyPane. MyPane contains a user control named MyUserControl. You write the following method that resizes MyUserControl.
Public Sub ResizeControls ()
...
End Sub
You need to call the ResizeControls method when MyPane is not docked to the Excel 2007 application window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Add the following method to the add-in. Private Sub DockChanged ( ByVal sender As Object, _ ByVal e As EventArgs ) If MyPane.DockPosition = _ MsoCTPDockPosition.msoCTPDockPositionFloating Then ResizeControls () End If End Sub
• B. Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.DockPositionChanged , AddressOf Me.DockChanged
• C. Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.Control.DockChanged , AddressOf Me.DockChanged
• D. Add the following method to the add-in. Private Sub DockChanged ( ByVal sender As
  Object, _ ByVal e As EventArgs ) If MyPane.Control.Dock = DockStyle.None Then ResizeControls () End If End Sub