5. Which of the following is true of the Business Explorer (BEx) Analyzer?
a) It is integrated with Microsoft Excel.
b) It allows multiple queries to be embedded into a single worksheet/workbook.
c) It can refresh queries automatically when a workbook is opened.
d) It has protection to prevent changes to cell values.
e) All of the above.
All of these answers are true of the BEx Analyzer. The BEx Analyzer is directly integrated with Microsoft Excel. One or more queries can be inserted onto a single worksheet and more than one worksheet can be used. A setting within the properties of a query definition allows reports to automatically refresh when they are opened in the BEx Analyzer. Finally, SAP protection (found in the tools menu of the BEx Analyzer toolbar) can lock worksheets from being modified.