Pass with 70-543 Practice Materials 100% for sure

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.
Private Sub DisplayTotal(ByVal rng As Excel.Range) 'Display total End Sub
You write the following code segment in the startup event of the add-in.
Dim ws As Excel.Worksheet = CType _ (Globals.ThisAddIn.Application.ActiveSheet, Excel.Worksheet)
AddHandler ws.SelectionChange, AddressOf Me.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. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.CurrentRegion) End Sub
• B. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Previous) End Sub
• C. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(1)) End Sub
• D. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(0)) End Sub

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. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesTableAdapter.Update ( adventureWorksDWDataSet.FactResellerSales );
• B. XLNRange.AutoFill ( this.Range ["A1", "B3"], Excel.XlAutoFillType.xlFillDefault );
• C. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesBindingSource.Insert ( 0, adventureWorksDWDataSet.FactResellerSales );
• D. XLNRange.Merge ( this.Range ["A1", "B3"]);

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="false"/ >
• B. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• C. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• D. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >

You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must be installed on 100 computers that run Windows Vista and Microsoft Office 2007 Professional Edition. You need to configure the computers to run the add-in. What should you install on the computers?

• A. Microsoft .NET Framework 1.1
• B. Microsoft .NET Framework 2.0
• C. Microsoft Office Primary Interop Assemblies
• D. Microsoft VSTO Runtime

You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?

• A. Delete the item1.xml file.
• B. Create a file named itemProps2.xml that marks the item2.xml file as a data store.
• C. Delete the itemProps1.xml file.
• D. Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.