wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Test (excel, database)

Total questions: 60

Worksheet time: 29mins

Name
Class
Date
1.

Which are the three essential elements to enter a function?

a)

Equal sign, function name and cell reference.

b)

Function name, data and cell reference.

c)

Equal sign, cell reference and formula.

2.

Every formula in Excel starts with a ______

a)

=

b)

!

c)

?

d)

$

3.

Choose the answer that shows a RELATIVE cell reference

a)

=C4

b)

=$C$4

c)

=4^3

d)

=($C$1*.5)+$D$1

4.

Choose the answer that shows a formula with an ABSOLUTE cell reference

a)

=B1*$C$4

b)

=A3

c)

=B1*C4

d)

=4^3

5.

A RELATIVE reference in Excel means that the cell reference does not change when the formula is copied

a)

True

b)

False

6.

An ABSOLUTE cell reference in Excel means that the cell reference does change when the formula is copied.

a)

True

b)

False

7.

Choose the answer that references a cell

a)

C4 or $C$4

b)

4*12

c)

Mitochondria

d)

Red Blood

8.

Which answer references a cell range

a)

=SUMIF(A1:A13,"Brass",C1:C13)

b)

B4

c)

B1+C1

d)

Archery

9.

Excel can find the average of a range of numbers by using the _________ function.

a)

AVERAGE

b)

MAX

c)

MIN

d)

SUM

10.

The _______ function counts the numbers in a range of cells.

a)

COUNT

b)

AVERAGE

c)

SUM

d)

COUNTIF

11.

Calculates the mean of a group of values

a)

SUM

b)

AVERAGE

c)

ROUND

d)

COUNT

12.

True or False:


The IF function tests for a true or false condition and then returns one value or another.

a)

True

b)

False

13.

Calculates a sum from a group of values, but just of values

that are included because a condition is met.

a)

COUNTIF

b)

SUMIF

c)

AVERAGEIF

14.

Counts the number of cells in a range that match a

criteria

a)

COUNTIF

b)

SUMIF

c)

AVERAGEIF

15.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
16.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
17.

An example of a browser is:

a)

docs

b)

form

c)

sheets

d)

chrome

18.

Html stands for.

a)

Hyper text mark up language

b)

High text message language

c)

Hyper text machine language

d)

High text media Learning

19.

The address bar contains the URL.

a)

True

b)

False

20.

_______________ allows you to go back

a)

back

b)

forward

c)

refresh

d)

address bar

21.

moves the window to the bottom of the screen

a)

minimize

b)

maximize

c)

restore down

d)

close

22.

one box on the top right corner of the screen means

a)

minimize

b)

maximize

c)

restore down

d)

close

23.

__________ closes the Google Chrome browser

a)

minimize

b)

maximize

c)

restore down

d)

close

24.
_______________ are used to present information to viewers, sometimes even videos are present on some websites. 
a)
Videos and Texts
b)
Images and texts
c)
videos and texts
d)
texts only
25.
Information found in _________ are usually categorized in webpages so as not to over clutter in one particular page.
a)
websites
b)
webpages
c)
search engine
d)
address bar
26.
____________ help users search for information through the keywords typed on the search bar of a web browser.
a)
Search engine
b)
Address bar
c)
Google
d)
Bing
27.
a)
Search engine
b)
Web browser
c)
Webpage
d)
Address bar
28.
_____________ such as Google Chrome, Mozilla Firefox, Safari, and Internet Explorer presents the results of the search.
a)
Web browser
b)
Website
c)
Webpage
d)
Search engine
29.
Google, Yahoo!, and Bing are just some examples websites that uses ___________. 
a)
search engine
b)
address bar 
c)
website
d)
webpage
30.
___________ refers to the different pages found on a website
a)
webpages
b)
address bar
c)
search engine
d)
website
31.

1, What does HTML stand for ?

a)

Hypeyourtext Makeup Language

b)

Hype Text Marker Language

c)

Hypertext Mark up Lines

d)

Hypertext Mark up Language

32.

What do you call a software application used to access and view web pages?

a)

search engine

b)

web browser

c)

internet

d)

none of the above

33.

It is a global network of billions of computers and other electronic devices.

a)

search engine

b)

internet

c)

