Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel as Database

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

___ is considered to be a single row

a)

record

b)

cell

2.

A ________ is used for easy manipulation of data in Excel

a)

tool bar

b)

data form

3.

Press ____ to move the next field in the row

a)

tab

b)

Shift + Tab

4.

Press _____ to move the previous field

a)

tab

b)

shift + tab

5.

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

a)

filter

b)

sort

6.

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

a)

Filter

b)

Data validation

7.

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

a)

input message

b)

data validation

8.

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

a)

Error Alert

b)

Filter

9.

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

a)

Data form

b)

Subtotal

10.

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

a)

Pivot table

b)

Custom filter

11.

This icon represent

a)

data form

b)

Filter

c)

Sort

d)

excel

12.

This icon represents

a)

Auto sum

b)

Sort and Filter

13.

this icon represents

a)

Subtotal

b)

Average

c)

Count

d)

Total

14.

This icon stands for

a)

Filter

b)

Data Validation

15.

You cannot specify multiple conditions using Customer filter

a)

True

b)

False