Question 1

Eliminating columns using the Text Import Wizard is useful when there are only a few items you want to import from a large text file containing many columns.

Accepted Answer

When using the Text Import Wizard, you can specify which columns to include in the import process, allowing you to eliminate columns that are not needed.

Question 2

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

Accepted Answer

False

Question 3

Databases such as those created in Access are examples of relational databases.

Accepted Answer

Access creates relational databases where data is stored in related tables and can be queried and analyzed through relationships between the tables.

Question 4

Text files are rarely used for storing data.

Accepted Answer

Text files are commonly used for storing data, especially in scenarios where the data needs to be easily readable and editable by humans.

Question 5

If a break is in the wrong location in the Data preview window,you double-click it to move it to a new location in the window.

Accepted Answer

Double-clicking a break in the Data preview window typically removes it, rather than moving it to a new location.

Question 6

In the last part of writing a query,you specify how to sort the data.

Accepted Answer

In a query, you can specify the sorting of the data using the "ORDER BY" clause.

Question 7

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you do not want to import.

Accepted Answer

This is true. In the Text Import Wizard, you can select which columns to import and which ones to skip or omit.

Question 8

By modifying a query's properties,you can add new columns to your worksheet,change the sort order options,or specify a filter.

Accepted Answer

Modifying a query's properties allows you to add new columns, change the sort order, and apply filters to your worksheet.

Question 9

In addition to delimited text,you can also organize data with a fixed-width file.

Accepted Answer

Yes, it is true that data can be organized with a fixed-width file format, where each field has a set number of characters. This is often used in legacy systems or for compatibility with mainframe environments.

Question 10

Most software programs can both save and retrieve data in a text file format.

Accepted Answer

Most software programs, such as word processors, spreadsheets, and databases, have the capability to both save and retrieve data in a text file format, which allows the data to be easily shared and manipulated between different software applications. However, some specialized software may not have this capability or may use proprietary file formats.

Question 11

When using the Text Import Wizard,you can specify a column's format before the column is imported.

Accepted Answer

When using the Text Import Wizard, you can select the data type and format for each column before importing the data. This allows you to ensure that the data is properly formatted and usable in your spreadsheet or database.

Question 12

By default,the Text Import Wizard will start importing text with the first row of the file.

Accepted Answer

The Text Import Wizard assumes that the first row of the file contains the column headers, so it starts importing text from the second row by default. However, it is possible to change this setting during the import process.

Question 13

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Accepted Answer

Excel can save a workbook as a text file in which it preserves only the data values and discards any formatting applied to it.

Question 14

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Accepted Answer

The Text Import Wizard in Excel uses a delimiter to determine the start and end points of each column. In the case of a fixed-width text file, the delimiter is a set number of fixed characters between each column. Therefore, there is a way for the Text Import Wizard to know where each column begins and ends.

Question 15

When you save a query,you are actually placing the query choices you have made into a file.

Accepted Answer

When you save a query, you are saving the selected query options and criteria into a file format such as SQL, which can be used for future reference or analysis.

Question 16

Excel can open a text file into a worksheet,where you can then format it as you would any data.

Accepted Answer

Excel can indeed open a text file and import it into a worksheet for formatting as any other data.

Question 17

Microsoft supports a library of built-in Web queries.

Accepted Answer

Microsoft does support a library of built-in Web queries. These queries allow users to pull data from websites directly into Excel.

Question 18

Only a few types of computers can read text files.

Accepted Answer

Almost all types of computers can read text files, as they are one of the most basic file formats.

Question 19

The Text Import Wizard's attempt to define the number and location of columns is always correct.

Accepted Answer

The Text Import Wizard's attempt to define the number and location of columns is not always correct, as it depends on the formatting of the data being imported. Users should always review and adjust the column definitions as needed.

Question 20

You cannot specify how you want the data to appear in a query.

Accepted Answer

You can specify how you want the data to appear in a query by using SQL commands such as SELECT, FROM, WHERE, ORDER BY, GROUP BY, and more. These commands allow you to filter, sort, and format data in a variety of ways to meet your specific needs.

Quiz 11: Connecting to External Data