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.Areas(1)) End Sub
• B. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.CurrentRegion) End Sub
• C. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(0)) End Sub
• D. Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Previous) 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. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesBindingSource.Insert ( 0, adventureWorksDWDataSet.FactResellerSales );
• C. XLNRange.Merge ( this.Range ["A1", "B3"]);
• D. XLNRange.AutoFill ( this.Range ["A1", "B3"], Excel.XlAutoFillType.xlFillDefault );

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. doc.CachedData.FromXml(filepath);
• B. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• C. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• D. doc.CachedData.HostItems.Add(filepath);

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You customize the Ribbon user interface (UI). You add a Ribbon1.xml file to the add-in. You need to add a built-in save function to a custom tab in the Ribbon UI. Which XML fragment should you use?

• A. < customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button tag=" FileSave " / > ... < / customUI >
• B. < customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button id=" FileSave " / > ... < / customUI >
• C. < customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" xmlns:x =" MyNamespace " > ... < button idQ =" x:FileSave " / > ... < / customUI >
• D. < customUI xmlns ="http: //schemas.microsoft.com/office/2006/01/customui" > ... < button idMso =" FileSave " / > ... < / customUI >