Online Access Free 70-543 Practice Test

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.void ActionsPane_OrientationChanged( object sender, EventArgs e) {
  if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.Controls[1].Anchor = AnchorStyles.Left; this.ActionsPane.Controls[1].Anchor = AnchorStyles.Right;
  } else { this.ActionsPane.Controls[1].Anchor = AnchorStyles.Top; this.ActionsPane.Controls[1].Anchor = AnchorStyles.Bottom;
  } }
• B.void ActionsPane_OrientationChanged( object sender, EventArgs e) { if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.StackOrder = Microsoft.Office.Tools.StackStyle.FromLeft; } else { this.ActionsPane.StackOrder = Microsoft.Office.Tools.StackStyle.FromTop;
  } }
• C.void ActionsPane_OrientationChanged( object sender, EventArgs e) {
  if (this.ActionsPane.Orientation == Orientation.Horizontal) {
  this.ActionsPane.Controls[1].Dock = DockStyle.Left;
  this.ActionsPane.Controls[1].Dock = DockStyle.Right;
  } else {
  this.ActionsPane.Controls[1].Dock = DockStyle.Top;
  this.ActionsPane.Controls[1].Dock = DockStyle.Bottom;
  } }
• D.void ActionsPane_OrientationChanged( object sender, EventArgs e) { if (this.ActionsPane.Orientation == Orientation.Horizontal) { this.ActionsPane.Dock = DockStyle.Left; } else { this.ActionsPane.StackOrder = (StackStyle)DockStyle.Top;
  } }

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 void ProcessCells() {
Excel.Worksheet ws = Application.ActiveSheet as
Excel.Worksheet;
List<object> values = new List<object>();
//Your code goes here
}
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.Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r.Value2 != null) values.Add(r.Value2); }
• B.Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 1; x < 4; x++) { for (int y = 1; y < 6; y++) { Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r != null) values.Add(r.Value2); } }
• C.Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 0; x < 3; x++) { for (int y = 0; y < 5; y++) { Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r.Value2 != null) values.Add(r.Value2); } }
• D.Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r != null) values.Add(r.Value2); }

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.Site 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.Activate (); }
• D.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 (); }

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 lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.GetXml()
• B.Dim ds As DataSet = New DataSet() Dim mappings As ArrayList = New ArrayList() LONDON.Service1.GenerateXmlMappings( _ ds.GetType(), mappings)
• C.Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.DataSetName = lh.GetCustomers.GetXml()
• D.Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = lh.GetCustomers()

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.Change the application manifest in the main folder of the published solution to point to the new version.
• B.Create a deployment manifest in the subfolder. Edit the deployment manifest in the subfolder to point to the new version.
• C.Create an application manifest in the subfolder. Edit the application manifest in the subfolder to point to the new version.
• D.Change the deployment manifest in the main folder of the published solution to point to the new version.