PrepAway - Latest Free Exam Questions & Answers

What should you do?

You have a Microsoft Office SharePoint Server 2007 site. You create a Microsoft Office Excel 2007 workbook that contains the telephone numbers of all your company locations. You need to ensure that users can filter the Excel 2007 workbook on the basis of company locations by using Excel Services in Microsoft Office SharePoint Server 2007. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create an ActiveX control in the workbook.

B.
Create an Excel 2007 Microsoft Visual Basic for Applications (VBA) application in the workbook.

C.
Filter the workbook by using the Data-Filter option of the Excel 2007 workbook.

D.
Filter the list in place by using Excel 2007, and protect the Excel 2007 workbook that contains the telephone numbers.


Leave a Reply