wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Data Validation, Sorting and Searching a database

Total questions: 40

Worksheet time: 27mins

Name
Class
Date
1.
What validation type would you use to check that numbers fell within a certain range?
a)
Range check
b)
Presence check
c)
Check digit
d)

Drop Down List

2.
What is an automatic computer check to make sure data entered is sensible and reasonable known as?
a)
Double entry
b)
Verification
c)
Validation
3.
Which Tab in MS-Excel is used to access data validation for a cell or cell range?
a)
Charts
b)
Data
c)
Formulas
d)
Tables
4.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
5.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
6.

What is it called when we put a database into some kind of order?

a)

Search

b)

Arrange

c)

Order

d)

Sort

7.

If I sort this database in ascending order on the 'Title' field, which record would come first?

a)

Sonic and Mario at the Winter Olympics

b)

FIFA 09

c)

Nintendogs

8.

If I sort in Descending Alphbetical order how am I sorting?

a)

10 - 0

b)

A - Z

c)

Z - A

d)

0 - 10

9.

If I sort this database in descending order on the 'Rating' field, which record would come first?

a)

Sonic and Mario at the Winter Olympics

b)

FIFA 09

c)

Nintendogs

10.
Which 2 filters have been applied in this table?
a)
Eyes (Blue) & Real Name (Sort Ascending)
b)
Weight (Sort Descending) & Gender (Male)
c)
Superhero (Sort Descending) & Lives (Gotham City)
d)
Gender (Male) & Superhero (Sort Ascending)
11.
What is the main purpose of sorting/filtering data?
a)
Makes it nicer to look at
b)
Makes it easier to input new data
c)
Helps to find specific information quickly
d)
Gives me something to do when I'm bored
12.

The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .

a)

Filter

b)

Sort

13.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

14.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

15.
Data Validation is used in ...
a)
MS-Excel
b)
MS-Word
c)
MS-Powerpoint
d)
Inkscape
16.

Given the following validation criteria, indicate if the input "PEAR" would be accepted or not.

a)

Accepted

b)

Not accepted

17.

Given the following validation criteria, indicate if the input "APPLE" would be accepted or not.

a)

Accepted

b)

Not accepted

18.

Given the following validation criteria, indicate if the input "BANANA" would be accepted or not.

a)

Accepted

b)

Not accepted

19.

Given the following validation criteria, indicate if the input "0" would be accepted or not.

a)

Accepted

b)

Not accepted

20.

Given the following validation criteria, indicate if the input "-2.1" would be accepted or not.

a)

Accepted

b)

Not accepted

21.

This icon represents

a)

Auto sum

b)

Sort and Filter

22.

This icon stands for

a)

Filter

b)

Data Validation

23.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
24.
To restrict the data that can be entered into a cell e.g. Gender = "M" or "F", is called?
a)
Validation
b)
Verification
c)
Filter
d)
Sort
25.
What are we doing in the example below?
a)
Filtering the Type column by number
b)
Filtering the Type column to show only Laptops and Projectors
c)
Filtering the Type column to show everything except Laptops and Projectors
d)
Filtering the Type column by date
26.

What is the advantage of using data validation?

a)

It takes longer to complete the spreadsheet.

b)

It improves the accuracy of our data.

c)

It means that more mistakes can be made.

d)

The correct answer may have been entered.

27.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
28.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
29.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
30.

Merging cells

a)

moves them over one cell

b)

combines multiple cells into one

c)

adds a cell in the middle of a row

d)

adds the cell contents

31.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
32.
Text, Number, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
33.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
34.
All the information about one object or one thing is called a:
a)
Record
b)
Field
c)
File
d)
Table
35.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
36.
A column goes
a)
vertical
b)
horizontal
c)
diagonal
37.
Which way does a row go? 
a)
horizontal
b)
vertical
c)
diagonal
38.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
39.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
40.

Which option is used to arrange data in order.

a)

insert

b)

order

c)

sort and filter

Similar Resources on Wayground

Excel Quiz

40 questions

Excel Quiz

quiz

Worksheet

•

5th - 12th Grade

SOAL BAB TIK KELAS 7

35 questions

SOAL BAB TIK KELAS 7

quiz

Worksheet

•

7th Grade

Sensor - ICT IGCSE

35 questions

Sensor - ICT IGCSE

quiz

Worksheet

•

7th Grade

TECH ~ Final Test

39 questions

TECH ~ Final Test

quiz

Worksheet

•

7th Grade

Computer Fundamentals - Study Quiz

44 questions

Computer Fundamentals - Study Quiz

quiz

Worksheet

•

8th - 12th Grade

Code.org Review 5th Grade

41 questions

Code.org Review 5th Grade

quiz

Worksheet

•

4th - 7th Grade

Computer Parts and stuff

40 questions

Computer Parts and stuff

quiz

Worksheet

•

6th - 10th Grade

HAWI Quiz

40 questions

HAWI Quiz

quiz

Worksheet

•

7th Grade