Module 11 Study Guide
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Only a few types of computers can read text files. | show 🗑
|
||||
| Text files are rarely used for storing data | show 🗑
|
||||
| Most software programs can both save and retrieve data in a text file format. | show 🗑
|
||||
| show | true
🗑
|
||||
| show | true
🗑
|
||||
| Columns in delimited text files are always vertically aligned as they would be in a spreadsheet. | show 🗑
|
||||
| show | true
🗑
|
||||
| show | true
🗑
|
||||
| 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. | show 🗑
|
||||
| The Text Import Wizard's attempt to define the number and location of columns is always correct. | show 🗑
|
||||
| show | false
🗑
|
||||
| show | true
🗑
|
||||
| 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. | show 🗑
|
||||
| show | false
🗑
|
||||
| When you save a query, you are actually placing the query choices you have made into a file. | show 🗑
|
||||
| In the last part of writing a query, you specify how to sort the data. | show 🗑
|
||||
| By modifying a query's properties, you can add new columns to your worksheet, change the sort order options, or specify a filter. | show 🗑
|
||||
| Databases such as those created in Access are examples of relational databases. | show 🗑
|
||||
| show | true
🗑
|
||||
| Although text files contain only raw, unformatted data, they are very useful in situations when you want to share data across software programs and computer systems. | show 🗑
|
||||
| show | false
🗑
|
||||
| A(n) space delimiter is often the best way of separating text columns because it permits spaces and commas within each column. | show 🗑
|
||||
| In the Text Import Wizard, the Preview window shows the initial rows of the text file. | show 🗑
|
||||
| The point at which one column ends and another begins in the Text Import Wizard is called a column cease. | show 🗑
|
||||
| In a delimited file, the delimiter automatically determines the row break. | show 🗑
|
||||
| show | false
🗑
|
||||
| Databases contain information stored in the form of lists. | show 🗑
|
||||
| Rich text formatting will result in imported data that most closely resembles the appearance of a Web page. | show 🗑
|
||||
| show | true
🗑
|
||||
| When filtering data using the Query Wizard – Filter Data dialog box, the left column specifies the type of sort you want to make in the filter, such as “equals,” “greater than,” or “less than.” | show 🗑
|
||||
| Web query files are simple XML files, so you can view and edit their contents in Notepad. | show 🗑
|
||||
| show | formulas, special fonts, graphics
🗑
|
||||
| Most software programs can both save and retrieve data in a(n) ____ file format. | show 🗑
|
||||
| show | tab, comma, space
🗑
|
||||
| One way to structure text files is to use a(n) ____. | show 🗑
|
||||
| A ____ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column. | show 🗑
|
||||
| When you use Excel to connect to a text file, the ____ Wizard determines whether the data is in a fixed-width format or a delimited format. | show 🗑
|
||||
| show | .txt
🗑
|
||||
| show | .dat, .prn, .csv
🗑
|
||||
| show | starting
🗑
|
||||
| show | clicking
🗑
|
||||
| show | clicking
🗑
|
||||
| In a ____ file, the wizard guesses the locations of the column breaks. | show 🗑
|
||||
| show | general
🗑
|
||||
| show | database
🗑
|
||||
| show | Access
🗑
|
||||
| When the location of a data source is defined as a(n) ____ location, Excel will access the connection to the data source without prompting you to confirm that the connection is secure. | show 🗑
|
||||
| show | common
🗑
|
||||
| When you want to look only at specific information from a database, you create a(n) ____. | show 🗑
|
||||
| In response to a(n) ____, a database displays the records and fields that meet the question's requirements. | show 🗑
|
||||
| A(n) ____ might ask something like, "What are the names of all the stocks in the portfolio, and what are their corresponding ticker symbols?" | show 🗑
|
||||
| show | criteria
🗑
|
||||
| What are possible data sources used to import text data to Excel: (3) | show 🗑
|
||||
| show | source
🗑
|
||||
| The following is a possible data source (three types): ____. | show 🗑
|
||||
| show | query
🗑
|
||||
| In the Query Wizard, click the ____ in front of a table name to expand the display of fields in that table. | show 🗑
|
||||
| To select fields within the Query Wizard, you can ____ the field name and Excel will automatically move it to the list of selected columns in your query. | show 🗑
|
||||
| show | filter
🗑
|
||||
| The default folder for queries is the ____ folder on the hard disk. | show 🗑
|
||||
| Queries saved in the Queries folder will display on the Queries tab of the ____ dialog box, giving you quick and easy access to your saved queries. | show 🗑
|
||||
| Microsoft Query is a(n) ____ that includes several tools that allow you to create even more complex queries. | show 🗑
|
||||
| show | background
🗑
|
||||
| show | XML
🗑
|
||||
| show | URL
🗑
|
||||
| The ____ is the address of a Web page. | show 🗑
|
||||
| The general form of a URL for a file located on your computer will be ____. | show 🗑
|
||||
| The ____ formatting only option retrieves the text from a Web query along with simple formatting, but not advanced formatting such as hyperlinks or complicated table structures. | show 🗑
|
||||
| The ____ formatting option retrieves all simple as well as advanced HTML formatting features, including hyperlinks. | show 🗑
|
||||
| show | root
🗑
|
||||
| The name of each element in an XML document is contained in a(n) ____. | show 🗑
|
||||
| Clicking a ____ in a worksheet will activate the computer's Web browser to display the Web page associated with that entry. | show 🗑
|
||||
| show | data
🗑
|
||||
| Once you insert the ____ function into a cell, the value of the cell will display the latest value retrieved from a measuring device. | show 🗑
|
||||
| By using the ____ function along with an add-in program, a scientist or researcher can save hours of data entry time and focus on analysis. | show 🗑
|
||||
| In an XML element, a(n)____ tag marks the end of the data value. | show 🗑
|
||||
| In XML, the rules about which elements are required and which are not are stored in a document called the ____. | show 🗑
|
||||
| show | 20
🗑
|
||||
| One of the advantages of using XML as a data source is that it allows you to attach, or ____, elements to a specific cell in the workbook. | show 🗑
|
||||
| One of the advantages of XML is that the XML author defines what constitutes a valid document. Documents that fail to meet the rules can be rejected by an XML program as invalid, thus ensuring ____. | show 🗑
|
||||
| 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. | show 🗑
|
||||
| show | relational
🗑
|
||||
| One way to interact with a database is with a query language. The most popular query language is ____. | show 🗑
|
||||
| When Excel imports external data into a PivotTable or PivotChart, the initial table and chart are ____. | show 🗑
|
||||
| To manually save a connection to an ODC file, use the Export ____ File button on the Definition tab of the Connection Properties dialog box to specify the name and location of your Office Data Connection file. | show 🗑
|
||||
| In order to override Excel so that it always enables data sources and refreshes the connection to the source without prompting, you should define the location of the data sources as ____. | show 🗑
|
||||
| If you are importing international data from a text file, click the ____ button in Step 3 of the Text Import Wizard to specify a different character for the decimal point and thousands separator. | show 🗑
|
||||
| show | connection
🗑
|
||||
| show | shift
🗑
|
||||
| One user wants to delete a connection to a data source. To do so, select the connection in the list in the Workbook Connections dialog box, and then click the ____ button. | show 🗑
|
||||
| show | text file
🗑
|
||||
| show | delimiter
🗑
|
||||
| show | data map
🗑
|
||||
| show | fixed width
🗑
|
||||
| In a delimited text file, the ____________________—usually a space, a comma, or a tab—automatically determines the column break. | show 🗑
|
||||
| The point at which one column ends and another begins in the Text Import Wizard is called a(n) ____________________ break. | show 🗑
|
||||
| show | elements
🗑
|
||||
| XML stands for ____________________. | show 🗑
|
||||
| show | table
🗑
|
||||
| show | field
🗑
|
||||
| show | record
🗑
|
||||
| ____________________ fields are the fields that appear in more than one table. | show 🗑
|
||||
| A(n) ____________________ is a question you ask about the data in the database. | show 🗑
|
||||
| ____________________ are the conditions that limit the number of records displayed in the results of a query. | show 🗑
|
||||
| show | data
🗑
|
||||
| show | sources
🗑
|
||||
| show | Uniform Resource Locator
🗑
|
||||
| show | pivot tables
🗑
|
||||
| When using a Web site as a data source, a(n) ____________________ specifies how data should be retrieved from the Web page and indicates exactly which parts of the Web page should be included and which parts should not be included. | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets