Unit 6 - Numbers and data: Business data table

A __________ is a type of software application that stores information in data tables.

• data storage system
• information repository software
• table management application
• spreadsheet

______ means raw facts and figures without a proper meaning.

• Data
• Knowledge
• Information
• Statistics

The task of turning data into information is sometimes called ___________

• Data processing
• Data transformation
• Data conversion
• Information processing

A ________ is a grid of rows and columns with each cell holding a single item of data.

• calendar
• database
• spreadsheet (data table)

• presentation

__________ are rows of the data table which stores all the information about one item.

• Records

• Programming language
• Spreadsheet cell
• Fields

______ stores one type of data using columns of a spreadsheet table.

• Field

• Record

• Both

How many fields are they?

• 10

• 3
• 5

• 4

What is the data type for the Cost field?

• Accounting Number Format

• General

• Text

• Number

What is the data type for the Weight Field? (Hint: Look at the data alignment to the cell)

• Accounting Number Format

• General

• Number

• Short Date

The data table has a key field which is used to identify the records. Another name for the key field is _______ key.