BITM 215 EXAM CHAPTER 11 QUESTIONS AND ANSWERS LATEST
UPDATE A+ GRADED
Comma Separated Values (CSV) File
A text file that uses commas to separate text into columns and a newline character to
separate data into rows.
CONCATENATE Function
A text function that joins two or more text strings into one text string.
Data Range Property
A setting that controls the format, refresh rate, and other characteristics of a connection
to external data.
Delimiter
A character, such as a comma or tab, used to separate data in a text file.
Element
An XML component, including the start tag, an end tag, and the associated data.
Embed
The process of importing external data into an application but not maintaining any
connection to the original data source.
End Tag
A XML code that indicates the end of an element and contains the element's name
preceded by a slash character, such as </Rent>.
Extensible
Characteristics that indicate that XML can be expanded to include additional data.
eXtensible Markup Language (XML)
A data-structuring standard that enables data to be shared across applications,
operating systems, and hardware .
Fixed-width text file
A text file that stores data in columns that have a specific number of characters
designated for each column.
Flash Fill
A feature that fills in data or values automatically based on one or two examples you
enter using another part of data entered in a previous
Importing
The process of inserting data from one application or file into another.
LOWER function
A text function that converts all uppercase letters to lowercase.
Newline Character
A character that designates the end of a line and starts data on a new line or row in a
text file.
PROPER function
A text function that capitalizes the first letter in a text string and any other letters in text
that follow any character other than letter.
Refresh
The process of updating data in Excel to match current data in the external data source.
Start Tag
UPDATE A+ GRADED
Comma Separated Values (CSV) File
A text file that uses commas to separate text into columns and a newline character to
separate data into rows.
CONCATENATE Function
A text function that joins two or more text strings into one text string.
Data Range Property
A setting that controls the format, refresh rate, and other characteristics of a connection
to external data.
Delimiter
A character, such as a comma or tab, used to separate data in a text file.
Element
An XML component, including the start tag, an end tag, and the associated data.
Embed
The process of importing external data into an application but not maintaining any
connection to the original data source.
End Tag
A XML code that indicates the end of an element and contains the element's name
preceded by a slash character, such as </Rent>.
Extensible
Characteristics that indicate that XML can be expanded to include additional data.
eXtensible Markup Language (XML)
A data-structuring standard that enables data to be shared across applications,
operating systems, and hardware .
Fixed-width text file
A text file that stores data in columns that have a specific number of characters
designated for each column.
Flash Fill
A feature that fills in data or values automatically based on one or two examples you
enter using another part of data entered in a previous
Importing
The process of inserting data from one application or file into another.
LOWER function
A text function that converts all uppercase letters to lowercase.
Newline Character
A character that designates the end of a line and starts data on a new line or row in a
text file.
PROPER function
A text function that capitalizes the first letter in a text string and any other letters in text
that follow any character other than letter.
Refresh
The process of updating data in Excel to match current data in the external data source.
Start Tag
