Excel as Database

___ is considered to be a single row

• record

• cell

A ________ is used for easy manipulation of data in Excel

• tool bar

• data form

Press ____ to move the next field in the row

• tab

• Shift + Tab

Press _____ to move the previous field

• tab

• shift + tab

The _____ command is used to change or customize the order of the spreadsheet data

• filter

• sort

The ____ command is used to view only the required data while the rest of the data is temporarily hidden,

• Filter

• Data validation

_____ is used to specify the type of data that can be entered in a celll

• input message

• data validation

This alerts users by displaying an error message if invalid data is typed in a cell

• Error Alert

• Filter

The _____ command is used to outline the worksheet in numerous ways

• Data form

• Subtotal

____ tool is used to summarize extensive data to make it easily manageable.

• Pivot table

• Custom filter