Passing exam with 070-543 latest training materials

You create an add-in for Microsoft Office Outlook 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a network share named OfficeSolutions. The OfficeSolutions network share is located on a server named LONDON. You need to grant permission for the add-in to run. Which command should you use?

• A. caspol Cm Cgac Execute
• B. caspol Cm Cgac FullTrust
• C. caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" FullTrust
• D. caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" Execute

You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

• A. control.LockContentControl = true; control.LockContents = false;
• B. control.LockContentControl = false; control.LockContents = false;
• C. control.LockContentControl = true; control.LockContents = true;
• D. control.LockContentControl = false; control.LockContents = true;

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 has a table that contains data. The table has two columns and two rows.
You write the following lines of code. (Line numbers are included for reference only.)
01 Excel.Workbook book;
02 Excel.Worksheet sheet = book.Worksheets [1] as Excel.Worksheet ;
03 Word.Table tbl = this.Tables [1];
04 ...
You need to insert the data in the cell range A1 through B2 of the first worksheet in the Excel workbook.
Which code segment should you insert at line 04?

• A. Excel.Range rng = sheet.get_Range ("A1", "B2"); rng.Value2 = tbl.Range.Text ;
• B. Excel.Range rng = sheet.get_Range ("A1", System.Type.Missing ); tbl.Range.Copy (); rng.PasteSpecial ( Excel.XlPasteType.xlPasteAll , Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone , System.Type.Missing , System.Type.Missing );
• C. for ( int i = 0; i < tbl.Rows.Count ; i ++) { for ( int j = 0; j < tbl.Columns.Count ; j++) { ( sheet.Cells [ i , j] as Excel.Range ).Value2 = tbl.Cell ( i , j). Range.Text ; } }
• D. for ( int i = 1; i < = tbl.Rows.Count ; i ++) { for ( int j = 1; j < = tbl.Columns.Count ; j++) { ( sheet.Cells [ i , j] as Excel.Range ).Value2 = tbl.Cell ( i , j). Range.Text ; } }

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="false"/ >
• B. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• C. < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
• D. < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >

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 = 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 '...
• B. 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 '...
• 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 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 '...