You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution contains a DataRow named custrow. A serialization of custrow contains the following XML fragment.
< ClientProjects >
...
< description > Upgrade from Windows XP < /description >
... < / ClientProjects >
The solution will create an XMLNode control named ProjectDescriptionNode in a Word document.
You need to ensure that the text in the description element is displayed as unformatted text.
Which code fragment should you use?

• A. ProjectDescriptionNode.NodeValue = _ custrow("description").ToString()
• B. ProjectDescriptionNode.Text = _ custrow("description").ToString()
• C. ProjectDescriptionNode.PlaceholderText = _ custrow("description").ToString()
• D. ProjectDescriptionNode.NodeText = _ custrow("description").ToString()

You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). You will use Microsoft Visual Studio 2005 Bootstrapper to install the add-in.
The Product.xml file for the Bootstrapper contains the following XML fragment. (Line numbers are included for reference only.)
01 < InstallChecks >
02 < AssemblyCheck Property="VSTORInstalled"
03 Name="Microsoft.Office.Tools.Common"
04 PublicKeyToken="b03f5f7f11d50a3a" Version="8.0.0.0"/ >
05 < /InstallChecks >
0 6 < Commands Reboot="Defer" >
07 < Command PackageFile="vstor.exe" >
08 < InstallConditions >
09 ...
10 < /InstallConditions >
11 < /Command >
12 < /Commands >
You need to ensure that Microsoft VSTO Runtime is installed on the target computers.
Which XML fragment should you insert at line 09?

• A. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• B. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >
• C. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >
• D. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >

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 File System Editor to install the local database.
• 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 Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.

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"); 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); } }
• B. Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r != 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"); foreach (Excel.Range r in rng.Cells) { if (r.Value2 != null) values.Add(r.Value2); }