Chapter 7 - Organizing Big Data Flashcards Preview

Quantitive Analysis with Excel > Chapter 7 - Organizing Big Data > Flashcards

Flashcards in Chapter 7 - Organizing Big Data Deck (13)
Loading flashcards...
1

List the 2 formats that can be imported into Excel

1. Text data
2. Database tables

2

List 4 examples of databases that can be imported into Excel

1. Oracle
2. Cybase
3. MySQL
4. Access

3

What is an example of the text data format that can be imported into Excel?

Cobol

4

List the 3 types of text file formats

1. Free format
2. Delimited
3. Fixed width

5

In which text file format does the reader have to determine the text that will be included in the field?

The free format

6

Which text file format separates the fields by a certain character?

The delimited format

7

In which text file format is the field width determined?

The fixed width format

8

What is a collection of records called?

A file

9

What is one complete set of fields called?

A record

10

What is a single piece of information called?

A field

11

When importing data from a database what is imported into the table?

The file

12

When importing data from a database what information is imported into the rows?

The records

13

When importing data from a database what information is imported into the columns?

The fields