You are the Office 365 Administrator for your company.
You plan to implement a collaboration platform for a company. All 1,000 employees currently use Excel 2010.
You have the following requirements:
All employees must be able to co-author Excel workbooks.
You must minimize the costs associated with any solution.
You need to recommend a solution.
Which solution should you recommend?
A.
Implement SharePoint 2013 with Excel Services.
B.
Purchase an Office 365 Small Business subscription.
C.
Implement SharePoint Online and continue using Excel 2010.
D.
Purchase an Office 365 Enterprise El subscription.
Explanation:
By using Excel Services, you can reuse and share Excel workbooks on SharePoint 2013 portals and
dashboards.
https://msdn.microsoft.com/en-us/library/office/ms546696.aspx
Answer should be D. Purchase an Office 365 E1 Subscription. You can’t co-author with Excel Services. You’ll need Office Online to do that.
https://support.office.com/en-us/article/Getting-Started-with-Excel-Services-and-Excel-Web-Access-fed3586d-b150-4819-a67e-14529c974387
Wait… I may be wrong. Can someone confirm?
You are right. Excel services is not for editing workbooks, you use Office Online for that. Also, in SharePoint 2016 on-prem deployments, Excel Services is gone as a service application. It is now a part of Office Online Server.
looks like D may be correct
http://equizzing.com/microsoft/which-solution-should-you-recommend-41/
A correct
What Is Excel Services?
Excel Services enables businesses to securely share workbooks across an enterprise. You can now make workbooks available through a browser with far greater control and manageability than has previously been possible. This server-based model complements the rich Excel 2007 client, enabling the following benefits to the enterprise:
More secure sharing of workbooks. Workbook authors can share workbooks without exposing any underlying proprietary business logic, and they can prevent others from editing workbooks.
For those saying D, Office 365 E1 subscription does not include Office applications so that’s obviously incorrect.
What you need to co-author
You need an Office 365 subscription.
You need the latest version of Office installed. Please note that if you have a work or school account, your administrator may control which version of Office you can install, and it may not be the latest version. See When do I get the newest features in Office 2016 for Office 365? for more information.
You need to use .xlsx, .xlsm, or .xlsb files. If your file isn’t in this format, open the file and then click File > Save As…. Change the file format to .xlsx, .xlsm, or .xlsb.
https://support.office.com/en-gb/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
B should be the answer in my opinion especially from a cost savings perspective. I would have said C but don’t think Excel 2010 supports co-authoring and don’t think you can use an on-prem version of Excel alongside SharePoint online for co-authoring.
Office Online allows co-authoring, that is why D is correct.
A, does not gives all the collaborations features that are available online. Keep in mind that the questions for this exam target Office 365, not the knowledge of Sharepoint On-premise.
B, Office 365 for small Business subscription is available only for less than 300 users.
C may be also be ok, but Office 2010 may work with Office 365 with reduced functionality. This does not mean that this will work.
https://products.office.com/en-CA/office-system-requirements?ui=en-US&rs=en-US&ad=US
D is the good one. You can do Co-author with Excel Online that is available with Office 365 E1. This is the cheapest Office 365 subscription available for an enterprise with 1000 employees.
https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US
C is not good, because you need Office 2016 if you want to do co-authoring in the Office client Excel.