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

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add the following method to the workbook class.
Private Sub NotifyChanges _
(ByVal Sh As Object, ByVal Target As Excel.Range)
'Notify changes
End Sub
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?

• A. AddHandler Globals.ThisWorkbook.SheetChange, _ AddressOf Me.NotifyChanges
• B. AddHandler Globals.ThisWorkbook.Application.SheetChange, _ AddressOf Me.NotifyChanges
• C. AddHandler Globals.ThisWorkbook.Application. _ SheetSelectionChange, Add ressOf Me.NotifyChanges
• D. AddHandler Globals.ThisWorkbook.SheetSelectionChange, _ AddressOf Me.NotifyChanges

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.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;
  } }
• B. 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;
  } }
• C. 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;
  } }
• D. 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;
  } }

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 publisher.
• B. Create a code group that is based on the file hash.
• C. Create a code group that is based on the network share URL.
• D. Create a code group that is based on the public token that is used to sign the assembly.

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

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy the solution. You also need to ensure that users have access to previous versions of the solution. What should you do?

• A. Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.
• B. Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.
• C. Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• D. Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and reinstall the solution.