Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?

A) Add a PublicKeyToken attribute to the ContactRef.datasource file.
B) Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.
C) Add a PublicKeyToken element to the ContactRef.datasource file.
D) Add the public key token to the TypeInfo element in the ContactRef.datasource file.

2. You create a custom workbook for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook contains the following data:
Static data
Data that is imported from .xml files
The workbook displays the imported data by using mapped ranges.
You need to send only the imported data to a user.
What should you do?

A) From the Developer Ribbon user interface, export the XML data as an .xml file by using the Export command. Send the .xml file to the user.
B) From the Design Ribbon user interface, export the XML data to a Microsoft Windows SharePoint Services list by using the Export command. Send the link from the Microsoft Windows SharePoint Services list to the user.
C) Save the workbook as an .xml file, and then send the Workbook.xml file to the user.
D) Save the workbook as a .zip file, and then send the Workbook.xml file that is contained in the .zip file to the user.

3. 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 will insert an XML data island in a Word document. The data island contains the following XML fragment.
< customer id="01AF" >
< region district="Northwest" > < /region >
< /customer >
You bind the data island to an XMLNode instance named xln.
You need to update the region element with the following data.
< customer id="01AF" >
< region district="Southwest" > California < /region >
< /customer >
Which code segment should you use?

A) if ( xln.ParentNode.NodeValue == "customer" & & xln.NodeText == "Northwest") { xln.NodeText = "Southwest"; xln.ChildNodes [1].Text = "California"; }
B) if ( xln.ChildNodes [0].Text == "customer" & & xln.NodeText == "Northwest") { xln.NodeText = "Southwest"; xln.ChildNodes [1].Text = "California"; }
C) if ( xln.ChildNodes [0].Text == "customer" & & xln.NodeValue [0]. CompareTo ("Northwest") == 0) { xln.NodeText = "California"; xln.ChildNodes [1].Text = "Southwest"; }
D) if ( xln.ParentNode.NodeValue == "customer" & & xln.NodeValue [0]. CompareTo ("Northwest") == 0) { xln.NodeText = "California"; xln.ChildNodes [1].Text = "Southwest"; }

4. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customization contains a predefined schema to validate the data that users add. The path to the schema is stored in a variable named filename. The Unique Resource Identifier (URI) for the schema is stored in a variable named uri. The alias for the schema is stored in a variable named alias.
You need to ensure that the schema that the user selects is applied to the solution document. Which code segment should you use?

A) this.XMLNodes.Add((string)filename, "", ref uri);
B) this.XMLSchemaReferences.Add(ref uri, ref alias, ref filename, true);
C) this.Application.XMLNamespaces.Add((string)filename, ref uri, ref alias, true);
D) object doc = Globals.ThisDocument; this.Application.XMLNamespaces.get_Item(ref uri). AttachToDocument(ref doc);

5. 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.Formula = "A1:B1"
B) MyRange.RefersTo = "=$A$1:$B$1"
C) MyRange.RefersTo = "A1:B1"
D) MyRange.Formula = "=$A$1:$B$1"

Solutions: