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:

Sexual Harassment

Unwelcome sexual advances, requests for sexual favors, and other verbal or physical harassment of a sexual nature in the workplace or other professional or social situations.

Discrimination

Unfair or prejudiced treatment of different categories of people, especially on the grounds of race, age, or sex.

Human Rights Tribunals

Specialized courts or bodies that adjudicate disputes arising from alleged violations of human rights laws.

Sexual Harassment

Unwelcome sexual advances, requests for sexual favors, or other verbal or physical harassment of a sexual nature.