web browser

d)

all of the above

34.

It is usually called the web for short—is a collection of different websites you can access through the Internet.

a)

internet

b)

web browser

c)

search engine

d)

world wide web

35.

Is considered as top 1 web browser?

a)

Internet Explorer

b)

Google Chrome

c)

Mozilla Firefox

d)

Safari

36.
A relational database consists of a collection of
a)
Field
b)
Record
c)
Table
d)
Keys
37.
A_______ in a table represents a relationship among a set of values
a)
Field
b)
Foreign key
c)
Record
d)
Primary key
38.
The term attribute refers to a ________ of a table
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
39.
The term _______ is used to refer a row
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
40.
Which one of the following should be taken as a primary key?
a)
Name
b)
DepartmentID
c)
Department
d)
Street
41.
which one of the following cannot be taken as a primary key?
a)
ID
b)
RegistrationNo
c)
DepartmentID
d)
Street
42.
A attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
a)
Record
b)
Foreign key
c)
Primary key
d)
Field
43.

Why would you create a primary key?

a)

To make each record in a database unique

b)

To make each field in a database unique

c)

To make each query in a database unique

44.

What is a database?

a)

A software package used to store information

b)

Something that has a list

c)

A spreadsheet

d)

A table of data

45.

Which software program do we use to create a database

a)

Microsoft Excel

b)

Microsoft Word

c)

Microsoft Access

d)

Microsoft Publisher

46.

In school, what kind of data might be stored in a database?

a)

Favourite colour

b)

Emergency contact details

c)

Favourite food

d)

Your mobile phone number

47.

Which of these holds lots of data?

a)

Record

b)

Field

c)

Table

d)

Drawing

48.

In a TABLE, a column is known as a...

a)

Record

b)

Field

c)

Row

d)

Data

49.

In a TABLE, a row is known as a...

a)

Information

b)

Column

c)

Data

d)

Record

50.

The best data type to choose for a memberID would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

51.

The best data type to choose for date of birth would be

a)

Number

b)

Date/Time

c)

Text

d)

Currency

52.

In a database, data is stored in

a)

Queries

b)

Forms

c)

Reports

d)

Tables

53.

In a database, all the information about one person or thing is called a

a)

Worksheet

b)

Presentation

c)

Record

d)

File

54.

What is a query?

a)

Table

b)

Question

c)

Spreadsheet

d)

Report

55.
Which of the following is a common database program?
a)
Access
b)
Excel
c)
InDesign
d)
Badata
56.
A column name is otherwise known as a _____.
a)
field
b)
table
c)
row
d)
record
57.
Data _____ helps ensure that an incorrect entry isn't made.
a)
validation
b)
checks
c)
accuracy
d)
integrity
58.
A quick way to find data in a database is to use _____.
a)
queries
b)
quandries
c)
questions
d)
file folders
59.
What must be common between two tables to create a relationship?
a)
Fields
b)
Characters
c)
Files
d)
Names
60.
In a database, Yes/No, Text and Date/Time are all examples of:
a)
data types
b)
data queries
c)
tabs you can select
d)
records in the data table

Similar Resources on Wayground

Computer Grade 4

55 questions

Computer Grade 4

quiz

Worksheet

•

4th - 5th Grade

ÔN TẬP TIN HỌC 3

61 questions

ÔN TẬP TIN HỌC 3

quiz

Worksheet

•

3rd Grade - University

Ordinateur réseau internet

56 questions

Ordinateur réseau internet

quiz

Worksheet

•

1st - 5th Grade

Informática-IV

60 questions

Informática-IV

quiz

Worksheet

•

4th Grade

Grade4_5_To_13

63 questions

Grade4_5_To_13

quiz

Worksheet

•

4th Grade

MMS Tema 6 - Tarjetas de Expansión

62 questions

MMS Tema 6 - Tarjetas de Expansión

quiz

Worksheet

•

4th - 7th Grade

Review3 BMTinHoc

60 questions

Review3 BMTinHoc

quiz

Worksheet

•

KG - 6th Grade

Bab4-Jaringan Komputer dan Internet -Gr5

60 questions

Bab4-Jaringan Komputer dan Internet -Gr5

quiz

Worksheet

•

4th Grade - University