Audra is a manager in the Sales Department for Creative Pastry Gadgets. She needs access to up-to-date financial data and sales reports. Some of this information comes from Excel workbooks, but other information is stored in other software programs. In addition, Creative Pastry Gadgets maintains a database with detailed financial information and sales figures. Audra uses Excel to analyze data from external data sources.
?
Audra wants the workbook to always display the most current values from a text file used when importing external sales data. What is the advantage of editing the properties of the connection versus editing the properties of the external data range?

A. The choices are applied to all of the external data ranges that use that connection.
B. The choices are applied only to the current workbook.
C. The choices are only applied the first time the workbook is opened after the properties have been changed.
D. There is no advantage-it would be better to edit the properties of the external data range.


Answer: A

Computer Science & Information Technology

You might also like to view...

Write a method called reverse that accepts a String parameter and returns a string that contains the characters of the parameter in reverse order. Note that there is a method in the String class that performs this operation, but for the sake of this exercise, you are expected to write your own.

What will be an ideal response?

Computer Science & Information Technology

Which one of the following is not one of the three types of events recorded in Event Viewer?

a. Alerts b. Errors c. Warnings d. Informational

Computer Science & Information Technology

The use of positive logic or negative logic:

a. Has either the true or the false proceeding to another IF/THEN/ELSE instruction. b. Has either the true of the false proceeding to execute an action and then proceed to the next instruction. c. With the exception of the last nested IF/THEN/ELSE instruction does not allow both the true and the false to execute an action. d. All of the above.

Computer Science & Information Technology

A(n) Java program is not a stand-alone applicaiton, but instead runs in conjunction with a hosting program such as a Web browser.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology