You create an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). You create the following method in the add-in.
void DisplayTotal ( Excel.Range rng ) { //Display total }
You write the following code segment in the startup event of the add-in.
Excel.Worksheet ws = Globals.ThisAddIn.Application .
ActiveSheet as Excel.Worksheet ;
ws.SelectionChange += new Excel.DocEvents_SelectionChangeEventHandler ( ws_SelectionChange );
The add-in must display the sum of the values in a selected range. If multiple ranges are selected, the add-in must display only the sum of the values in the first selected range.
You need to meet the outlined requirements.
Which code segment should you use?

• A. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [1]); }
• B. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Areas [0]); }
• C. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.CurrentRegion ); }
• D. void ws_SelectionChange ( Excel.Range Target) { DisplayTotal ( Target.Previous ); }

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 = true;
• B. control.LockContentControl = false; control.LockContents = false;
• C. control.LockContentControl = true; control.LockContents = false;
• D. control.LockContentControl = false; control.LockContents = true;

You create a Microsoft Office Word 2007 document.
The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)
You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml file. You add the item2.xml file to the OpenXML package.
You need to ensure that the document uses data from the item2.xml file instead of the item1.xml file.
What should you do?

• A. Delete the itemProps1.xml file.
• B. Create a file named itemProps2.xml that marks the item2.xml file as a data store.
• C. Delete the item1.xml file.
• D. Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the itemProps1.xml file.

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a custom task pane named MyPane. MyPane is docked by default on the right of the Word application frame. You need to prevent users from changing the default docked position of MyPane. Which code segment should you use?

• A. MyPane.DockPositionRestrict = Office. MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNone ;
• B. MyPane.DockPositionRestrict = Office. MsoCTPDockPositionRestrict.msoCTPDockPositionRestrictNoChange ;
• C. MyPane.Control.Dock = DockStyle.Right ;
• D. MyPane.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight ;