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

You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Microsoft.Office.Tools.CustomTaskPane pane; private void CreatePane () { pane = this.CustomTaskPanes.Add (new MyUserControl (), "Do Something"); pane.Visible = true; }
Users must open multiple workbooks in Excel.
You need to ensure that the add-in displays the same instance of the task pane when a
user views any of the open workbooks.
What should you do?

• A. Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }
• B. Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Excel.Workbook Wb, Excel.Window Wn ) { CreatePane (); }
• C. Create the following event handler for the Application.WorkbookOpen event. void Application_WorkbookOpen ( Excel.Workbook Wb ) { CreatePane (); }
• D. Create the following event handler for the Application.WorkbookActivate event. void Application_WorkbookActivate ( Excel.Workbook Wb ) { CreatePane (); }

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Microsoft.Office.Tools.CustomTaskPane pane;
private void CreatePane () {
pane = this.CustomTaskPanes.Add (new MyUserControl (),
"Do Something");
pane.Visible = true;
}
You need to ensure that only a single instance of the custom task pane is displayed in each single document interface (SDI) window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Word.Document Doc, Word.Window Wn ) { CreatePane (); }
• B. Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }
• C. Create the following event handler for the Application.DocumentOpen event. void Application_DocumentOpen ( Word.Document Doc) { CreatePane (); }
• D. Create the following event handler for the Application.NewDocument event. void Application_DocumentNew ( Word.Document Doc) { CreatePane (); }
• E. Create the following event handler for the Application.ActiveDocument.New event. void ActiveDocument_New () { CreatePane (); }

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 are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will display data from a Web service named Service1. Service1 runs on a server named LONDON. The Web service contains a method named GetCustomers that returns a DataSet object. You need to bind the data returned by the GetCustomers method to a DataSet object named ds. Which code segment should you use?

• A. Dim ds As DataSet = New DataSet() Dim mappings As ArrayList = New ArrayList() LONDON.Service1.GenerateXmlMappings( _ ds.GetType(), mappings)
• B. Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.DataSetName = lh.GetCustomers.GetXml()
• C. Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.GetXml()
• D. Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = lh.GetCustomers()

You are creating an add-in for Microsoft Office Word 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 try { 02 Word.Paragraph par =
this.Application.ActiveDocument.Paragraphs[2]; 03 par.Range.Text = ""; 04 } 05 ...
The application throws an exception if the active Word document does not contain a second paragraph.
You need to handle the exception.
Which code segment should you insert at line 05?

• A. catch (InvalidRangeException ex) { // }
• B. catch (IndexOutOfRangeException ex) { // }
• C. catch (COMException ex) { // }
• D. catch (IOException ex) { // }