wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel as Database

Total questions: 12

Worksheet time: 6mins

Name
Class
Date
1.

This is an organised collection of information.

a)

Database

b)

Chart

c)

Sorting

2.

It is a small screen that contains the fields of a database along with the space to add, modify or view a record.

a)

Worksheet

b)

Form

c)

Frame

3.

The structure of database is made up of _________ and _________.

a)

Frame, Form

b)

Form, Fields

c)

Fields, Records

d)

Records. Form

4.

This is used to rearrange data in a specific order.

a)

Sorting

b)

Filtering

c)

Data Validation

5.

This button in the sheet1 dialog box lets you search a record by entering data in a uniquely identified field.

a)

Find Prev

b)

New

c)

Criteria

6.

It contains data and information about one person, item or an organization in a database.

a)

Record

b)

Field

c)

Field Name

7.

Click on the _____________ button present on the Data tab to remove the filter.

a)

Delete

b)

Clear

c)

Clean

d)

Remove

8.

___________ feature temporarily hides unwanted data from being viewed.

a)

Data Validation

b)

Criteria

c)

Filtering

d)

Sorting

9.

_________ used for specifying complex criteria.

a)

AutoFilter

b)

Filter

c)

Advanced Filter

d)

Complex Filter

10.

To remove the previous sorting condition, click on the ___________ button.

a)

Add level button

b)

Delete level button

c)

Clear button

d)

Remove button

11.

___________ allows you to set certain rules to restrict the type of data or values to be entered in a cell.

a)

Criteria

b)

Data Validation

c)

Chart

d)

None

12.

__________ is when you want to sort your data on the basis of more than one column.

a)

Multi-level column sorting

b)

Multiple column sorting