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

1. You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Dim pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub CreatePane ()
Pane = Me.CustomTaskPanes.Add (New MyUserControl (), _
"Do Something")
pane.Visible = True
End Sub
Users must open multiple workbooks in Excel.
You need to ensure that the add-in displays the same instance of the task pane when a user views any of the open workbooks.
What should you do?

A) Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ ( ByVal Wb As Excel.Workbook , ByVal Wn As Excel.Window ) CreatePane () End Sub
B) Create the following event handler for the Application.WorkbookOpen event. Private Sub Application_WorkbookOpen ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub
C) Create the following event handler for the Application.WorkbookActivate event. Private Sub Application_WorkbookActivate _ ( ByVal Wb As Excel.Workbook ) CreatePane () End Sub
D) 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

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

3. You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add two Text content controls named control1 and control2 to the template.
The template contains the following custom XML fragment.
< ProductList >
<Product id="1">
<Name> Chai </Name>
</Product>
<Product id="2">
<Name>Chang</Name>
</Product> </ ProductList >
You need to ensure that control1 displays the id of the Product and control2 displays the name of the Product.
Which code segment should you use?

A) control1.XMLMapping.SetMapping("/ ProductList /Product[1]/id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product[1]/name", "", ActiveWindow.Document.CustomXMLParts [1]);
B) control1.XMLMapping.SetMapping("/ ProductList /Product/@id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product/name", "", ActiveWindow.Document.CustomXMLParts [1]);
C) control1.XMLMapping.SetMapping("/ ProductList /Product/id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping( " / ProductList /Product/name", "", ActiveWindow.Document.CustomXMLParts [1]);
D) control1.XMLMapping.SetMapping("/ ProductList /Product[1]/@id", "", ActiveWindow.Document.CustomXMLParts [1]); control2.XMLMapping.SetMapping("/ ProductList /Product[1]/name", "", ActiveWindow.Document.CustomXMLParts [1]);

4. You create an add-in for a Microsoft Office Outlook application by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a reference to an Outlook folder in a variable named folder. You need to process only the e-mail messages within the folder. Which code segment should you use?

A) For Each item As Outlook.MailItem In folder.Items 'Process mail Next
B) For Each item As Outlook.MailItem In folder.Items If item.Class = Outlook.OlObjectClass.olMail Then 'Process mail End If Next
C) For Each item As Object In folder.Items If CType (item, Outlook.MailItem ).Class = _ Outlook.OlObjectClass.olMail Then 'Process mail End If Next
D) For Each item As Object In folder.Items If TypeOf item Is Outlook.MailItem Then 'Process mail End If Next

5. You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must connect to a remote database to retrieve data. The structure of the remote database is shown in the exhibit. (Click the Exhibit button.)
You write the following lines of code. (Line numbers are included for reference only.)
01 Partial Friend NotInheritable Class Settings
02 Inherits System.Configuration.ApplicationSettingsBase
03 < System.Configuration.SpecialSettingAttribute ( _
04 System.Configuration.SpecialSetting.ConnectionString )>
05 ...
06 Public ReadOnly Property ExcelSQLConnectionString () _
As String 07 Get 08 Return Convert.ToString (Me(" ExcelSQLConnectionString ")) 09 End Get 10 End Property 11 End Class
You need to connect to the remote database by using the security context of the current user.
Which code segment should you insert at line 05?

A) < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL ;InitialCatalog = AdventureWorks ." & _ " Production.Product;Integrated Security=True")> _
B) < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" & _ "Integrated Security=True")> _
C) < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Production;Integrated Security=True")> _
D) < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Product;Integrated Security=True")> _

Solutions: