Deck 9: Organize, import, export, and Cleanse Data Sets

Full screen (f)
exit full mode
Question
The following is an example of the ________ data type.
ProductNum,ProductName,DateShipped,Quantity Shipped
59313,XL Golf Shirts,3/15/13,35
72316,Men's Shoe,2/5/13,10
47423,Head covers,3/6/13,20

A)tab delimited
B)space delimited
C)comma separated
D)font delimited
Use Space or
up arrow
down arrow
to flip the card.
Question
All of the following are common formats used to import data into Excel EXCEPT ________.

A)ODBC
B)HTML
C)XML
D))accdb
Question
In a tab-delimited file,________ separate the data.

A)commas
B)tabs
C)spaces
D)hyphens
Question
Which of the following is NOT a text file?

A)Tab-delimited
B)Comma-separated
C)XML
D)Space-delimited
Question
________ is a web language that was created to tell the browser how to properly display the web page.

A)HTML
B)XML
C)VBA
D)Query
Question
All of the following statements are TRUE about importing XML data EXCEPT:

A)XML is an increasingly popular tool working behind the scenes in Excel.
B)XML allows users to define their own tags in order to define the content of the document.
C)XML and HTML are examples of markup languages.
D)Most web pages are programmed in XML.
Question
An XML document uses ________ that include start tags,end tags and the data itself.

A)map
B)markup
C)schema
D)elements
Question
All of the following statements are TRUE about the importance of external data sets EXCEPT:

A)By using the external tools, you can avoid a lot of extra typing.
B)Anything that is not stored in an Excel format or not stored locally is considered to be external data.
C)Spreadsheet applications such as Excel offer a wide variety of tools to help the user extract external data and integrate it into reports so that it can be actively used to make better decisions.
D)Common file formats that you can import include HTML, XML, text, and .accdb files from Microsoft Access.
Question
________ is the standard for transmitting data between applications and systems.

A)Web query
B)Text file
C)XML
D)Metadata
Question
A(n)________ is a way of indicating the beginning and end of a text data segment.

A)metadata
B)delimiter
C)schema
D)element
Question
HTML and XML are both examples of ________.

A)markup languages
B)web query sources
C)tags
D)multimedia
Question
To save a web query in Excel,use the ________ on the Data tab.

A)Data Validation command
B)Connections command
C)Edit Links command
D)Properties
Question
All of the following statements are TRUE about using an Excel web query EXCEPT:

A)One popular way to integrate information from web pages is to use a web query.
B)An example of a web query could be stock prices from a financial website such as http://money.msn.com.
C)A web query is something you could type into a search engine such as Google or Bing in order to search the web.
D)A query is a question that you would ask a database such as Access.
Question
A(n)________ is a question that you would ask a database to search for information.

A)data question
B)query
C)QWERTY
D)inquiry
Question
External data connections for Excel can be found on the ________ tab.

A)Insert
B)View
C)Data
D)File
Question
Which of the following is NOT true of text files?

A)Text files do not contain graphics.
B)Text files are also called ASCII files.
C)Text files contain formatting.
D)Text files are larger than XML files.
Question
________ is a markup language that was created to give structure to web page data so that it could be searched more efficiently.

A)HTML
B)XML
C)VBA
D)Query
Question
All of the following are advantages of a web query EXCEPT:

A)Information is kept up-to-date because it connects with the website for the most current information.
B)Web queries update the URL automatically when the URL changes.
C)Connections can be shared with other users.
D)Web queries can be used by other Microsoft Office applications.
Question
________ are markup indicators in an XML document used to identify the data.

A)Brackets
B)Processors
C)Parenthesis
D)Tags
Question
is an example of a(n)________.

A)HTML tag
B)metadata
C)XML tag
D)delimiter
Question
Data ________ is a process that validates data so that it is accurate.

A)functioning
B)testing
C)verification
D)validation
Question
The following is an example of the ________ data type.
PNum PName Shipped Quantity
59313 XL_Golf_Shirts 3_15_13 35
72316 Mens_Shoe 2_5_13 10
47423 Head_covers 3_6_/13 20

A)tab delimited
B)space delimited
C)comma separated
D)font delimited
Question
To import a text file into Excel with all the text import features,click the ________ tab.

