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

Question 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

Answer 1

C

Question 2

All of the following are common formats used to import data into Excel EXCEPT ________.

A)ODBC
B)HTML
C)XML
D))accdb

Answer 2

A

Question 3

In a tab-delimited file,________ separate the data.

A)commas
B)tabs
C)spaces
D)hyphens

Answer 3

B

Question 4

Which of the following is NOT a text file?

A)Tab-delimited
B)Comma-separated
C)XML
D)Space-delimited

Question 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

Question 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.

Question 7

An XML document uses ________ that include start tags,end tags and the data itself.

A)map
B)markup
C)schema
D)elements

Question 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.

Question 9

________ is the standard for transmitting data between applications and systems.

A)Web query
B)Text file
C)XML
D)Metadata

Question 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

Question 11

HTML and XML are both examples of ________.

A)markup languages
B)web query sources
C)tags
D)multimedia

Question 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

Question 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.

Question 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

Question 15

External data connections for Excel can be found on the ________ tab.

A)Insert
B)View
C)Data
D)File

Question 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.

Question 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

Question 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.

Question 19

________ are markup indicators in an XML document used to identify the data.

A)Brackets
B)Processors
C)Parenthesis
D)Tags

Question 20

is an example of a(n)________.

A)HTML tag
B)metadata
C)XML tag
D)delimiter

Question 21

Data ________ is a process that validates data so that it is accurate.

A)functioning
B)testing
C)verification
D)validation

Question 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

Question 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

Question 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.

Question 25

To change the text string jaMEs sMITh to James Smith,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE

Question 26

If cell A2 contains the string "Excel 2013",then =________(A2)will return the number "10".

A)LEFT
B)COUNT
C)LEN
D)MID

Question 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.

Question 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

Question 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.

Question 30

To remove any nonprinting characters from a text string,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE

Question 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

Question 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

Question 33

To change the word apple with orange in a string of text,use the ________ function.

A)SUBSTITUTE
B)PROPER
C)CONCATENATE
D)REPLACE

Question 34

To remove all spaces from text except for single spaces between words,use the ________ function.

A)CLEAN
B)PROPER
C)TRIM
D)SUBSTITUTE

Question 35

A social security number is commonly used as a ________ key.

A)primary
B)foreign
C)super
D)secondary

Question 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

Question 37

An Access database uses a ________ field to uniquely identify a record.

A)primary key
B)foreign key
C)super key
D)data key

Question 38

Data ________ is a process that converts data into a useful format by fixing obvious errors.

A)validation
B)testing
C)verification
D)cleansing

Question 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

Question 40

To change the text string James Smith to JAMES SMITH,use the ________ function.

A)UPPER
B)LOWER
C)PROPER
D)CONCATENATE

Question 41

The ________ Wizard separates text files into their respective columns.

A)FIND
B)REPLACE
C)Data verification
D)Convert Text to Columns

Question 42

Most people prefer to use Access over Excel to chart and analyze data.

Question 43

Anything that is NOT stored in an Excel format or NOT stored locally is considered to be an external data set.

Question 44

Text files can contain fonts,images,and hyperlinks.

Question 45

Commas are the only delimiter allowed for text files.

Question 46

A delimiter is just a way of indicating the beginning and end of a text data segment.

Question 47

Copy and pasting data from a website and using a web query have the same result.

Question 48

Excel import file types are limited to only two types of files,HTML and XML.

Question 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.

Question 50

One popular way to integrate information from web pages is to use a Data Connection Wizard.

Question 51

There is NOT a prespecified standard for XML tags.

Question 52

Excel has the ability to consolidate diverse types of data.

Question 53

Some companies use Internet queries on their websites to make their data available to users.

Question 54

Text files have no metadata associated with them.

Question 55

With XML,the content,format,and structure are contained in a single document.

Question 56

Text files are imported into Excel in a similar manner as XML and HTML files.

Question 57

HTML describes the content of the data between tags.

Question 58

Most organizations keep their information in one single data source.

Question 59

A web query will always be able to access information even when the URL changes.

Question 60

Two of the most common text file types that use delimiters are .csv and .txt.

Question 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.

Question 62

An Excel web query creates a(n)________ to the original web page so that you will have the most up-to-date data .

Question 63

A(n)________ is a file structured by the use of delimiters.

Question 64

Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices.

Question 65

Formatting for an XML document is saved with the ________ file extension.

Question 66

Data on web pages is not stored in an organized manner; therefore,________ was created to give structure to web page data.

Question 67

The MONTH function returns the name of the month.For example 11/11/2013 would return November.

Question 68

With ________,tags are prespecified and are used to tell the browser how to display the web data.

Question 69

Conditional formatting can aid in removing duplicate data.

Question 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.

Question 71

A(n)________ document is saved as an .xsd file.

Question 72

Access database tables are the only element that can be imported into Excel.

Question 73

The DATEVALUE function can be used to calculate the number of available work days between two given dates.

Question 74

With ________,tags are customized for content of a specific industry.

Question 75

Excel cannot connect to an Access database; rather,data must be copied and pasted into a spreadsheet.

Question 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.

Question 77

Excel cannot create permanent connections between an Access databases and an Excel spreadsheet.

Question 78

Text functions help to extract and standardize data.

Question 79

Data cleansing is the process of validating that the data is correct and accurate.

Question 80

Flash Fill recognizes patterns in data as you type and automatically fills in values for text and numeric data.