ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam MS-600 All Questions

View all questions & answers for the MS-600 exam
Go to Exam

Exam MS-600 topic 5 question 3 discussion

Actual exam question from Microsoft's MS-600
Question #: 3
Topic #: 5
[All MS-600 Questions]

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.

  • A. From Microsoft Teams, install App Studio
  • B. From Microsoft Visual Studio that has the Microsoft Office/SharePoint development workload installed, create a new project that uses a Web Add-in template
  • C. From the Microsoft Office 365 portal, use Microsoft PowerApps
  • D. Use the Yeoman generator for Microsoft Office Add-ins to create the project, and then open the project in Microsoft Visual Studio Code
  • E. From 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 Hide Answer
Suggested Answer: DE 🗳️
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
6. Start Visual Studio.
7. On the File menu, point to New, and then click Project.
8. In the templates pane, expand Visual C# or Visual Basic, and then expand Office/SharePoint.
9. Under the expanded Office/SharePoint node, select the Office Add-ins node.
10.In the list of project templates, select Excel 2010 Add-in or Excel 2013 Add-in.
11.In the Name box, type FirstExcelAddIn.
12.Click OK.
Visual Studio creates the FirstExcelAddIn project and opens the ThisAddIn code file in the editor.
Reference:
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 skilshotz at Aug. 3, 2020, 4 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
skilshotz
Highly Voted 3 years, 2 months ago
VSTO isn't available in Excel web? I think it's B and D which are correct.
upvoted 13 times
Goronic
2 years, 9 months ago
B and D are correct. B - You can use Visual Studio and create an Excel Web Add-in D - You can use the Yeoman generator (yo office) to create an Office Add-in
upvoted 3 times
Goronic
2 years, 9 months ago
Reference: https://docs.microsoft.com/en-us/learn/modules/intro-office-add-ins/3-apis
upvoted 2 times
...
meghvasavada
2 years, 1 month ago
Yes, Its B and D
upvoted 1 times
...
...
...
ETU69
Highly Voted 3 years, 1 month ago
Excel add-ins are different from COM and VSTO add-ins, which are earlier Office integration solutions that run only in Office on Windows. Unlike COM add-ins, Excel add-ins do not require you to install any code on a user's device, or within Excel. And the question states that is also should run in the web version of Excel. I agree with skilshotz answers, but not with his explanation. So, answer B and D. https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-overview
upvoted 5 times
...
Selo123
Most Recent 8 months, 2 weeks ago
Selected Answer: BD
B: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=visualstudio D: https://learn.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=yeomangenerator
upvoted 1 times
...
mightyjoebong
2 years, 6 months ago
B and D are correct ref: https://docs.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=visualstudio section Prerequisites
upvoted 1 times
...
krzycherek
2 years, 6 months ago
B & D To create an Office add-in with Visual Studio, create a new C# or Visual Basic project and choose one of the following project types: Excel Web add-in Outlook Web add-in PowerPoint Web add-in Word Web add-in
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago