Microsoft 70-543 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | PRO: Visual Studio 2005/2008 Tools for Microsoft Office System (VSTO) |
| Exam Number: | 70-543 |
| Exam Format: | Multiple choice, Case study, Scenario-based questions |
| Certificate Validity Period: | Retired |
| Related Certifications: | Microsoft Certified Technology Specialist (MCTS): Visual Studio Tools for Office |
| Passing Score: | 700 (on 1000 scale) |
| Exam Price: | USD 165 (varies by region) |
| Exam Duration: | 120-150 |
| Available Languages: | English |
| Real Exam Qty: | 40-60 |
| Sample Questions: | Microsoft 70-543 Sample Questions |
| Exam Way: | Computer-based exam at authorized testing centers or online proctored (varies by region and era; exam is now retired) |
| Pre Condition: | Recommended experience with Visual Studio, .NET Framework, and Microsoft Office development (C# or VB.NET) |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/ |
Microsoft 70-543 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Developing Microsoft Office Solutions Using VSTO | - Creating Office add-ins and document-level customizations - Understanding Office object models and extensibility points |
| Building User Interface Customizations | - Custom task panes and Windows Forms integration - Customizing Ribbon and Office UI components |
| Deployment and Security of Office Solutions | - ClickOnce deployment for Office add-ins - Security model, trust levels, and permissions |
| Debugging and Troubleshooting VSTO Solutions | - Handling runtime errors and compatibility issues - Diagnostics and debugging Office add-ins |
| Working with Office Applications Data | - Excel, Word, and Outlook automation - Data binding and document-level data management |
Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:
1. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following lines of code in the solution.
Dim tag As SmartTag = New _
SmartTag("http:// MySmartTag/ST#MySmartTag", "My Tag") tag.Terms.Add("Bug") tag.Terms.Add("Error") tag.Terms.Add("Issue") Dim action As Action = New Action("Add Reference") tag.Actions = New ActionBase() {action} AddHandler action.Click, AddressOf Me.action_Click
You need to add the string "Reference: " before either "Bug", "Error", or "Issue" when the smart tag is clicked.
Which code segment should you use?
A) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Range.XML (False).ToString() End Sub
B) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Text End Sub
C) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Range.Text = "Reference: " & e.Properties.Read ("Text") End Sub
D) Private Sub action_Click ( _ ByVal sender As Object, ByVal e As ActionEventArgs ) e.Properties.Write ( e.Range.Text , "Reference: " & e.Range.Text ) End Sub
2. 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 contains a DataRow named custrow. A serialization of custrow contains the following XML fragment.
< ClientProjects >
...
< description > Upgrade from Windows XP < /description >
... < / ClientProjects >
The solution will create an XMLNode control named ProjectDescriptionNode in a Word document.
You need to ensure that the text in the description element is displayed as unformatted text.
Which code fragment should you use?
A) ProjectDescriptionNode.PlaceholderText = _ custrow("description").ToString()
B) ProjectDescriptionNode.NodeText = _ custrow("description").ToString()
C) ProjectDescriptionNode.NodeValue = _ custrow("description").ToString()
D) ProjectDescriptionNode.Text = _ custrow("description").ToString()
3. 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) DataSet ds = new DataSet(); ArrayList mappings = new ArrayList(); LONDON.Service1.GenerateXmlMappings( ds.GetType(), mappings);
B) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.DataSetName = lh.GetCustomers (). GetXml ();
C) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.GetXml();
D) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = lh.GetCustomers ();
4. 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) Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc ") Dim path As String = "\\LONDON\OfficeSolutions" sd.AppManifest.DeployManifestPath = path sd.Save ()
B) Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim name As String = " LONDON.OfficeSolutions.HRSolution " sd.AppManifest.Identity.Name = name sd.Save ()
C) Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim name As String = " LONDON.OfficeSolutions.HRSolution " sd.AppManifest.EntryPoints.Add (name) sd.Save ()
D) Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim path As String = "\\LONDON\OfficeSolutions" sd.AppManifest.Dependency.AssemblyPath = path sd.Save ()
5. 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) < BypassIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
C) < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="false"/ >
D) < FailIf Property="VSTORInstalled" Compare="ValueExists" Value="true"/ >
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: B |

We're so confident of our products that we provide no hassle product exchange.


By Nigel


