Microsoft Exam MS-600 Topic 13 Question 21 Discussion

Actual exam question for Microsoft's MS-600 exam

Question #: 21
Topic #: 13

You need to develop an add-in for Microsoft Excel that can be used from the Windows, Mac, and web versions of Excel.

What are two ways to develop the add-in? Each correct answer presents a complete solution?

NOTE: Each correct selection is worth one point.

AFrom Microsoft Teams, install App Studio

BFrom Microsoft Visual Studio that has the Microsoft Office/SharePoint development workload installed,
create a new project that uses a Web Add-in template

CFrom the Microsoft Office 365 portal, use Microsoft PowerApps

DUse the Yeoman generator for Microsoft Office Add-ins to create the project, and then open the project in Microsoft Visual Studio Code

EFrom Microsoft Visual Studio that has the Microsoft Office/SharePoint development workload installed,
create a new project that uses a Visual Studio Tools for Office (VSTO) template

Show Suggested Answer

Suggested Answer: D, E

D: Run the following command to create an add-in project using the Yeoman generator:

yo office

Visual Studio Code is a great tool to help you develop your custom Office Add-ins regardless if they are for Outlook, Word, Excel, PowerPoint and run in the web clients, Windows clients, iOS clients or on macOS.

Open the project in Visual Studio Code by entering the following on the command line from within the same folder where you ran the generator:

code.

E: You can create VSTO Add-ins for Excel.

To create a new Excel VSTO Add-in project in Visual Studio

*Start Visual Studio.

*On the File menu, point to New, and then click Project.

*In the templates pane, expand Visual C# or Visual Basic, and then expand Office/SharePoint.

*Under the expanded Office/SharePoint node, select the Office Add-ins node.

*In the list of project templates, select Excel 2010 Add-in or Excel 2013 Add-in.

*In the Name box, type FirstExcelAddIn.

*Click OK.

Visual Studio creates the FirstExcelAddIn project and opens the ThisAddIn code file in the editor.

References: https://docs.microsoft.com/en-us/office/dev/add-ins/tutorials/excel-tutorial

https://code.visualstudio.com/docs/other/office#_use-visual-studio-code-to-develop-your-office-addin

https://docs.microsoft.com/en-us/visualstudio/vsto/walkthrough-creating-your-first-vsto-add-in-for-excel

by Willow at May 05, 2022, 06:31 AM

Limited Time Offer

25%

Off

Get Premium MS-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!