Mid term review Quiz

What is a data table used for in a spreadsheet app?

• To organize data in a structured format

• To draw pictures

• To play games

• To write stories

What are the rows of a table called?

• Fields

• Records

• Columns

• Cells

What is a primary key in a data table?

• A unique identifier for each record

• A tool to draw shapes

• A type of color

• A kind of game

What must you do first to turn a spreadsheet into a data table?

• Click 'Save'

• Select all the cells that contain data

• Close the spreadsheet

• Print the document

What does sorting mean in a data table?

• Mixing up the records randomly

• Putting the records in order

• Deleting the records

• Coloring the records

What are the two main types of sorting?

• Alphabetical and numerical

• Colorful and plain

• Fast and slow

• Big and small

What does filtering do in a data table?

• Deletes all records

• Selects records to see

• Changes the color of records

• Adds new records

What happens to records that don't match your filter criteria?

• They are deleted

• They are hidden

• They are highlighted

• They are duplicated

What is the purpose of filtering data in a table?

• To show only the records you want to see.

• To delete all the data in the table.

• To change the color of the table.

• To add more columns to the table.

What does validation mean in data checks?

• Deciding on rules called validation criteria.

• Deleting incorrect data automatically.

• Changing the format of the data.

• Adding more data to the table.