You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?

• A. Add the public key token to the TypeInfo element in the ContactRef.datasource file.
• B. Add a PublicKeyToken attribute to the ContactRef.datasource file.
• C. Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.
• D. Add a PublicKeyToken element to the ContactRef.datasource file.

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The Excel workbook contains a worksheet object named Sheet1 that contains data in the range A1 through A5.
You write the following lines of code for the Sheet1 object. (Line numbers are included for reference only.)
01 Dim bMark As Word.Bookmark
02 Dim doc As Word.Document = New Word.Application() ...
03 Dim index As Object = 1
04 Dim bMark As Word.Bookmark = do c.Bookmarks.Item(index)
05 ...
You need to insert the data from the range A1 through A5 into a Microsoft Office Word document after bMark. Your solution must retain the sequence of the data that is inserted.
Which code segment should you insert at line 05?

• A. Dim rng As Excel.Range = Me.Range("A1", "A5") Dim temp As String = "" For Each r As Excel.Range In rng.Cells temp = temp & r.Value2.ToString() Next bMark.Range.InsertAfter(temp)
• B. Dim rng As Excel.Range = Me.Range("A1", "A5") Dim temp As String = "" For Each r As Excel.Range In rng.Rows temp = temp & r.Text.ToString() Next bMark.Range.Text = temp
• C. Dim rng As Excel.Range = Me.Range("A1", "A5") For Each r As Excel.Range In rng.Cells bMark.Range.InsertAfter(r.Value2.ToString()) Next
• D. Dim rng As Excel.Range = Me.Range("A2", "A5") bMark.Range.Text = Me.Range("A1").Value2.ToString() For Each r As Excel.Range In rng.Rows bMark.Range.InsertAfter(r.Value2.ToString()) Next

You create a document-level solution for Microsoft Office Excel 2003 by using Visual
Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?

• A. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesTableAdapter.Update ( adventureWorksDWDataSet.FactResellerSales );
• B. XLNRange.Merge ( this.Range ["A1", "B3"]);
• C. XLNRange.AutoFill ( this.Range ["A1", "B3"], Excel.XlAutoFillType.xlFillDefault );
• D. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesBindingSource.Insert ( 0, adventureWorksDWDataSet.FactResellerSales );

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 document refers to the following bugs:
bug123
Bug514
BUG512
The solution document must provide more details about a bug whenever a reference to the bug is found in the document.
You need to create a smart tag that identifies each bug.
Which code segment should you use?

• A. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"[B|b][U|u][G|g]000"); tag.Expressions.Add(regex);
• B. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"bug\d\d\d");
• C. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); Regex regex = new Regex(@"bug\d\d\d", RegexOptions.IgnoreCase); tag.Expressions.Add(regex);
• D. SmartTag tag = new SmartTag( "http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer"); tag.Terms.Add(@"[B|b][U|u][G|g]000");