Flashcards in BAT Chapter 4 Deck (17):
Inserts summary rows for a sorted list and formats the data as an outline
A column name along with its table name
Criteria range separate from actual data
Business Intelligence (BI)
Applications and processes for assessing types of results or changes to data
What are 3 ways of exporting data into Excel?
Used for highlighting information in a worksheet
Command that recognizes patterns and duplicates
Row of data in a table
Importing a document into Excel that uses special characters
Summary report in a separate worksheet based on list-type data
Website data can be imported into Excel if the data is -----.
A tab character separates the fields
Clears an auto outline
Data from another program or format
What are 2 examples of conditional formatting being used?
Setting different fill colors for selected cells
-Setting different font styles for cells
Network products that allow collaboration and simultaneous work by a group