Pass with 070-543 Practice Materials 100% for sure

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The actions pane of the solution document contains two user controls.
The user controls must be displayed in the following ways:
In a horizontal display, the controls must be placed next to each other.
In a vertical display, the controls must be placed one below the other.
You need to ensure that the solution meets the requirements.
Which code segment should you use?

• A. Private Sub ActionsPane_OrientationChanged _ ( ByVal sender As Object, ByVal e As EventArgs) If Me.ActionsPane.Orientation = Orientation.Horizontal Then Me.ActionsPane.Controls(1).Dock = DockStyle.Left Me.ActionsPane.Controls(1).Dock = DockStyle.Right Else Me.ActionsPane.Controls(1).Dock = DockStyle.Top Me.ActionsPane.Controls(1).Dock = DockStyle.Bottom End If End Sub
• B. Private Sub ActionsPane_OrientationChanged _ (ByVal sender As Object, ByVal e As EventArgs) If Me.ActionsPane.Orientation = Orientation.Horizontal Then Me.ActionsPane.Dock = DockStyle.Left Else Me.ActionsPane.StackOrder = DockStyle.Top End If End Sub
• C. Private Sub ActionsPane_OrientationChanged _ (ByVal sender As Object, ByVal e As EventArgs) If Me.ActionsPane.Orientation = Orientation.Horizontal Then Me.ActionsPane.Controls(1).Anchor = AnchorStyles.Left Me.ActionsPane.Controls(1).Anchor = AnchorStyles.Right Else Me.ActionsPane.Controls(1).Anchor = AnchorStyles.Top Me.ActionsPane.Controls(1).Anchor = AnchorStyles.Bottom End If End Sub
• D. Private Sub ActionsPane_OrientationChanged _ (ByVal sender As Object, ByVal e As EventArgs) If Me.ActionsPane.Orientation = Orientation.Horizontal Then Me.ActionsPane.StackOrder = _ Microsoft.Office.Tools.StackStyle.FromLeft Else Me.ActionsPane.StackOrder = _ Microsoft.Office.Tools.StackStyle.FromTop End If End Sub

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 Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
• B. Add a script to the Custom Actions Editor to install the local database.
• C. Add a script to the File System Editor to install the local database.
• D. Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
• E. Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.

You are creating a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains five worksheets. You add a LinkLabel control named Label to the first worksheet of the workbook. You need to create a LinkClicked event handler that displays the next worksheet in the workbook. Which code segment should you use?

• A. void Label_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) { Excel.Workbook book = this.Parent as Excel.Workbook ; Excel.Worksheet sheet = book.Sheets [ this.Index + 1] as Excel.Worksheet ; sheet.Activate (); }
• B. void Label_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) { Excel.Workbook book = this.Site as Excel.Workbook ; Excel.Worksheet sheet = book.Sheets [ this.Index + 1] as Excel.Worksheet ; sheet.ShowAllData (); }
• C. void Label_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) { Excel.Workbook book = this.Parent as Excel.Workbook ; Excel.Worksheet sheet = book.Sheets [ this.Index + 1] as Excel.Worksheet ; sheet.ShowAllData (); }
• D. void Label_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) { Excel.Workbook book = this.Site as Excel.Workbook ; Excel.Worksheet sheet = book.Sheets [ this.Index + 1] as Excel.Worksheet ; sheet.Activate (); }

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a user control named MyUserControl.
You write the following code segment for your document class. (Line numbers are included for reference only.)
01 private void ThisDocument_Startup(object sender,
System.EventArgs e) {
02 MyUserControl userControl = new MyUserControl();
03 ...
04 }
You need to display userControl in the actions pane.
Which code segment should you insert at line 03?

• A. this.Controls.AddControl( userControl, 100, 100, 100, 100, "Action s Pane");
• B. this.ActionsPane.Controls.Add(userControl);
• C. this.ActionsPane.Controls.AddRange( new Control[] { userControl, new MyUserControl() });
• D. this.ActionsPane.Parent.Controls.Add(userControl);

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 (COMException ex) { // }
• C. catch (IndexOutOfRangeException ex) { // }
• D. catch (IOException ex) { // }