A)Data
B)New
C)Info
D)Options
Question
All of the following statements are TRUE about the Text Import Wizard data EXCEPT:

A)Sometimes Excel will incorrectly identify the language used in the text file, and this may throw off the Text Import Wizard.
B)The Text Import Wizard does have file size limitations, and occasionally you will get a text file that is too big to import into Excel.
C)If you do not want to include all the headings or if there is a comment at the beginning of the file, you can tell Excel to start in any row below a target row so it will omit extraneous text.
D)The Text Import Wizard that can be initiated by clicking the From Text button on the External Data tab.
Question
To change the text string jaMEs sMITh to James Smith,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Question
If cell A2 contains the string "Excel 2013",then =________(A2)will return the number "10".

A)LEFT
B)COUNT
C)LEN
D)MID
Question
All of the following statements are TRUE about cleansing data EXCEPT:

A)Data cleansing is the process of fixing obvious errors in the data and converting the data into a useful format.
B)Data cleansing is not data verification.
C)Data verification is the process of validating that the data is correct and accurate.
D)Data cleansing is very costly both in time and money.
Question
When a primary key from one table is connected to another table,it is said to be a ________ key.

A)primary
B)foreign
C)super
D)secondary
Question
All of the following statements are TRUE about connecting to an Access database EXCEPT:

A)You can copy and paste data from an Access table into a blank Excel worksheet.
B)Within Access, users have the option of exporting tabular data into an Excel format.
C)For longer-term projects, a permanent connection between an Access database and the Excel application can be created by using the Access Data Connect feature.
D)Live data from a permanent connection can be imported as a simple table, or even a PivotTable report or PivotChart.
Question
To remove any nonprinting characters from a text string,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Question
________ are functions that manipulate data to clean it up and make it useful.

A)Text functions
B)Data functions
C)Data verification
D)Data cleansing
Question
You can import tables and queries from Access by dragging the object from the ________ and dropping it into the desired starting cell.

A)Navigation Pane
B)Data Import window
C)XML Schema pane
D)data connection
Question
To change the word apple with orange in a string of text,use the ________ function.

A)SUBSTITUTE
B)PROPER
C)CONCATENATE
D)REPLACE
Question
To remove all spaces from text except for single spaces between words,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Question
A social security number is commonly used as a ________ key.

A)primary
B)foreign
C)super
D)secondary
Question
If cell A2 contains the text string "red shorts",then =________(A2,3)will return the word "red".

A)LEFT
B)SEARCH
C)LEN
D)MID
Question
An Access database uses a ________ field to uniquely identify a record.

A)primary key
B)foreign key
C)super key
D)data key
Question
Data ________ is a process that converts data into a useful format by fixing obvious errors.

A)validation
B)testing
C)verification
D)cleansing
Question
________ is a special tool that makes it easy to connect Excel to an Access database.

A)Microsoft Query
B)Data connections
C)Excel Query
D)SQL Server
Question
To change the text string James Smith to JAMES SMITH,use the ________ function.

A)UPPER
B)LOWER
C)PROPER
D)CONCATENATE
Question
The ________ Wizard separates text files into their respective columns.

A)FIND
B)REPLACE
C)Data verification
D)Convert Text to Columns
Question
Most people prefer to use Access over Excel to chart and analyze data.
Question
Anything that is NOT stored in an Excel format or NOT stored locally is considered to be an external data set.
Question
Text files can contain fonts,images,and hyperlinks.
Question
Commas are the only delimiter allowed for text files.
Question
A delimiter is just a way of indicating the beginning and end of a text data segment.
Question
Copy and pasting data from a website and using a web query have the same result.
Question
Excel import file types are limited to only two types of files,HTML and XML.
Question
All of the following statements are TRUE about using Flash Fill to cleanse data EXCEPT:

