Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) 認定 70-543 試験問題:

1. 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.Site, Excel.Workbook) D im sheet As Excel.Worksheet = _ CType(book.Sheets((Me.Index + 1)), Excel.Worksheet) sheet.ShowAllData() End Sub
D) 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

2. You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a folder on a network share. The folder hosts 20 assemblies. All the assemblies are signed and contain the same digital signature. The add-in runs from a local computer. When the add-in is accessed from a network share by using th e same computer, a security exception is raised. You need to ensure that the add-in can run from the network share. You must achieve this goal without elevating permissions for the other assemblies. What should you do?

A) Create a code group that is based on the public token that is used to sign the assembly.
B) Create a code group that is based on the publisher.
C) Create a code group that is based on the network share URL.
D) Create a code group that is based on the file hash.

3. 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 code that customizes the Ribbon user interface (UI).
You run the add-in. The add-in does not customize the Ribbon UI and does not display an exception.
You need to display the exceptions in the user interface of the add-in when the add-in starts.
What should you do?

A) Add a new application configuration file to your project by using the following XML fragment.
<configuration> <appSettings> <add key="Debug" value="True"/> </appSettings> </configuration>
B) Add a new application configuration file to your project by using the following XML fragment.
<configuration> <appSettings> <add key="ShowErrors" value="True"/> </appSettings> </configuration>
C) Under the Word 2007 options, select the Show add-in user interface errors check box.
D) In the Configuration Manager dialog box for the add-in project, set Active Configuration to Debug.

4. 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 int GetItemCount ( Office.IRibbonControl control) { return countries.Count ; }
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 string GetItemLabel ( Office.IRibbonControl control, countries.ToString (); }

5. You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add two Text content controls named control1 and control2 to the template.
The template contains the following custom XML fragment.
< ProductList >
<Product id="1">
<Name> Chai </Name>
</Product>
<Product id="2">
<Name>Chang</Name>
</Product> </ ProductList >
You need to ensure that control1 displays the id of the Product and control2 displays the name of the Product.
Which code segment should you use?

A) control1.XMLMapping.SetMapping _ ("/ ProductList /Product/@id", "", _ Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ ProductList /Product/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))
B) control1.XMLMapping.SetMapping _ ("/ ProductList /Product/id", "", _ Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ ProductList /Product/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))
C) control1.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/@id", "", _ Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))
D) control1.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/id", "", _ Me.ActiveWindow.Document.CustomXMLParts (1)) control2.XMLMapping.SetMapping _ ("/ ProductList /Product[1]/Name", "", _ Me.ActiveWindow.Document.CustomXMLParts (1))

質問と回答：