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

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. Me.XMLSaveThroughXSLT = filename
• B. Me.XMLNodes.Add (Name:=filename, Namespace:="")
• C. Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)
• D. Me.Application.XMLNamespaces.Add (filename, uri , [alias], True)

You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

• A. control.LockContentControl = True control.LockContents = True
• B. control.LockContentControl = False control.LockContents = False
• C. control.LockContentControl = True control.LockContents = False
• D. control.LockContentControl = False control.LockContents = True

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.
void DisplayTotal ( Excel.Range rng ) { //Display total }
You write the following code segment in the startup event of the add-in.
Excel.Worksheet ws = Globals.ThisAddIn.Application .
ActiveSheet as Excel.Worksheet ;
ws.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( 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. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Previous ); }
• B. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [1]); }
• C. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.CurrentRegion ); }
• D. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [0]); }

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 Control) If control.ProductName.Equals ("Btn1") Then 'Btn1 click Else 'Btn2 click End If End Sub
• B. Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Id = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• C. Public Sub DoOperation ( ByVal control As Control) If control.Text = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub
• D. Public Sub DoOperation ( ByVal control As Office.IRibbonControl ) If control.Tag = "Btn1" Then 'Btn1 click Else 'Btn2 click End If End Sub