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

1. You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

A) StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
B) doc.CachedData.FromXml(filepath);
C) StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
D) doc.CachedData.HostItems.Add(filepath);

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

3. You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains code that customizes the Ribbon user interface (UI). You run the add-in. The add-in does not customize the Ribbon UI and does not display an exception. You need to display the exceptions in the user interface of the add-in when the add-in starts. What should you do?

A) Under the Word 2007 options, select the Show add-in user interface errors check box.
B) Add a new application configuration file to your project by using the following XML
fragment.
< configuration > < appSettings > < add key="ShowErrors" value="True"/ > < /appSettings > < /configuration >
C) In the Configuration Manager dialog box for the add-in project, set Active Configuration to Debug.
D) Add a new application configuration file to your project by using the following XML fragment. < configuration > < appSettings > < add key="Debug" value="True"/ > < /appSettings > < /configuration >

4. 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.Controls.AddControl( userControl, 100, 100, 100, 100, "Action s Pane");
B) this.ActionsPane.Parent.Controls.Add(userControl);
C) this.ActionsPane.Controls.Add(userControl);
D) this.ActionsPane.Controls.AddRange( new Control[] { userControl, new MyUserControl() });

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 document is customized to add a toolbar with custom functionality. You write the following lines of code in the Startup event of the ThisDocument class.
Dim toolbar As Office.CommandBar = Me.Application . _ CommandBars.Add (Name:=" MyToolBar ", _ Position:= Office.MsoBarPosition.msoBarTop , Temporary:=False)
Dim button As Office.CommandBarButton = _ CType ( too lbar.Controls.Add ( _ Type:= Office.MsoControlType.msoControlButton , _ Temporary:=False), Office.CommandBarButton )
Dim btnClick As _ Office._CommandBarButtonEvents_ClickEventHandler = _ AddressOf Me.button_Click
AddHandler button.Click , AddressOf Me.b utton_Click The event handler for the button does not execute every time CommandBarButton is clicked.
You need to ensure that the event handler executes every time CommandBarButton is clicked.
What should you do?

A) Set the OnAction property of the CommandBarButton button object to Click.
B) Set the Enabled property of the CommandBarButton button object to True.
C) Change the scope of the ._CommandBarButtonEvents_ClickEventHandler delegate btnClick variable to a class-scoped variable.
D) Change the scope of the CommandBarButton button variable to a class-scoped variable.

Solutions: