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")?