chapter 9

Formatting for an XML document is saved with the ___________ file extension. (1 point)

.xsl

With ________, tags are customized for use with content of a specific industry. (1 point)

: XML

________ is the standard for transmitting data between applications and systems. (1 point) Web query Text file Metadata XML

=XML

o remove any nonprinting characters from a text string, use the ________ function. (1 point) CLEAN FIND PROPER TRIM

CLEAN

The _______________ function could be used to make sandbox out of the two words sand and box. (1 point)

CONCATENATE

To save a web query in Excel, use the ________ on the Data tab. (1 point) Properties Connections command Data Validation command Edit Links command

Connections command

The ________ Wizard separates text files into their respective columns. (1 point) FIND REPLACE Data verification Convert Text to Columns

Convert Text to Columns

External data connections for Excel can be found on the ________ tab. (1 point) Data Insert View File

Data

To import a text file into Excel with all the text import features, click the ________ tab. (1 point) Options Data New Info

Data

Which of the following statements is FALSE? (1 point) Data verification is the process of validating that the data is correct and accurate. Data cleansing is not data verification. Data cleansing is the process of fixing obvious errors in the data and converting the data into a useful format. Data cleansing is very costly both in time and money.

Data cleansing is very costly both in time and money.

csv -

Data stored in a comma-delimited format

XML -

Data stored in the Extensible Markup Language format

XML schema -

Describes the structure of an XML document

.txt -

Exchange data between mainframes and other systems stored in a text format

53) With XML, the content, format, and structure are contained in a single document. (1 point) True False

False

A web query will always be able to access information even when the URL changes. (1 point) True False

False

Commas are the only delimiter allowed for text files. (1 point) True False

False

Copy and pasting data from a website and using a web query have the same result. (1 point) True False

False

Data cleansing is the process of validating that the data is correct and accurate. (1 point) True False

False

Excel cannot connect to an Access database; rather, data must be copied and pasted into a spreadsheet. (1 point) True False

False

Excel cannot create permanent connections between an Access database and an Excel spreadsheet. (1 point) True False

False

Excel import file types are limited to only two types of files, HTML and XML. (1 point) True False

False

Flash Fill involves more typing than traditional text functions and can be more difficult to use on touch-enabled devices. (1 point) True False

False

HTML describes the content of the data between tags. (1 point) True False

False

Most organizations keep their information in one single data source. (1 point) True False

False

Most people prefer to use Access over Excel to chart and analyze data. (1 point) True False

False

One popular way to integrate information from web pages is to use a Data Connection Wizard. (1 point) True False

False

Some companies use Internet queries on their websites to make their data available to users. (1 point) True False

False

The DATEVALUE function can be used to calculate the number of available work days between two given dates. (1 point) True False

False

The MONTH function returns the name of the month. For example 11/11/2018 would return November. (1 point) true False

False

________ works by examining the pattern of data in the cell next to where you are typing. (1 point) Flash Fill Validation Cleansing Live data

Flash Fill

__________________ recognizes patterns in data as you type and automatically fills in values for text and numeric data. (1 point)

Flash Fill

With ______________, tags are prespecified and are used to tell the browser how to display the web data. (1 point)

HTML

________ is a web language that was created to tell the browser how to properly display a web page. (1 point) VBA Query HTML XML

HTML

If cell A2 contains the text string "red shorts", then =________(A2,3) will return the word "red". (1 point) LEFT MID LEN SEARCH

LEFT

If cell A2 contains the string "Excel 2016", then =________(A2) will return the number "10". (1 point) MID COUNT LEN LEFT

LEN

HTML -

Link to data stored in tabular form on websites

________ data from a permanent connection can be imported as a simple table, a PivotTable report, or PivotChart. (1 point) Formatted Static Unformatted Live

Live

__________ is data about data such as source information, key words, and captions. (1 point)

Metadata

________ is a special tool that makes it easy to connect Excel to an Access database. (1 point) Data connections Excel Query SQL Server Microsoft Query

Microsoft Query

All of the following statements are TRUE about importing XML data EXCEPT: (1 point) XML and HTML are examples of markup languages. XML allows users to define their own tags in order to define the content of the document. Most web pages are programmed in XML. XML is an increasingly popular tool working behind the scenes in Excel.

Most web pages are programmed in XML.

You can import tables and queries from Access by dragging the object from the ________ and dropping it into the desired starting cell. (1 point) Data Import window data connection Navigation Pane XML Schema pane

Navigation Pane

Which of the following are common formats cannot be imported into Excel? (1 point) ODBC .accdb HTML XML

ODBC

To change the text string jaMEs sMITh to James Smith, use the ________ function. (1 point) TRIM PROPER CLEAN CONVERT

PROPER

o change the word apple with orange in a string of text, use the ________ function. (1 point) PROPER CONCATENATE REPLACE SUBSTITUTE

SUBSTITUTE

To remove all spaces from text except for single spaces between words, use the ________ function. (1 point) TRIM CLEAN PROPER SUBSTITUTE

TRIM

Use the ________________ function when you want to remove spaces at the beginning or end of a string.

TRIM

