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.wdContentControlRichText, range)
• B. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlDropdownList, range)
• C. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlCombobox, range)
• D. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlText, range)

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

• A. Add a script to the Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
• B. Add a script to the File System Editor to install the local database.
• C. Add a script to the Custom Actions Editor to install the local database.
• D. Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.
• E. Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The Excel workbook contains a worksheet object named Sheet1 that contains data in the range A1 through A5.
You write the following lines of code for the Sheet1 object. (Line numbers are included for reference only.)
01 Dim bMark As Word.Bookmark
02 Dim doc As Word.Document = New Word.Application() ...
03 Dim index As Object = 1
04 Dim bMark As Word.Bookmark = do c.Bookmarks.Item(index)
05 ...
You need to insert the data from the range A1 through A5 into a Microsoft Office Word document after bMark. Your solution must retain the sequence of the data that is inserted.
Which code segment should you insert at line 05?

• A. Dim rng As Excel.Range = Me.Range("A1", "A5") Dim temp As String = "" For Each r As Excel.Range In rng.Rows temp = temp & r.Text.ToString() Next bMark.Range.Text = temp
• B. Dim rng As Excel.Range = Me.Range("A1", "A5") For Each r As Excel.Range In rng.Cells bMark.Range.InsertAfter(r.Value2.ToString()) Next
• C. Dim rng As Excel.Range = Me.Range("A2", "A5") bMark.Range.Text = Me.Range("A1").Value2.ToString() For Each r As Excel.Range In rng.Rows bMark.Range.InsertAfter(r.Value2.ToString()) Next
• D. Dim rng As Excel.Range = Me.Range("A1", "A5") Dim temp As String = "" For Each r As Excel.Range In rng.Cells temp = temp & r.Value2.ToString() Next bMark.Range.InsertAfter(temp)

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?

• A. string di = HC[0].CachedData[0].DataType.ToString(); using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.Reset(); }
• B. string di = HC[0]. CachedData [0]. DataType.GetType ().ToString(); using ( System.IO.StringReader rdr = new System.IO.StringReader ( di )) { northwindDataSet.ReadXml ( rdr ); northwindDataSet.Reset (); }
• C. string di = HC[0].CachedData[0].Xml; using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.AcceptChanges(); }
• D. string di = HC[0].CachedData[0].GetType().ToString(); using (System.IO.StringReader rdr = new System.IO.StringReader(di)) { northwindDataSet.ReadXml(rdr); northwindDataSet.AcceptChanges(); }