Excel Ch6 L2
text
A _ file is often used to exchange data between dissimilar programs because the file format is recognized by nearly all applications.
Chart Format
After a chart has been pasted into PowerPoint, which of the following buttons cannot be used to modify the chart?
the column structures in the two programs match.
Before posting data into a table datasheet, make sure that
Paste Special
Copied Excel data is embedded into a Word document from the _ dialog box.
by ensuring the most current data is in the destination file
How does refreshing, modifying, and removing queries help maintain the data needed to make sound business decisions?
one
How many Access tables can be imported into Excel at a time?
yellow triangle with an exclamation mark
If you move or rename a source for a query, Excel will not know where to locate the file and a _ will appear beside the query item.
get & transform data; Data
Import data into Excel using buttons in the _ group on the _ tab
fully integrated
In the Office 365 applications, the chart feature is _ within Word, Excel, and PowerPoint.
Queries & connections task pane
One of the methods for deleting a query is to right-click the query at the _ and then click the Delete option at the pop-up menu
capturing the data at a specific time
Removing the connection between the source file and the destination file allows which of the following?
no
Text files contain _ formatting.
Comma
The CSV text file format is _ demlimited.
constant
The TEXTJOIN feature uses a(n) _ delimiter.
.txt
The text file format for use with the Apple operating system (Macintosh computers) is designated by the _ file extension.
right-clicking the linked object
To break a link, begin by opening the document and then
Query Editor window
To display the _ before data is imported, click the Edit button at the navigator dialog box.
text
To exchange Excel data with someone who is not able to import a worksheet or cannot copy and paste using the clipboard, you should save the data as a(n) _ file.
Import; Access
To export Excel data to an Access database that does not have an existing table in which to receive the data, perform an _ routine from _.
copy and paste
To use Excel data in Word, PowerPoint, or Access, you should use the _ method, because applications in Office 365 are designed for integration.
text
UPPER and LOWER are considered _ functions.
Flash fill
Use Excel's _ feature to extract, join, and insert text, numbers, dates, and times.
CONCAT
Use the _ function to join the content of two or more cells.
to remove extra spaces between characters
What is the purpose of the TRIM function?
the data in the Word document will no longer be connected to the data in the Excel workbook
When Excel data is linked to a word document, breaking that link means that
CSV
When searching for a file to import, Excel displays a lsit of all the files in the active folder ending with .prn, .txt, and _ file extensions.
will not likely be updated later
When transferring data from Excel to Word, you should use the copy and paste method if the data being brought into the Word document
Flash Fill
When using the _ feature, you may have enter a few rows of data before Excel recognizes the pattern
only in Excel
When you link Excel data to a Word document, the source data exists
TOTAl
Which of the following will be returned by the formula =UPPER("total")?
