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.
Implement SharePoint 2013 and continue using Excel 2010.
C.
Implement SharePoint Online and upgrade clients to Excel 2013.
D.
Implement SharePoint 2013 with an Office Web Apps server.
Explanation:
Excel services consists of three components: Excel Calculation Services, Excel Web Access, and Excel Web
Services.
Excel Web Access allows for co-authoring of Excel workbooks.
Incorrect Answers:
B: To be able to co-author Excel workbooks we would need either Excel Web App or Office Web Apps.
C: Upgrading to Excel 2013 would not help. To be able to co-author Excel workbooks we would need either
Excel Web App or Office Web Apps.
D: Co-author can implemented through an Office Web Apps Server, but it would not minimize the cost.
If you are using SharePoint Online or have SharePoint 2013 configured to use Office Web Apps Server, users
can co-author documents in Word, PowerPoint, Excel, and OneNote Web Apps. Howeverhttps://blogs.office.com/2013/11/19/real-time-co-authoring-in-the-excel-web-app-why-and-how-we-did-it/
I think it should be D.
“If you want to provide co-authoring for Microsoft Excel, use SharePoint Online or enable the Office Web Apps Server. ”
http://searchcontentmanagement.techtarget.com/tip/The-right-way-to-configure-co-authoring-in-SharePoint-2013
It can also be C, but it’s not as cost effective.
Excel Services is not for co-authoring. Office Web Applications (2013) or Office Online Server (2016) allows doing that on prem or the corresponding service in the cloud. If you have O365 licenses, that allows you to use the Office client and also to install servers like SharePoint and Office Online on prem. However, that would incur costs of maintaining the on-prem infastructure which you do not have if you just consume the O365 cloud services.
I think there is some information missing from the question text regarding what licences they have or something like that.
Anyway, quite unlikely that you are suggested to use on-prem stuff in these questions…
sharepoint online