We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-543 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | TS: Visual Studio Tools for 2007 Microsoft Office System (VSTO) |
| Exam Number: | 70-543 |
| Certificate Validity Period: | Retired |
| Passing Score: | 700/1000 |
| Exam Format: | Case studies, Multiple choice |
| Available Languages: | English |
| Sample Questions: | Microsoft 70-543 Sample Questions |
| Exam Way: | Proctored exam at authorized testing centers or online proctoring (depending on availability at the time of exam offering). |
| Pre Condition: | Basic understanding of .NET Framework and Microsoft Office development concepts is recommended. |
Microsoft 70-543 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Customizing Microsoft Office applications | - Ribbon and UI customization - Word and Excel add-in development |
| Topic 2: Deployment and security | - ClickOnce deployment for Office solutions - Trust and security model in Office add-ins |
| Topic 3: Developing Office Solutions with VSTO | - Office application integration - VSTO architecture and runtime |
| Topic 4: Data access and interoperability | - Office data binding and automation - Interacting with COM and Office APIs |
Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:
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 = False control.LockContents = False
- B. control.LockContentControl = True control.LockContents = False
- C. control.LockContentControl = True control.LockContents = True
- D. control.LockContentControl = False control.LockContents = True
Correct Answer: B 🗳️
You are creating an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following code segment for the add-in class.
Microsoft.Office.Tools.CustomTaskPane pane; private void CreatePane () { pane = this.CustomTaskPanes.Add (new MyUserControl (), "Do Something"); pane.Visible = true; }
Users must open multiple workbooks in Excel.
You need to ensure that the add-in displays the same instance of the task pane when a
user views any of the open workbooks.
What should you do?
- A. Create the following event handler for the Application.WorkbookActivate event. void Application_WorkbookActivate ( Excel.Workbook Wb ) { CreatePane (); }
- B. Create the following event handler for the Application.WorkbookOpen event. void Application_WorkbookOpen ( Excel.Workbook Wb ) { CreatePane (); }
- C. Create the following event handler for the ThisAddIn.StartUp event. void ThisAddIn_Startup (object sender, System.EventArgs e) { CreatePane (); }
- D. Create the following event handler for the Application.WindowActivate event. void Application_WindowActivate ( Excel.Workbook Wb, Excel.Window Wn ) { CreatePane (); }
Correct Answer: C 🗳️
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. C:/Data/Data.xml
- B. /Data/Data.xml
- C. C:/Data/CustomXML/Item1.xml
- D. /CustomXML/Item1.xml
Correct Answer: D 🗳️
You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You add the following method to the workbook class.
void NotifyChanges (object Sh , Excel.Range Target) {
//No tify changes
}
You need to set up an event handler that fires NotifyChanges only when the data in the current workbook changes.
Which code segment should you use?
- A. Globals.ThisWorkbook.SheetSelectionChange += new Excel.WorkbookEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
- B. Globals.ThisWorkbook.Application.SheetChange += new Excel.AppEvents_SheetChangeEventHandler ( NotifyChanges );
- C. Globals.ThisWorkbook.Application.SheetSelectionChange += new Excel.AppEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
- D. Globals.ThisWorkbook.SheetChange += new Excel.WorkbookEvents_SheetChangeEventHandler ( NotifyChanges );
Correct Answer: D 🗳️
You create an add-in for Microsoft Office Visio by using Visual Studio Tools for the Microsoft Office System (VSTO). You install the add-in in a secure environment where local assemblies are not granted the FullTrust permission. You need to ensure that the add-in acquires the FullTrust permission after installation. What should you do?
- A. Configure the Custom Actions Editor to copy the add-in assembly to the %WINDIR% folder.
- B. Create an Installer class in the add-in assembly. Override the Install method so that the class copies the add-in assembly to the %WINDIR%/SYSTEM32 folder.
- C. Configure the File System Editor to copy the add-in assembly to the global assembly cache.
- D. Create an Installer class in the add-in assembly. Override the Install method so that the class associates the assembly with the LocalIntranet code group.
Correct Answer: C 🗳️
By Quennel
