Simnet Excel Chapter 4
External data - CORRECT ANSWER-Data from another program or format
Business Intelligence (BI) - CORRECT ANSWER-Applications and processes for
assessing types of results or changes to data
Tab delimited - CORRECT ANSWER-A tab character separates the fields
Record - CORRECT ANSWER-Row of data in a table
PivotTable - CORRECT ANSWER-Summary report in a separate worksheet
based on list-type data
Microsoft SharePoint - CORRECT ANSWER-Network products that allow
collaboration and simultaneous work by a group
Ungroup buttion - CORRECT ANSWER-Clears an Auto Outline
Structured reference - CORRECT ANSWER-A column name along with its table
name
Advanced filter - CORRECT ANSWER-Criteria range separate from the actual
data
Subtotal command - CORRECT ANSWER-Inserts summary rows for a sorted list
and formats the data as an outline
External data - CORRECT ANSWER-Data from another program or format
Business Intelligence (BI) - CORRECT ANSWER-Applications and processes for
assessing types of results or changes to data
Tab delimited - CORRECT ANSWER-A tab character separates the fields
Record - CORRECT ANSWER-Row of data in a table
PivotTable - CORRECT ANSWER-Summary report in a separate worksheet
based on list-type data
Microsoft SharePoint - CORRECT ANSWER-Network products that allow
collaboration and simultaneous work by a group
Ungroup buttion - CORRECT ANSWER-Clears an Auto Outline
Structured reference - CORRECT ANSWER-A column name along with its table
name
Advanced filter - CORRECT ANSWER-Criteria range separate from the actual
data
Subtotal command - CORRECT ANSWER-Inserts summary rows for a sorted list
and formats the data as an outline
