Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?

A) XLNRange.AutoFill ( Me.Range ("A1", "B3"), _ Excel.XlAutoFillType.xlFillDefault )
B) XLNRange.Merge ( Me.Range ("A1", "B3"))
C) Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesTableAdapter.Update _ ( AdventureWorksDWDataSet.FactResellerSales )
D) Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesBindingSource.Insert _ ( 0, AdventureWorksDWDataSet.FactResellerSales )

2. 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) C:/Data/Data.xml
B) /Data/Data.xml
C) C:/Data/CustomXML/Item1.xml
D) /CustomXML/Item1.xml

3. You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

A) control.LockContentControl = False control.LockContents = False
B) control.LockContentControl = True control.LockContents = True
C) control.LockContentControl = True control.LockContents = False
D) control.LockContentControl = False control.LockContents = True

4. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the solution.
Dim tag As SmartTag = New _
SmartTag("http:// MySmartTag/ST#MySmartTag", "My Tag") tag.Terms.Add("Bug") tag.Terms.Add("Error") tag.Terms.Add("Issue") Dim action As Action = New Action("Add Reference") tag.Actions = New ActionBase() {action} AddHandler action.Click, AddressOf Me.action_Click
You need to add the string "Reference: " before either "Bug", "Error", or "Issue" when the smart tag is clicked.
Which code segment should you use?

A) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Text End Sub
B) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Range.XML (False).ToString() End Sub
C) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Properties.Write ( e.Range.Text , "Reference: " & e.Range.Text ) End Sub
D) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Properties.Read ("Text") End Sub

5. You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The add-in contains a Ribbon1.xml file that customizes the Ribbon user interface (UI). The Ribbon1.xml file contains the following element.
< dropDown id=" CountryCodes " getItemCount =" GetItemCount "
getItemLabel =" GetItemLabel "/>
You write the following lines of code in the add-in.
private System.Collections.ArrayList countries;
...
countries = n ew System.Collections.ArrayList () ;
countries.Add ("USA") ;
countries.Add ("JPN") ;
countries.Add ("IND"} ;
You need to bind the drop-down list to the countries collection.
Which code segments should you use? (Each correct answer presents part of the solution.
Choose two.)

A) public string GetItemLabel ( Office.IRibbonControl control, countries.ToString (); }
B) public string GetItemLabel ( Office.IRibbonControl control, (string)countries[index]; }
int index) { int index) {
return return
C) public int GetItemCount ( Office.IRibbonControl control) { return countries.Capacity ; }
D) public int GetItemCount ( Office.IRibbonControl control) { return countries.Count ; }

Solutions: