070-543 무료 덤프문제 온라인 액세스

You create a Microsoft Office Excel 2007 workbook.
You save the workbook in the C:\Data folder as an OpenXML package. You copy a file
named Data.xml from the C:\Data folder to the CustomXML folder in the package. You
rename the copied file to Item1.xml.
You add the following XML fragment to the Document.xml.rels file in the package.
< Relationship Id="rId1"
Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/CustomXML "
Target="..." / >
You need to ensure that the workbook can use the custom XML document part.
Which value should you use for the Target attribute in the XML fragment?

• A./CustomXML/Item1.xml
• B.C:/Data/Data.xml
• C.C:/Data/CustomXML/Item1.xml
• D./Data/Data.xml

You create an add-in for a Microsoft Office Outlook application by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a reference to an Outlook folder in a variable named folder. You need to process only the e-mail messages within the folder. Which code segment should you use?

• A.For Each item As Outlook.MailItem In folder.Items 'Process mail Next
• B.For Each item As Outlook.MailItem In folder.Items If item.Class = Outlook.OlObjectClass.olMail Then 'Process mail End If Next
• C.For Each item As Object In folder.Items If CType (item, Outlook.MailItem ).Class = _ Outlook.OlObjectClass.olMail Then 'Process mail End If Next
• D.For Each item As Object In folder.Items If TypeOf item Is Outlook.MailItem Then 'Process mail End If Next

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.Save the workbook as a .zip file, and then send the Workbook.xml file that is contained in the .zip file to the user.
• B.Save the workbook as an .xml file, and then send the Workbook.xml file to the user.
• C.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.
• D.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.

You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Microsoft.Office.Tools.CustomTaskPane pane;
private void CreatePane () {
pane = this.CustomTaskPanes.Add (new MyUserControl (),
"Do Something");
pane.Visible = true;
}
You need to ensure that only a single instance of the custom task pane is displayed in each single document interface (SDI) window.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Create the following event handler for the Application.ActiveDocument.New event. void ActiveDocument_New () { CreatePane (); }
• B.Create the following event handler for the Application.DocumentOpen event. void Application_DocumentOpen ( Word.Document Doc) { CreatePane (); }
• C.Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Word.Document Doc, Word.Window Wn ) { CreatePane (); }
• D.Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }
• E.Create the following event handler for the Application.NewDocument event. void Application_DocumentNew ( Word.Document Doc) { CreatePane (); }

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The customized worksheet must have a button in a cell of the first row and the first column. The button must be automatically resized when the cell is resized. You need to create a button that meets the requirements. Which code segment should you use?

• A.Button button = Sheet.Controls.AddButton(1, 1, 1, 1, "MyButton"); button.Dock = DockStyle.None;
• B.Excel.Range rng = Sheet.Range["A1", System.Type.Missing ]; Sheet.Controls.AddButton(rng, "MyButton");
• C.Excel.Range rng = Sheet.Range["A", "1"]; Sheet.Controls.AddButton(rng, "MyButton");
• D.Button button = Sheet.Controls.AddButton(1, 1, 0, 0, "MyButton"); button.Dock = DockStyle.Fill;