A)Flash Fill works by examining the pattern of data in the cell next to where you are typing.
B)Flash Fill recognizes patterns in data as you type and automatically fills in values for text and date data.
C)For Flash Fill to work, you must type in an adjoining column or row to your existing data.
D)Flash Fill can make data cleansing easier and faster than using traditional text functions.
Question
One popular way to integrate information from web pages is to use a Data Connection Wizard.
Question
There is NOT a prespecified standard for XML tags.
Question
Excel has the ability to consolidate diverse types of data.
Question
Some companies use Internet queries on their websites to make their data available to users.
Question
Text files have no metadata associated with them.
Question
With XML,the content,format,and structure are contained in a single document.
Question
Text files are imported into Excel in a similar manner as XML and HTML files.
Question
HTML describes the content of the data between tags.
Question
Most organizations keep their information in one single data source.
Question
A web query will always be able to access information even when the URL changes.
Question
Two of the most common text file types that use delimiters are .csv and .txt.
Question
Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.
Question
An Excel web query creates a(n)________ to the original web page so that you will have the most up-to-date data .
Question
A(n)________ is a file structured by the use of delimiters.
Question
Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.
Question
Formatting for an XML document is saved with the ________ file extension.
Question
Data on web pages is not stored in an organized manner; therefore,________ was created to give structure to web page data.
Question
The MONTH function returns the name of the month.For example 11/11/2013 would return November.
Question
With ________,tags are prespecified and are used to tell the browser how to display the web data.
Question
Conditional formatting can aid in removing duplicate data.
Question
Excel users can import data from a variety of sources including ________,which is anything that is neither stored in an Excel format nor stored locally.
Question
A(n)________ document is saved as an .xsd file.
Question
Access database tables are the only element that can be imported into Excel.
Question
The DATEVALUE function can be used to calculate the number of available work days between two given dates.
Question
With ________,tags are customized for content of a specific industry.
Question
Excel cannot connect to an Access database; rather,data must be copied and pasted into a spreadsheet.
Question
You can import tables and queries from Access by dragging the object from the Navigation Pane and dropping it into the desired starting cell.
Question
Excel cannot create permanent connections between an Access databases and an Excel spreadsheet.
Question
Text functions help to extract and standardize data.
Question
Data cleansing is the process of validating that the data is correct and accurate.
Question
Flash Fill recognizes patterns in data as you type and automatically fills in values for text and numeric data.
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/100
auto play flashcards
Play
simple tutorial
Full screen (f)
exit full mode
Deck 9: Organize, import, export, and Cleanse Data Sets
1
The following is an example of the ________ data type.
ProductNum,ProductName,DateShipped,Quantity Shipped
59313,XL Golf Shirts,3/15/13,35
72316,Men's Shoe,2/5/13,10
47423,Head covers,3/6/13,20

A)tab delimited
B)space delimited
C)comma separated
D)font delimited
C
2
All of the following are common formats used to import data into Excel EXCEPT ________.

A)ODBC
B)HTML
C)XML
D))accdb
A
3
In a tab-delimited file,________ separate the data.

A)commas
B)tabs
C)spaces
D)hyphens
B
4
Which of the following is NOT a text file?

A)Tab-delimited
B)Comma-separated
C)XML
D)Space-delimited
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
5
________ is a web language that was created to tell the browser how to properly display the web page.

A)HTML
B)XML
C)VBA
D)Query
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
6
All of the following statements are TRUE about importing XML data EXCEPT:

A)XML is an increasingly popular tool working behind the scenes in Excel.
B)XML allows users to define their own tags in order to define the content of the document.
C)XML and HTML are examples of markup languages.
D)Most web pages are programmed in XML.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
7
An XML document uses ________ that include start tags,end tags and the data itself.

A)map
B)markup
C)schema
D)elements
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
8
All of the following statements are TRUE about the importance of external data sets EXCEPT:

A)By using the external tools, you can avoid a lot of extra typing.
B)Anything that is not stored in an Excel format or not stored locally is considered to be external data.
C)Spreadsheet applications such as Excel offer a wide variety of tools to help the user extract external data and integrate it into reports so that it can be actively used to make better decisions.
D)Common file formats that you can import include HTML, XML, text, and .accdb files from Microsoft Access.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
9
________ is the standard for transmitting data between applications and systems.

A)Web query
B)Text file
C)XML
D)Metadata
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
10
A(n)________ is a way of indicating the beginning and end of a text data segment.

A)metadata
B)delimiter
C)schema
D)element
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
11
HTML and XML are both examples of ________.

A)markup languages
B)web query sources
C)tags
D)multimedia
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
12
To save a web query in Excel,use the ________ on the Data tab.

