BAT Chapter 4 Flashcards Preview

jeremy harmon > BAT Chapter 4 > Flashcards

Flashcards in BAT Chapter 4 Deck (17):
1

Subtotal Command

Inserts summary rows for a sorted list and formats the data as an outline

2

Structured Reference

A column name along with its table name

3

Advanced Filter

Criteria range separate from actual data

4

Business Intelligence (BI)

Applications and processes for assessing types of results or changes to data

5

What are 3 ways of exporting data into Excel?

Business Intelligence
SharePoint Server
Via Clipboard

6

Conditional Formatting

Used for highlighting information in a worksheet

7

Flash Fill

Command that recognizes patterns and duplicates

8

Record

Row of data in a table

9

Delimited File

Importing a document into Excel that uses special characters

10

Pivot Table

Summary report in a separate worksheet based on list-type data

11

Website data can be imported into Excel if the data is -----.

List-type

12

Tab Delimited

A tab character separates the fields

13

Ungroup Button

Clears an auto outline

14

External Data

Data from another program or format

15

What are 2 examples of conditional formatting being used?

Setting different fill colors for selected cells
-Setting different font styles for cells

16

Microsoft SharePoint

Network products that allow collaboration and simultaneous work by a group

17

What are 3 files that can be imported into Excel?

Workbooks
CVS files
Text Files

Decks in jeremy harmon Class (106):