________ are markup indicators in an XML document used to identify the data. (1 point) Processors Tags Parenthesis Brackets

Tags

The _________ does have file size limitations, and occasionally you will get a text file that is too big to import into Excel. (1 point) Text Update Wizard Text Import Wizard Data Import Wizard Data Update Wizard

Text Import Wizard

Which of the following is NOT true about text files? (1 point) Text files do not contain graphics. Text files are larger than XML files. Text files contain formatting. Text files are also called ASCII files.

Text files contain formatting.

________ are functions that manipulate data to clean it up and make it useful. (1 point) Data verification Data cleansing Data functions Text functions

Text functions

58) Two of the most common text file types that use delimiters are .csv and .txt. (1 point) True False

True

A delimiter is a way of indicating the beginning and end of a text data segment. (1 point) True False

True

Anything that is not stored in an Excel format or not stored locally is considered to be an external data set. (1 point) True False

True

Conditional formatting can aid in removing duplicate data. (1 point) True False

True

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. (1 point) True False

True

Flash Fill recognizes patterns in data as you type and automatically fills in values for text and numeric data. (1 point) True False

True

Text files are imported into Excel in a similar manner as XML and HTML files. (1 point) True False

True

Text files have no metadata associated with them. (1 point) True False

True

Text functions help to extract and standardize data. (1 point) True False

True

You can import tables and queries from Access by dragging the object from the Navigation Pane and dropping it into the desired starting cell. (1 point) true False

True

To change the text string James Smith to JAMES SMITH, use the ________ function. (1 point) UPPER PROPER LOWER CONCATENATE

UPPER

Markup Language -

Uses tags to tell the processor what to do with the document

Which of the following is NOT an advantage of a web query? (1 point) Connections can be shared with other users. Web queries update the URL automatically when the URL changes. Information is kept up-to-date because it connects with the website for the most current information. Web queries can be used by other Microsoft Office applications.

Web queries update the URL automatically when the URL changes.

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

XML

Which of the following is NOT a text file? (1 point) Tab delimited Comma separated Space delimited XML

XML

________ is a markup language that was created to give structure to web page data so that it could be searched more efficiently. (1 point) XML VBA Query HTML

XML

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

XML schema

< revenue > is an example of a(n) ________. (1 point) XML tag metadata delimiter HTML tag

XML tag

the ______________ function removes the first 32 nonprinting character codes. (1 point)

clean

Data ________ is a process that converts data into a useful format by fixing obvious errors. (1 point) cleansing validation testing verification

cleansing

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 (1 point) space delimited comma separated tab delimited font delimited

comma separated

The _________________ function is used to convert a date represented by text to a serial number. (1 point)

datevalue

Jerry used a function to convert the following date 1/31/2012. The function he used returned the number 31. Jerry likely used the Incorrect answer mjjj function.

day

A(n) ________ is a way of indicating the beginning and end of a text data segment. (1 point) schema element metadata delimiter

delimiter

an ________ indicates the beginning and end of a text data segment. (1 point)

delimiter

An XML document uses ________ that include start tags, end tags and the data itself. (1 point) elements schema markup map

elements

Anything that is NOT stored in an Excel format is ________. (1 point) unimportant internal data information external data

external data

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.

external data

Access database tables are the only element that can be imported into Excel. (1 point) True False

false

Text files can contain fonts, images, and hyperlinks. (1 point) True False

false

When a primary key from one table is connected to another table, it is said to be a ________ key. (1 point) super foreign secondary primary

foreign

accdb -

import data from relational tables created in Access

the ___________________ function returns the total number of characters in a string. (1 point)

len

HTML and XML are both examples of ________. (1 point) markup languages web query sources tags multimedia

markup languages

A social security number is commonly used as a ________ key. (1 point) foreign secondary primary super

primary

An Access database uses a ________ field to uniquely identify a record. (1 point) primary key super key foreign key data key

primary key

the _______________ function capitalizes the first letter of each word and leaves the remaining letters as lowercase.

proper

A(n) ________ is a question that you would ask a database to search for information. (1 point) inquiry data question query QWERTY

query

By definition, a(n) ________ database is a collection of tables linked together by shared fields. (1 point)

relational

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 (1 point) space delimited font delimited comma separated tab delimited

space delimited

If the ______________ function does not find the string supplied for the old_text argument, it will not return an error. (1 point)

subsitute

In a tab delimited file, ________ separate the data. (1 point) commas tabs hyphens spaces

tabs

A(n) Incorrect answer _________________ is a file structured by the use of delimiters. (1 point)

text file

Because Flash Fill involves less typing than traditional text functions, it can be easier to use on _________________ devices.

touch-enabled

Excel has the ability to consolidate diverse types True False

true

There is NOT a prespecified standard for XML tags. (1 point) True False

true

Data ________ is a process that validates data so that it is accurate. (1 point) verification testing validation cleansing

verification

An Excel ________________ creates a connection to the original web page so that you will have the most up-to-date data. (1 point)

web query

One popular way to integrate information from the Internet is to use a(n) ________. (1 point) update query different Microsoft product append query web query

web query