You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized workbook contains a NamedRange control named MyRange. MyRange is associated with cell D1. You need to change MyRange to use the cells A1 and B1. Which code segment should you use?

• A. MyRange.RefersTo = "=$A$1:$B$1"
• B. MyRange.RefersTo = "A1:B1"
• C. MyRange.Formula = "=$A$1:$B$1"
• D. MyRange.Formula = "A1:B1"

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.Dependency.AssemblyPath = path sd.Save ()
• B. Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc ") Dim path As String = "\\LONDON\OfficeSolutions" sd.AppManifest.DeployManifestPath = path sd.Save ()
• C. 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 ()
• D. 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 ()

You create a Microsoft Office Word 2007 document. The document will use data from a
file named Data1.xml. The file is located in the C:\Data folder. You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). You need to ensure that the application adds the data from the Data1.xml file to the document. Which code segment should you use?

• A. document.CustomXMLParts.Add(XML:="") document.CustomXMLParts(1).Load("C:\data1.xml")
• B. Dim xmlPart As CustomXMLPart xmlPart = document.CustomXMLParts.Add(XML:="") xmlPart.DocumentElement.AppendChildNode( _ "xmlPart", uri, MsoCustomXMLNodeType.msoCustomXMLNodeElement, _ "data1.xml")
• C. Dim control As ContentControl control = document.ContentControls.Add _ (
  WdContentControlType.wdContentControlText, range) control.XMLMapping.SetMapping( _ "C:\data1.xml", "", document.CustomXMLParts(1))
• D. Dim control As ContentControl control = document.ContentControls.Add( _
  WdContentControlType.wdContentControlText, range) control.XMLMapping.SetMapping( _ "/data1.xml", "", document.CustomXMLParts(1))

You create a document-level solution by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution uses an assembly named MyAssembly. MyAssembly is located in the C:\Assemblies\ folder. A Microsoft Office Word 2003 document named MyWordDocument is located in the C:\Documents\ folder. You need to associate MyAssembly with MyWordDocument if managed extensions are enabled in MyWordDocument. Which code segment should you use?

• A. string document = @"C:\Documents\MyWordDocument.doc"; string a ssembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCustomized (assembly)) { //Add document customization }
• B. string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCacheEnabled (assembly)) { //Add document customization }
• C. string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCustomized (document)) { //Add document customization }
• D. string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCacheEnabled (document)) { //Add document customization }

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy the solution. You also need to ensure that users have access to previous versions of the solution. What should you do?

• A. Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.
• B. Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.
• C. Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and reinstall the solution.
• D. Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.