Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) : 070-543 Exam

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution contains a DataRow named custrow. A serialization of custrow contains the following XML fragment.
< ClientProjects >
...
< description > Upgrade from Windows XP < /description >
... < / ClientProjects >
The solution will create an XMLNode control named ProjectDescriptionNode in a Word document.
You need to ensure that the text in the description element is displayed as unformatted text.
Which code fragment should you use?

• A. ProjectDescriptionNode.NodeValue = _ custrow("description").ToString()
• B. ProjectDescriptionNode.PlaceholderText = _ custrow("description").ToString()
• C. ProjectDescriptionNode.Text = _ custrow("description").ToString()
• D. ProjectDescriptionNode.NodeText = _ custrow("description").ToString()

You create an add-in for a Microsoft Office Outlook application by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a reference to an Outlook folder in a variable named folder. You need to process only the e-mail messages within the folder. Which code segment should you use?

• A. For Each item As Object In folder.Items If TypeOf item Is Outlook.MailItem Then 'Process mail End If Next
• B. For Each item As Outlook.MailItem In folder.Items If item.Class = Outlook.OlObjectClass.olMail Then 'Process mail End If Next
• C. For Each item As Outlook.MailItem In folder.Items 'Process mail Next
• D. For Each item As Object In folder.Items If CType (item, Outlook.MailItem ).Class = _ Outlook.OlObjectClass.olMail Then 'Process mail End If Next

You are creating a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains five worksheets. You add a LinkLabel control named Label to the first worksheet of the workbook. You need to create a LinkClicked event handler that displays the next worksheet in the workbook. Which code segment should you use?

• A. Private Sub Label_LinkClicked(ByVal sender As Object, _ ByVal e As LinkLabelLinkClickedEventArgs) Dim book As Excel.Workbook = CType(Me.Parent, Excel.Workbook) Dim sheet As Excel.Worksheet = _ CType(book.Sheets((Me.Index + 1)), Excel.Worksheet) sheet.ShowAllData() End Sub
• B. Private Sub Label_LinkClicked(ByVal sender As Object, _ ByVal e As LinkLabelLinkClickedEventArgs) Dim book As Excel.Workbook = CType(Me.Site, Excel.Workbook) Dim sheet As Excel.Worksheet = _ CType(book.Sheets((Me.Index + 1)), Excel.Worksheet) s heet.Activate() End Sub
• C. Private Sub Label_LinkClicked(ByVal sender As Object, _ ByVal e As LinkLabelLinkClickedEventArgs) Dim book As Excel.Workbook = CType(Me.Parent, Excel.Workbook) Dim sheet As Excel.Worksheet = _ CType(book.Sheets((Me.Index + 1)), Excel.Worksheet) sheet.Activate() End Sub
• D. Private Sub Label_LinkClicked(ByVal sender As Object, _ ByVal e As LinkLabelLinkClickedEventArgs) Dim book As Excel.Workbook = CType(Me.Site, Excel.Workbook) D im sheet As Excel.Worksheet = _ CType(book.Sheets((Me.Index + 1)), Excel.Worksheet) sheet.ShowAllData() End Sub

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.wdContentControlDropdownList, range)
• D. Application.ActiveDocument.ContentControls.Add _ (WdContentControlType.wdContentControlRichText, 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 contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. doc.CachedData.HostItems.Add(filepath);
• B. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• C. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• D. doc.CachedData.FromXml(filepath);