Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. 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.Previous) End Sub
D) Private Overloads Sub ws_SelectionChange _ (ByVal Target As Excel.Range) DisplayTotal(Target.Areas(0)) End Sub

2. You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will create a local database during the installation process. The add-in will extract data from the database. The add-in must be installed only on computers that have Microsoft SQL Server 2005 Express Edition. You need to configure the default setup project for the add-in. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.
B) Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
C) Add a script to the Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
D) Add a script to the Custom Actions Editor to install the local database.
E) Add a script to the File System Editor to install the local database.

3. 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) 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.
B) 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.
C) Save the workbook as an .xml file, and then send the Workbook.xml file to the user.
D) Save the workbook as a .zip file, and then send the Workbook.xml file that is contained in the .zip file to the user.

4. 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) this.XMLSaveThroughXSLT = (string)filename;
B) this.XMLNodes.Add ((string)filename, "", ref missing);
C) this.Application.XMLNamespaces.Add ((string)filename, ref uri , ref alias, true);
D) this.XMLSchemaReferences.Add (ref uri , ref alias, ref filename, true);

5. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customization contains a predefined schema to validate the data that users add. The path to the schema is stored in a variable named filename. The Unique Resource Identifier (URI) for the schema is stored in a variable named uri. The alias for the schema is stored in a variable named alias.
You need to ensure that the schema that the user selects is applied to the solution document. Which code segment should you use?

A) Me.Application.XMLNamespaces.Add (filename, uri , [alias], True)
B) Me.XMLNodes.Add (filename, "", uri )
C) Me.XMLSchemaReferences.Add ( uri , [alias], filename, True)
D) Dim doc As ThisDocument = Globals.ThisDocument Me.Application.XMLNamespaces.Item(uri). _ AttachToDocument(doc)

Solutions: