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

1. You create an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). You create the following method in the add-in.
void DisplayTotal ( Excel.Range rng ) { //Display total }
You write the following code segment in the startup event of the add-in.
Excel.Worksheet ws = Globals.ThisAddIn.Application .
ActiveSheet as Excel.Worksheet ;
ws.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( ws_SelectionChange );
The add-in must display the sum of the values in a selected range. If multiple ranges are selected, the add-in must display only the sum of the values in the first selected range.
You need to meet the outlined requirements.
Which code segment should you use?

A) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [0]); }
B) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Previous ); }
C) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [1]); }
D) void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.CurrentRegion ); }

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 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 , ref range);
B) Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlComboBox , ref range);
C) Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlDropdownList , ref range);
D) Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlText , ref range);

4. The solution document refers to the following bugs:
bug123
Bug514
BUG512
The solution document must provide more details about a bug whenever a reference to the bug is found in the document.
You need to create a smart tag that identifies each bug.
Which code segment should you use?

A) Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") Dim regex As Regex = New Regex("[B|b][U|u][G|g]000") tag.Expressions.Add(regex)
B) Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") tag.Terms.Add("bug\d\d\d")
C) Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") tag.Terms.Add("[B|b][U|u][G|g]000")
D) Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") Dim regex As Regex = _ New Regex("bug\d\d\d", RegexOptions.IgnoreCase) tag.Expressions.Add(regex)

5. You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The actions pane of the solution document contains two user controls.
The user controls must be displayed in the following ways:
In a horizontal display, the controls must be placed next to each other.
In a vertical display, the controls must be placed one below the other.
You need to ensure that the solution meets the requirements.
Which code segment should you use?

A) void ActionsPane_OrientationChanged( object sender, EventArgs e) { if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.StackOrder = Microsoft.Office.Tools.StackStyle.FromLeft; } else { this.ActionsPane.StackOrder = Microsoft.Office.Tools.StackStyle.FromTop;
} }
B) void ActionsPane_OrientationChanged( object sender, EventArgs e) { if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.Dock = DockStyle.Left; } else { this.ActionsPane.StackOrder = (StackStyle)DockStyle.Top;
} }
C) void ActionsPane_OrientationChanged( object sender, EventArgs e) {
if (this.ActionsPane.Orientation == Orientation.Horizontal) {
this.ActionsPane.Controls[1].Dock = DockStyle.Left;
this.ActionsPane.Controls[1].Dock = DockStyle.Right;
} else {
this.ActionsPane.Controls[1].Dock = DockStyle.Top;
this.ActionsPane.Controls[1].Dock = DockStyle.Bottom;
} }
D) void ActionsPane_OrientationChanged( object sender, EventArgs e) {
if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.Controls[1].Anchor = AnchorStyles.Left; this.ActionsPane.Controls[1].Anchor = AnchorStyles.Right;
} else { this.ActionsPane.Controls[1].Anchor = AnchorStyles.Top; this.ActionsPane.Controls[1].Anchor = AnchorStyles.Bottom;
} }

質問と回答：