Multiple Choice
Case-Based Critical Thinking Questions
Case 11-1
Tayler is a manager in the Sales Department for BusyBody Toymakers.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,BusyBody Toymakers maintains a database with detailed financial information and sales figures.Tayler uses Excel to analyze data from external data sources.
-After opening a workbook,Tayler wants to update all of the external data ranges in the workbook.What button should she click in the Connections group on the Data tab?
A) Refresh
B) Refresh All
C) Update
D) Update All
Correct Answer:

Verified
Correct Answer:
Verified
Q4: MATCHING<br>Identify the letter of the choice that
Q6: MATCHING<br>Identify the letter of the choice that
Q6: To detach an Excel table from its
Q9: In order to override Excel so that
Q10: In the last part of writing a
Q13: In a delimited file,the delimiter automatically determines
Q14: The Text Import Wizard's attempt to define
Q15: Text files are rarely used for storing
Q16: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -In the accompanying
Q58: When you use Excel to connect to