BAT Chapter 4

Question 1

Subtotal Command

Answer 1

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

Question 2

Structured Reference

Answer 2

A column name along with its table name

Question 3

Advanced Filter

Answer 3

Criteria range separate from actual data

Question 4

Business Intelligence (BI)

Answer 4

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

Question 5

What are 3 ways of exporting data into Excel?

Answer 5

Business Intelligence
SharePoint Server
Via Clipboard

Question 6

Conditional Formatting

Answer 6

Used for highlighting information in a worksheet

Question 7

Flash Fill

Answer 7

Command that recognizes patterns and duplicates

Question 8

Record

Answer 8

Row of data in a table

Question 9

Delimited File

Answer 9

Importing a document into Excel that uses special characters

Question 10

Pivot Table

Answer 10

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

Question 11

Website data can be imported into Excel if the data is —–.

Answer 11

List-type

Question 12

Tab Delimited

Answer 12

A tab character separates the fields

Question 13

Ungroup Button

Answer 13

Clears an auto outline

Question 14

External Data

Answer 14

Data from another program or format

Question 15

What are 2 examples of conditional formatting being used?

Answer 15

Setting different fill colors for selected cells

-Setting different font styles for cells

Question 16

Microsoft SharePoint

Answer 16

Network products that allow collaboration and simultaneous work by a group

Question 17

What are 3 files that can be imported into Excel?

Answer 17

Workbooks
CVS files
Text Files