Different tables are combined using a ____ _____, which is a field that is present in both
tables
Give this one a try later!
common field
To connect to a text file, use the _____ ______ ______
Give this one a try later!
Text Import Wizard
A ____ ___ displays the high, low, and closing value of a stock.
,Give this one a try later!
Stock chart
To detach an Excel table from its data source, select a cell in the table, click the Table
Tools Design tab, and then, in the External Table Data group, click the ______ button
Give this one a try later!
Unlink
Cell Style is located in the _____ group of the _____ tab
Give this one a try later!
styles, home
The ____ ____ dialog box defines how and when connections to external data sources
are retrieved and updated.
Give this one a try later!
Connection Properties
A _____ is a set of guidelines that specify what values to retrieve from a database and in
what order the values should be retrieved.
, Give this one a try later!
Query
Check the _____ external data from worksheet before closing check box to remove the
external data when the file is closed, which reduces the file size, and retrieve the data
when the file is reopened.
Give this one a try later!
Remove
The _____ functions automatically format calculated values as currency
Give this one a try later!
financial
A _____ _____ contains only text and numbers without any formulas, graphics, special
fonts, or formatted text
Give this one a try later!
text file
tables
Give this one a try later!
common field
To connect to a text file, use the _____ ______ ______
Give this one a try later!
Text Import Wizard
A ____ ___ displays the high, low, and closing value of a stock.
,Give this one a try later!
Stock chart
To detach an Excel table from its data source, select a cell in the table, click the Table
Tools Design tab, and then, in the External Table Data group, click the ______ button
Give this one a try later!
Unlink
Cell Style is located in the _____ group of the _____ tab
Give this one a try later!
styles, home
The ____ ____ dialog box defines how and when connections to external data sources
are retrieved and updated.
Give this one a try later!
Connection Properties
A _____ is a set of guidelines that specify what values to retrieve from a database and in
what order the values should be retrieved.
, Give this one a try later!
Query
Check the _____ external data from worksheet before closing check box to remove the
external data when the file is closed, which reduces the file size, and retrieve the data
when the file is reopened.
Give this one a try later!
Remove
The _____ functions automatically format calculated values as currency
Give this one a try later!
financial
A _____ _____ contains only text and numbers without any formulas, graphics, special
fonts, or formatted text
Give this one a try later!
text file
