Get real 70-543 exam questions for better preparation

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 = True control.LockContents = True
• C. control.LockContentControl = False control.LockContents = True
• D. control.LockContentControl = False control.LockContents = False

You develop a document-level solution for Microsoft Office Excel 2003 by using Visual
Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the worksheet class.
void Handle_Change ( Excel.Range Target) {
//.. .
}
You need to ensure that the Handle_Change method runs only when the data in the range A1 through E5 changes.
Which code segment should you add to the Startup event of the worksheet class?

• A. Excel.Range rng = this.Range ["A1", "E5"]; Microsoft.Office.Tools.Excel.NamedRange rng1 = this.Controls.AddNamedRange ( rng , " MyRange ");
  rng1.Change += new Excel.DocEvents_ChangeEventHandler ( Handle_Change );
• B. Excel.Range rng = this.Range ["A1", "E5"]; Microsoft.Office.Tools.Excel.NamedRange rng1 = this.Controls.AddNamedRange ( rng , " MyRange ");
  rng1.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( Handle_Change );
• C. Excel.Range rng = this.Range ["A1", "E5 "];
  this.Change += new Excel.DocEvents_ChangeEventHandler ( Handle_Change );
• D. Excel.Range rng = this.Range ["A1", "E5"];
  this.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( Handle_Change );

You create a document-level solution for a Microsoft Office Word document by using a Visual Studio Tools for the Microsoft Office System (VSTO) project. The solution project is named HRSolution. The solution document is named HRSolution.doc. You deploy a copy of the solution document to the C:\OfficeSolutions folder on client computers. You deploy the assembly to a shared folder named OfficeSolutions. The shared folder is located on a server named LONDON. You need to ensure that the solution document loads the assembly from the correct location. Which code segment should you use?

• A. ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string path = @"\\LONDON\OfficeSolutions"; sd.AppManifest.DeployManifestPath = pa th; sd.Save ();
• B. ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string path = @"\\LONDON\OfficeSolutions"; sd.AppManifest.Dependency.AssemblyPath = path; sd.Save ();
• C. ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string name = @" LONDON.OfficeSolutions.HRSolution "; sd.AppManifest.Identity.Name = name; sd.Save ();
• D. ServerDocument sd ; sd = new ServerDocument (@"C:\OfficeSolutions\HRSolution.doc"); string name = " LONDON.OfficeSolutions.HRSolution "; sd.AppManifest.EntryPoints.Add (name); sd.Save ();

You create a document-level solution for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). You manually deploy the customized Excel workbook and the associated assembly to a network share named OfficeSolutions. The network share is located on a server named LONDON. You need to remove the reference to the assembly from the copy of the workbook. Which code segment should you use?

• A. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.Dependency.AssemblyIdentity.Name.Remove (0);
• B. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.EntryPoints.Clear ();
• C. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.DeployManifestPath.Remove (0);
• D. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.Clear ();

You are creating an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application edits a Microsoft Office Word 2007 document. The Word document contains two XML parts. The second custom XML part is used to audit changes to the first custom XML part. You need to ensure that the application adds a new element to the second XML part each time the value of a text node in the first XML part is changed. What should you do?

• A. Modify the NodeAfterInsert event for the first CustomXMLPart object.
• B. Modify the StreamAfterAdd event for the CustomXMLParts collection.
• C. Modify the NodeAfterReplace event for the first CustomXMLPart object.
• D. Modify the StreamAfterLoad event for the CustomXMLParts collection.