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

You develop an add-in for Microsoft Office Excel by using Visual Studio Tools for the
Microsoft Office System (VSTO). The add-in contains a class that uses the following method.
public void ProcessCells() {
Excel.Worksheet ws = Application.ActiveSheet as
Excel.Worksheet;
List<object> values = new List<object>();
//Your code goes here
}
The add-in must retrieve the values for the cells in the range A1 through E3.
You need to exclude empty cell values when you retrieve cell values from the range.
Which code segment should you use?

• A. Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r != null) values.Add(r.Value2); }
• B. Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r.Value2 != null) values.Add(r.Value2); }
• C. Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 1; x < 4; x++) { for (int y = 1; y < 6; y++) { Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r != null) values.Add(r.Value2); } }
• D. Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 0; x < 3; x++) { for (int y = 0; y < 5; y++) { Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r.Value2 != null) values.Add(r.Value2); } }

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 Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
• B. Add a script to the Custom Actions Editor to install the local database.
• C. Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.
• D. Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
• E. Add a script to the File System Editor to install the local database.

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a custom task pane named MyPane. MyPane is docked by default on the right of the Word application frame. You need to prevent users from changing the default docked position of MyPane. Which code segment should you use?

• A. MyPane.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight ;
• B. MyPane.Control.Dock = DockStyle.Right ;
• C. MyPane.DockPositionRestrict = Office. MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNone ;
• D. MyPane.DockPositionRestrict = Office. MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNoChange ;

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

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 Enabled property of the CommandBarButton button object to True.
• B. Change the scope of the ._CommandBarButtonEvents_ClickEventHandler delegate btnClick variable to a class-scoped variable.
• C. Change the scope of the CommandBarButton button variable to a class-scoped variable.
• D. Set the OnAction property of the CommandBarButton button object to Click.