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

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. Excel.Range rng = Sheet.Range["A", "1"]; Sheet.Controls.AddButton(rng, "MyButton");
• B. Button button = Sheet.Controls.AddButton(1, 1, 1, 1, "MyButton"); button.Dock = DockStyle.None;
• C. Excel.Range rng = Sheet.Range["A1", System.Type.Missing ]; Sheet.Controls.AddButton(rng, "MyButton");
• D. Button button = Sheet.Controls.AddButton(1, 1, 0, 0, "MyButton"); button.Dock = DockStyle.Fill;

You are creating a custom workbook for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook will be used to import elements from an XML file named Expense.xml. The Expense.xml file is located in the C:\Data folder.
The schema of the Expense.xml file is stored in a file that is located at C:\Data\Expense.xsd. The schema contains the following XML fragment.
< xsd:element minOccurs ="0" maxOccurs ="unbounded" name=" ExpenseItem ">
< xsd:complexType >
< xsd:sequence >
< xsd:element name="Date" type=" xsd:date "/>
< xsd:element name="Description" type=" xsd:string "/>
< xsd:element name="Amount" type=" xsd:decimal " />
</ xsd:sequence > </ xsd:complexType > </ xsd:element >
You add the schema to the workbook by using a root element named root. You map the cells of the workbook to display the data from each element described in the XML fragment.
You need to ensure that the custom workbook validates the data against the schema.
Which code segment should you use?

• A. this.XmlMaps["root"].SaveDataSourceDefinition = true;
• B. this.XmlMaps ["root"]. ShowImportExportValidationErrors = true;
• C. Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImportXml(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);
• D. Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImport(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the
Microsoft Office System (VSTO). The add-in customizes the Ribbon user interface (UI).
The add-in contains a file named Ribbon1.xml that has the following markup for two buttons.
<button id="Btn1" onAction =" DoOperation " />
<button id="Btn2" onAction =" DoOperation " />
You need to create a callback function that runs different code for the buttons.
Which code segment should you use?

• A. Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Id = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• B. Public Sub DoOperation ( ByVal control As Control) If control.Text = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• C. Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Tag = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• D. Public Sub DoOperation ( ByVal control As Control) If control.ProductName.Equals ("Btn1") Then 'Btn1 click Else 'Btn2 click End If End Sub

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.Areas(0)) 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.Previous) End Sub

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.
Private pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub CreatePane ()
pane = Me.CustomTaskPanes.Add (New UserControl (), _
"Do Something")
pane.Visible = True
End Sub
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.NewDocument event. Private Sub Application_DocumentNew ( ByVal Doc As Word.Document ) CreatePane () End Sub
• B. Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ ( ByVal Doc As Word.Document , ByVal Wn As Word.Window ) CreatePane () End Sub
• C. Create the following event handler for the ThisAddIn.StartUp event. Private Sub ThisAddIn_Startup _ ( ByVal sender As Object, ByVal e As System.EventArgs ) CreatePane () End Sub
• D. Create the following event handler for the Application.DocumentOpen event. Private Sub Application_DocumentOpen ( ByVal Doc As Word.Document ) CreatePane () End Sub
• E. Create the following event handler for the Application.ActiveDocument.New event. Private Sub ActiveDocument_New () CreatePane () End Sub