You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must connect to a remote database to retrieve data. The structure of the remote database is shown in the exhibit. (Click the Exhibit button.)
You write the following lines of code. (Line numbers are included for reference only.)
01 internal sealed partial class Settings : 02 global::System.Configuration.ApplicationSettingsBase { 03 [ global::System.Configuration.SpecialSettingAttribute ( 04 global::System.Configuration.SpecialSetting.ConnectionString )]
05 ...
06 public string ExcelSQLConnectionString {
07 get {
08 return (string)(this[" ExcelSQLConnectionString "]);
09 }
10 }
You need to connect to the remote database by using the security context of the current user.
Which code segment should you insert at line 05?

• A. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data S ource=EXCELSQL;" + " InitialCatalog = AdventureWorks.Production.Product ;" + "Integrated Security=True")]
• B. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Production;" + "Integrated Security=True")]
• C. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Product;" + "Integrated Security=True")]
• D. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" + "Integrated Security=True")]

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in fills in sales forecast data for each month in an Excel sheet. You write the following method. (Line numbers are included for reference only.)
01 public void FillMonths () {
02 Excel.Application app = Globals.ThisAddIn.Application ;
03 Excel.Worksheet ws = app.ActiveSheet as Excel.Worksheet ;
04 ...
05 }
You need to insert the names of the months into the cells in the range A1 through A12.
Which code segment should you insert at line 04?

• A. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( ws.get_Range ("A1:A12", Type.Missing ), Excel.XlAutoFillType.xlFillMonths )
• B. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( rng.EntireColumn , Excel.XlAutoFillType.xlFillMonths );
• C. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( ws.get_Range ("A2:A12", Type.Missing ), Excel.XlAutoFillType.xlFillMonths );
• D. Excel.Range rng = ws.get_Range ("A1", Type.Missing ); rng.Value2 = "January"; rng.AutoFill ( rng , Excel.XlAutoFillType.xlFillMonths );

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following method in the document class.
void wordAppEvent_NewDocument ( Word.Document Doc) { //Add custom footer
}
You need to set up an event handler that is fired when a Word document is created.
Which code segment should you use?

• A. Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.Application.ActiveDocument as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );
• B. Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.Application as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );
• C. Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.InnerObject as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_N ewDocumentEventHandler( wordAppEvent_NewDocument );
• D. Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.ActiveWindow as
  Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );

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.Application.SheetSelectionChange += new Excel.AppEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
• B. Globals.ThisWorkbook.Application.SheetChange += new Excel.AppEvents_SheetChangeEventHandler ( NotifyChanges );
• C. Globals.ThisWorkbook.SheetSelectionChange += new Excel.WorkbookEvents_SheetSelectionChangeEventHandler ( NotifyChanges );
• D. Globals.ThisWorkbook.SheetChange += new Excel.WorkbookEvents_SheetChangeEventHandler ( NotifyChanges );

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A. StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• B. doc.CachedData.HostItems.Add(filepath);
• C. StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• D. doc.CachedData.FromXml(filepath);