Microsoft 70-543 Exam : 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). 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.Merge ( Me.Range ("A1", "B3"))
• B. Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesTableAdapter.Update _ ( AdventureWorksDWDataSet.FactResellerSales )
• C. XLNRange.AutoFill ( Me.Range ("A1", "B3"), _ Excel.XlAutoFillType.xlFillDefault )
• D. Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesBindingSource.Insert _ ( 0, AdventureWorksDWDataSet.FactResellerSales )

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). A transformation file is used to convert the solution document to an HTML file. The path to the transformation file is stored in a variable named filename. The Uniform Resource Identifier (URI) is stored in a variable named uri. An optional alias is stored in a variable named alias. You need to ensure that the solution document uses the transformation file that the user provides. Which code segment should you use?

• A. this.XMLSchemaReferences.Add (ref uri , ref alias, ref filename, true);
• B. this.XMLNodes.Add ((string)filename, "", ref missing);
• C. this.Application.XMLNamespaces.Add ((string)filename, ref uri , ref alias, true);
• D. this.XMLSaveThroughXSLT = (string)filename;

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Microsoft.Office.Tools.CustomTaskPane pane;
private void CreatePane () {
pane = this.CustomTaskPanes.Add (new MyUserControl (),
"Do Something");
pane.Visible = true;
}
You need to ensure that only a single instance of the custom task pane is displayed in each single document interface (SDI) window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Create the following event handler for the Application.DocumentOpen event. void Application_DocumentOpen ( Word.Document Doc) { CreatePane (); }
• B. Create the following event handler for the Application.NewDocument event. void Application_DocumentNew ( Word.Document Doc) { CreatePane (); }
• C. Create the following event handler for the Application.ActiveDocument.New event. void ActiveDocument_New () { CreatePane (); }
• D. Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Word.Document Doc, Word.Window Wn ) { CreatePane (); }
• E. Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }

You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You will use Microsoft Visual Studio 2005 Bootstrapper to install the add-in.
The Product.xml file for the Bootstrapper contains the following XML fragment. (Line numbers are included for reference only.)
01 < InstallChecks >
02 < AssemblyCheck Property="VSTORInstalled"
03 Name="Microsoft.Office.Tools.Common"
04 PublicKeyToken="b03f5f7f11d50a3a" Version="8.0.0.0"/ >
05 < /InstallChecks >
0 6 < Commands Reboot="Defer" >
07 < Command PackageFile="vstor.exe" >
08 < InstallConditions >
09 ...
10 < /InstallConditions > 11 < /Command > 12 < /Commands >
You need to ensure that Microsoft VSTO Runtime is installed on the target computers.
Which XML fragment should you insert at line 09?

• A. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• B. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >
• C. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >
• D. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >

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