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

You create a custom workbook for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook contains the following data:
Static data
Data that is imported from .xml files
The workbook displays the imported data by using mapped ranges.
You need to send only the imported data to a user.
What should you do?

• A. Save the workbook as a .zip file, and then send the Workbook.xml file that is contained in the .zip file to the user.
• B. From the Developer Ribbon user interface, export the XML data as an .xml file by using the Export command. Send the .xml file to the user.
• C. From the Design Ribbon user interface, export the XML data to a Microsoft Windows SharePoint Services list by using the Export command. Send the link from the Microsoft Windows SharePoint Services list to the user.
• D. Save the workbook as an .xml file, and then send the Workbook.xml file to the user.

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized worksheet must have a button in a cell of the first row and the first column. The button must be automatically resized when the cell is resized. You need to create a button that meets the requirements. Which code segment should you use?

• A. Dim button As Button = _ Me.Controls.AddButton (1, 1, 1, 1, " MyButton ") button.Dock = DockStyle.None
• B. Dim button As Button = _ Me.Controls.AddButton (1, 1, 0, 0, " MyButton ") button.Dock = DockStyle.Fill
• C. Dim rng As Excel.Range = Me.Range ("A1") Me.Controls.AddButton ( rng , " MyButton ")
• D. Dim rng As Excel.Range = Me.Range ("A", "1") Me.Controls.AddButton ( rng , " MyButton ")

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a user control named MyUserControl.
You write the following code segment for your document class. (Line numbers are included for reference only.)
01 private void ThisDocument_Startup(object sender,
System.EventArgs e) {
02 MyUserControl userControl = new MyUserControl();
03 ...
04 }
You need to display userControl in the actions pane.
Which code segment should you insert at line 03?

• A. this.ActionsPane.Controls.Add(userControl);
• B. this.ActionsPane.Parent.Controls.Add(userControl);
• C. this.Controls.AddControl( userControl, 100, 100, 100, 100, "Action s Pane");
• D. this.ActionsPane.Controls.AddRange( new Control[] { userControl, new MyUserControl() });

You create an add-in for Microsoft Office Outlook by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must set up a WindowSelectionChange event for the Outlook e-mail messages by using Microsoft Office Word as the editor.
You write the following lines of code. (Line numbers are included for reference only.)
01 Imports Word = Microsoft.Office.Interop.Word
02 Private Sub WindowSelectionChange ( ByVal Sel As _ Word.Selection )
03 Dim ins As Outlook.Inspector = Application.ActiveInspector
04 If ins.EditorType = Outlook.OlEditorType.olEditorWord Then
05 ...
06 AddHandler app.WindowSelectionChange , AddressOf _
Me.WindowSelectionChange 07 End If 08 End Sub
You need to bind the event to the Word application object.
Which code segment should you insert at line 05

• A. Dim app As Word.Application = _ CType ( ins.WordEditor , Word.Application )
• B. Dim app As Word.Application = _ CType ( ins.CurrentItem , Word.Application )
• C. Dim app As Word.Application = _ CType ( ins.CurrentItem , Word.Document ).Application
• D. Dim app As Word.Application = _ CType ( ins.WordEditor , Word.Document ).Application