Identify the spreadsheet tool that is used to

This preview shows page 12 - 15 out of 21 pages.

44. Identify the spreadsheet tool that is used to determine the optimal solution to a problem withmultiple constraints.a. Excel scenario managerb. Excel Solverc. Excel filterd. Excel chartANS: B
We have textbook solutions for you!
/Illustrated-Microsoft-Office-365-Office-2016-for-Medical-Professionals-1st-Edition-9781305878570-1361/
The document you are viewing contains questions related to this textbook.
Chapter EXM1 / Exercise 1
Illustrated Microsoft Office 365 & Office 2016 for Medical Professionals
Beskeen/Cram
Expert Verified
RATIONALE: Spreadsheets can be used to create useful reports and graphs based on given data. Endusers can employ Excel Solver to find the optimal solution to a problem with multiple constraints.45. _____ can be used to create useful reports and graphs based on given data.
46. Which of the following best describes reporting and querying tools?
47. Which of the following enables end users to make their own data requests and format the resultswithout the need for additional help from the information technology organization?
48. _____ enables users to identify issues and opportunities as well as perform trend analysis byanalyzing multidimensional data from many different perspectives.a. Online analytical processing (OLAP)b. Drill-down analysisc. Excel scenario managerd. Excel Solver
ANS: ARATIONALE: Online analytical processing (OLAP) is a method to analyze multidimensional data frommany different perspectives. It enables users to identify issues and opportunities as well as performtrend analysis.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 21 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
Steve
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Illustrated Microsoft Office 365 & Office 2016 for Medical Professionals
The document you are viewing contains questions related to this textbook.
Chapter EXM1 / Exercise 1
Illustrated Microsoft Office 365 & Office 2016 for Medical Professionals
Beskeen/Cram
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture