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 Sub ProcessCells ()
Dim ws As Excel.Worksheet = CType _
( Application.ActiveSheet , Excel.Worksheet ) Dim values As List(Of Object) = New List(Of Object)()
'Your code goes here
End Sub
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. Dim rng As Excel.Range = ws.Range ("A1", "E3") For x As Integer = 1 To 3 For y As Integer = 1 To 5 Dim r As Excel.Range = rng.Cells (x, y) If Not r Is Nothing Then values.Add (r.Value2) End If Next Next '...
• B. Dim rng As Excel.Range = ws.Range ("A1", "E3") For x As Integer = 0 To 2 For y As Integer = 0 To 5 Dim r As Excel.Range = rng.Cells (x, y) If Not r.Value2 Is Nothing Then values.Add (r.Value2) End If Next Next '...
• C. Dim rng As Excel.Range = ws.Range ("A1", "E3") For Each r As Excel.Range In rng.Cells If Not r.Value2 Is Nothing Then values.Add (r.Value2) End If Next '...
• D. Dim rng As Excel.Range = ws.Range ("A1", "E3") For Each r As Excel.Range In rng.Cells If Not r Is Nothing Then values.Add (r.Value2) End If Next '...

You create a document-level solution for Microsoft Office 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the solution to a folder on a network share. You copy a new version of the solution to a subfolder of the folder. You need to ensure that the users are redirected to the new version of the solution when they open the solution from the network share. What should you do?

• A. Create a deployment manifest in the subfolder. Edit the deployment manifest in the subfolder to point to the new version.
• B. Change the application manifest in the main folder of the published solution to point to the new version.
• C. Change the deployment manifest in the main folder of the published solution to point to the new version.
• D. Create an application manifest in the subfolder. Edit the application manifest in the subfolder to point to the new version.

You are creating a customized Microsoft Office Excel workbook by using the Visual Studio Tools for the Microsoft Office System (VSTO). The data in the Excel workbook will be used to update a Microsoft Office Word report named MyDoc.doc. The MyDoc.doc report is located in the C:\ folder. You need to retrieve a Document object that sends updates from the Excel workbook to the Mydoc.doc report. Which code segment should you use?

• A. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = Nothing app.Documents.Open(FileName:=filename, ConfirmConversions:=temp) Dim doc As Word.Document = CType(temp, Word.Document)
• B. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = app.Documents.Open(FileName:=filename) Dim doc As Word.Document = app.Documents.Add(temp)
• C. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim doc As Word.Document = _ app.Documents.Open(FileName:=filename)
• D. Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim action As Object = "Open" Dim doc As Word.Document = _ app.Documents.Add(Template:=filename, NewTemplate:=action)

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 must meet the following requirements:
The solution must save the document.
The users who do not have Microsoft VSTO Runtime installed can open the document.
You need to ensure that the solution meets the requirements.
Which code segment should you use?

• A. this.RejectAllRevisionsShown (); this.Save ();
• B. this.RemoveCustomization (); this.Save ();
• C. this.ReloadAs (
  Microsoft.Office.Core.MsoEncoding.msoEncodingAutoDetect ); this.Save ();
• D. this.RemoveTheme (); this.Save ();