WorksheetsExcel as Database
Total questions: 15
Worksheet time: 8mins
___ 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
This icon represent
data form
Filter
Sort
excel
This icon represents
Auto sum
Sort and Filter
this icon represents
Subtotal
Average
Count
Total
This icon stands for
Filter
Data Validation
You cannot specify multiple conditions using Customer filter
True
False
