Judy, an Administrative Assistant to the Sales Manager, Sends You

question 59

Multiple Choice

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data) Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. You tell Judy that ____.

• A) she should sapy the data from each worksheet in the three workbooks and paste the data into a single worksheet in a new workbook; then create simple formulas to add all the data
• B) she can create a new dependent workbook santaining a sansolidation worksheet; then create 3-D linking formulas to the three source workbooks to summarize the data in the sansolidation worksheet
• C) she should try to export the data in the three workbooks into a database program; then create a summary report using the database report tool
• D) unfortunately, she will have to manually prepare the summary from data in the three workbooks

---

Definitions:

Judicial Review

The power of courts to assess the constitutionality of legislative acts or governmental actions and to invalidate them if they conflict with a higher law.

Factual Determinations

The process of finding the facts of the case, often decided by the jury or judge in a court proceeding.

ALJ Decisions

Rulings or judgments made by Administrative Law Judges, who conduct trial-like hearings within administrative agencies.

Findings of Fact

Are the conclusions reached by a judge or jury on the factual issues of a case.