ITE 140 Chapter 10 Multiple question
________ are arrows that display in the column titles of Excel data and that enable
you to sort and filter the data when it is converted to a table. - CORRECT
ANSWER-Filtering controls
________ include three, four, or five small graphic images that make your data
visually easier to interpret. - CORRECT ANSWER-Icon sets
________ make(s) data easier to interpret by changing the data's appearance based
on a condition. - CORRECT ANSWER-Conditional formatting
________ refers to facts about people, events, things, or ideas. - CORRECT
ANSWER-Data
________ refers to the arrangement of arguments in a function. - CORRECT
ANSWER-Syntax
By having two tables side-by-side in the same worksheet, you can ________ similar
sets of data to make comparisons. - CORRECT ANSWER-sort
Functions are predefined formulas that perform calculations by using specific values,
called ________. - CORRECT ANSWER-arguments
In a database, a(n) ________ is a vertical column that stores information that
describes a record. - CORRECT ANSWER-field
In a database, data stored in a format of rows and columns is referred to as a(n)
________. - CORRECT ANSWER-table
In a database, records display in ________. - CORRECT ANSWER-rows
In Excel, you can create simple ________, which are collections of data related to a
particular topic or purpose. - CORRECT ANSWER-databases
The ________ commands enable you to bring data from an Access database, from
the web, from a text file, from an XML file, and from other sources into Excel. -
CORRECT ANSWER-Get & Transform Data
The ________ function capitalizes the first letter of each word in a string of
characters. - CORRECT ANSWER-PROPER
The ________ function changes the case of the characters in a string, making all
characters lowercase. - CORRECT ANSWER-LOWER
________ are arrows that display in the column titles of Excel data and that enable
you to sort and filter the data when it is converted to a table. - CORRECT
ANSWER-Filtering controls
________ include three, four, or five small graphic images that make your data
visually easier to interpret. - CORRECT ANSWER-Icon sets
________ make(s) data easier to interpret by changing the data's appearance based
on a condition. - CORRECT ANSWER-Conditional formatting
________ refers to facts about people, events, things, or ideas. - CORRECT
ANSWER-Data
________ refers to the arrangement of arguments in a function. - CORRECT
ANSWER-Syntax
By having two tables side-by-side in the same worksheet, you can ________ similar
sets of data to make comparisons. - CORRECT ANSWER-sort
Functions are predefined formulas that perform calculations by using specific values,
called ________. - CORRECT ANSWER-arguments
In a database, a(n) ________ is a vertical column that stores information that
describes a record. - CORRECT ANSWER-field
In a database, data stored in a format of rows and columns is referred to as a(n)
________. - CORRECT ANSWER-table
In a database, records display in ________. - CORRECT ANSWER-rows
In Excel, you can create simple ________, which are collections of data related to a
particular topic or purpose. - CORRECT ANSWER-databases
The ________ commands enable you to bring data from an Access database, from
the web, from a text file, from an XML file, and from other sources into Excel. -
CORRECT ANSWER-Get & Transform Data
The ________ function capitalizes the first letter of each word in a string of
characters. - CORRECT ANSWER-PROPER
The ________ function changes the case of the characters in a string, making all
characters lowercase. - CORRECT ANSWER-LOWER