A)Data Validation command
B)Connections command
C)Edit Links command
D)Properties
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
13
All of the following statements are TRUE about using an Excel web query EXCEPT:

A)One popular way to integrate information from web pages is to use a web query.
B)An example of a web query could be stock prices from a financial website such as http://money.msn.com.
C)A web query is something you could type into a search engine such as Google or Bing in order to search the web.
D)A query is a question that you would ask a database such as Access.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
14
A(n)________ is a question that you would ask a database to search for information.

A)data question
B)query
C)QWERTY
D)inquiry
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
15
External data connections for Excel can be found on the ________ tab.

A)Insert
B)View
C)Data
D)File
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
16
Which of the following is NOT true of text files?

A)Text files do not contain graphics.
B)Text files are also called ASCII files.
C)Text files contain formatting.
D)Text files are larger than XML files.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
17
________ is a markup language that was created to give structure to web page data so that it could be searched more efficiently.

A)HTML
B)XML
C)VBA
D)Query
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
18
All of the following are advantages of a web query EXCEPT:

A)Information is kept up-to-date because it connects with the website for the most current information.
B)Web queries update the URL automatically when the URL changes.
C)Connections can be shared with other users.
D)Web queries can be used by other Microsoft Office applications.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
19
________ are markup indicators in an XML document used to identify the data.

A)Brackets
B)Processors
C)Parenthesis
D)Tags
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
20
is an example of a(n)________.

A)HTML tag
B)metadata
C)XML tag
D)delimiter
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
21
Data ________ is a process that validates data so that it is accurate.

A)functioning
B)testing
C)verification
D)validation
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
22
The following is an example of the ________ data type.
PNum PName Shipped Quantity
59313 XL_Golf_Shirts 3_15_13 35
72316 Mens_Shoe 2_5_13 10
47423 Head_covers 3_6_/13 20

A)tab delimited
B)space delimited
C)comma separated
D)font delimited
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
23
To import a text file into Excel with all the text import features,click the ________ tab.

A)Data
B)New
C)Info
D)Options
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
24
All of the following statements are TRUE about the Text Import Wizard data EXCEPT:

A)Sometimes Excel will incorrectly identify the language used in the text file, and this may throw off the Text Import Wizard.
B)The Text Import Wizard does have file size limitations, and occasionally you will get a text file that is too big to import into Excel.
C)If you do not want to include all the headings or if there is a comment at the beginning of the file, you can tell Excel to start in any row below a target row so it will omit extraneous text.
D)The Text Import Wizard that can be initiated by clicking the From Text button on the External Data tab.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
25
To change the text string jaMEs sMITh to James Smith,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
26
If cell A2 contains the string "Excel 2013",then =________(A2)will return the number "10".

A)LEFT
B)COUNT
C)LEN
D)MID
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
27
All of the following statements are TRUE about cleansing data EXCEPT:

A)Data cleansing is the process of fixing obvious errors in the data and converting the data into a useful format.
B)Data cleansing is not data verification.
C)Data verification is the process of validating that the data is correct and accurate.
D)Data cleansing is very costly both in time and money.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
28
When a primary key from one table is connected to another table,it is said to be a ________ key.

A)primary
B)foreign
C)super
D)secondary
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
29
All of the following statements are TRUE about connecting to an Access database EXCEPT:

A)You can copy and paste data from an Access table into a blank Excel worksheet.
B)Within Access, users have the option of exporting tabular data into an Excel format.
C)For longer-term projects, a permanent connection between an Access database and the Excel application can be created by using the Access Data Connect feature.
D)Live data from a permanent connection can be imported as a simple table, or even a PivotTable report or PivotChart.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
30
To remove any nonprinting characters from a text string,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
31
________ are functions that manipulate data to clean it up and make it useful.

A)Text functions
B)Data functions
C)Data verification
D)Data cleansing
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
32
You can import tables and queries from Access by dragging the object from the ________ and dropping it into the desired starting cell.

A)Navigation Pane
B)Data Import window
C)XML Schema pane
D)data connection
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
33
To change the word apple with orange in a string of text,use the ________ function.

A)SUBSTITUTE
B)PROPER
C)CONCATENATE
D)REPLACE
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
34
To remove all spaces from text except for single spaces between words,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
35
A social security number is commonly used as a ________ key.

