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