You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains a NamedRange control named MyRange. MyRange is associated with cell D1. You need to change MyRange to use the cells A1 and B1. Which code segment should you use?

• A. MyRange.Formula = "A1:B1";
• B. MyRange.RefersTo = "A1:B1";
• C. MyRange.Formula = "=$A$1:$B$1";
• D. MyRange.RefersTo = "=$A$1:$B$1";

You are creating an add-in for Microsoft Office Outlook by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code. (Line numbers are included for reference only.)
01 List< Outlook.MAPIFolder > folders;
02 Outlook.Explorer explorer;
03
04 public void CreateCollection () {
05 explorer = Application.ActiveExplorer ();
06 folders = new List< Outlook.MAPIFolder >();
07 ProcessFolders ( explorer.CurrentFolder );
08 }
09
10 public void ProcessFolders ( Outlook.MAPIFolder folder) {
11 ... 12 }
You need to ensure that the folders collection includes all the folders and subfolders within the selected Outlook folder.
Which code segment should you insert at line 11?

• A. foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
  ProcessFolders ( fldr ); }
• B. foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
  folders.Add ( fldr ); }
• C. folders.AddRange ((List< Outlook.MAPIFolder >) folder.Folders );
• D. foreach ( Outlook.MAPIFolder fldr in folder.Folders ) {
  folders.Add ( fldr );
  ProcessFolders ( fldr ); }

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. In the Configuration Manager dialog box for the add-in project, set Active Configuration to Debug.
• C. Add a new application configuration file to your project by using the following XML fragment. < configuration > < appSettings > < add key="Debug" value="True"/ > < /appSettings > < /configuration >
• D. Add a new application configuration file to your project by using the following XML
  fragment.
  < configuration > < appSettings > < add key="ShowErrors" value="True"/ > < /appSettings > < /configuration >

You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in has a custom task pane named MyPane. MyPane contains a user control named MyUserControl. You write the following method that resizes MyUserControl.
Public Sub ResizeControls ()
...
End Sub
You need to call the ResizeControls method when MyPane is not docked to the Excel 2007 application window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Add the following method to the add-in. Private Sub DockChanged ( ByVal sender As
  Object, _ ByVal e As EventArgs ) If MyPane.Control.Dock = DockStyle.None Then ResizeControls () End If End Sub
• B. Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.DockPositionChanged , AddressOf Me.DockChanged
• C. Add the following method to the add-in. Private Sub DockChanged ( ByVal sender As Object, _ ByVal e As EventArgs ) If MyPane.DockPosition = _ MsoCTPDockPosition.msoCTPDockPositionFloating Then ResizeControls () End If End Sub
• D. Write the following line of code in the Startup event for the add-in.
  AddHandler
  MyPane.Control.DockChanged , AddressOf Me.DockChanged