A)primary
B)foreign
C)super
D)secondary
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
36
If cell A2 contains the text string "red shorts",then =________(A2,3)will return the word "red".

A)LEFT
B)SEARCH
C)LEN
D)MID
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
37
An Access database uses a ________ field to uniquely identify a record.

A)primary key
B)foreign key
C)super key
D)data key
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
38
Data ________ is a process that converts data into a useful format by fixing obvious errors.

A)validation
B)testing
C)verification
D)cleansing
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
39
________ is a special tool that makes it easy to connect Excel to an Access database.

A)Microsoft Query
B)Data connections
C)Excel Query
D)SQL Server
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
40
To change the text string James Smith to JAMES SMITH,use the ________ function.

A)UPPER
B)LOWER
C)PROPER
D)CONCATENATE
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
41
The ________ Wizard separates text files into their respective columns.

A)FIND
B)REPLACE
C)Data verification
D)Convert Text to Columns
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
42
Most people prefer to use Access over Excel to chart and analyze data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
43
Anything that is NOT stored in an Excel format or NOT stored locally is considered to be an external data set.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
44
Text files can contain fonts,images,and hyperlinks.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
45
Commas are the only delimiter allowed for text files.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
46
A delimiter is just a way of indicating the beginning and end of a text data segment.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
47
Copy and pasting data from a website and using a web query have the same result.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
48
Excel import file types are limited to only two types of files,HTML and XML.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
49
All of the following statements are TRUE about using Flash Fill to cleanse data EXCEPT:

A)Flash Fill works by examining the pattern of data in the cell next to where you are typing.
B)Flash Fill recognizes patterns in data as you type and automatically fills in values for text and date data.
C)For Flash Fill to work, you must type in an adjoining column or row to your existing data.
D)Flash Fill can make data cleansing easier and faster than using traditional text functions.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
50
One popular way to integrate information from web pages is to use a Data Connection Wizard.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
51
There is NOT a prespecified standard for XML tags.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
52
Excel has the ability to consolidate diverse types of data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
53
Some companies use Internet queries on their websites to make their data available to users.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
54
Text files have no metadata associated with them.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
55
With XML,the content,format,and structure are contained in a single document.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
56
Text files are imported into Excel in a similar manner as XML and HTML files.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
57
HTML describes the content of the data between tags.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
58
Most organizations keep their information in one single data source.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
59
A web query will always be able to access information even when the URL changes.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
60
Two of the most common text file types that use delimiters are .csv and .txt.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
61
Excel has a query wizard built into its Microsoft Query function that can be a very powerful aid for linking a worksheet to an Access database.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
62
An Excel web query creates a(n)________ to the original web page so that you will have the most up-to-date data .
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
63
A(n)________ is a file structured by the use of delimiters.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
64
Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
65
Formatting for an XML document is saved with the ________ file extension.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
66
Data on web pages is not stored in an organized manner; therefore,________ was created to give structure to web page data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
67
The MONTH function returns the name of the month.For example 11/11/2013 would return November.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
68
With ________,tags are prespecified and are used to tell the browser how to display the web data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
69
Conditional formatting can aid in removing duplicate data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
70
Excel users can import data from a variety of sources including ________,which is anything that is neither stored in an Excel format nor stored locally.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
71
A(n)________ document is saved as an .xsd file.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
72
Access database tables are the only element that can be imported into Excel.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
73
The DATEVALUE function can be used to calculate the number of available work days between two given dates.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
74
With ________,tags are customized for content of a specific industry.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
75
Excel cannot connect to an Access database; rather,data must be copied and pasted into a spreadsheet.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
76
You can import tables and queries from Access by dragging the object from the Navigation Pane and dropping it into the desired starting cell.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
77
Excel cannot create permanent connections between an Access databases and an Excel spreadsheet.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
78
Text functions help to extract and standardize data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
79
Data cleansing is the process of validating that the data is correct and accurate.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
80
Flash Fill recognizes patterns in data as you type and automatically fills in values for text and numeric data.
Unlock Deck
Unlock for access to all 100 flashcards in this deck.
Unlock Deck
k this deck
locked card icon
Unlock Deck
Unlock for access to all 100 flashcards in this deck.