wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

ИКТ тест

Total questions: 51

Worksheet time: 26mins

Name
Class
Date
1.

What is a font?

a)

different text style

b)

name of  paragraph

c)

type of text color

d)

text alignment

e)

functional protocol

2.

What is a 'Worksheet'?

a)

A page in a spreadsheet

b)

A sheet to show calculations

c)

A blank document

d)

A photocopy from a text book

e)

A document from a text book

3.

Money in cells should be formatted as what?

a)

Currency

b)

Euro

c)

?

d)

$

e)

a text

4.

What is a cell reference?

a)

The column letter and row number to identify a cell

b)

The shape of a cell

c)

A cell number and row letter used to identify column

d)

The color of a cell

e)

A cell from a text book

5.

What formula should you use when adding up a lot of numbers?

a)

SUM

b)

COUNT

c)

TOTAL

d)

ALL

e)

ADD

6.

How many cells are in the range B2:D7?

a)

18

b)

12

c)

6

d)

Unknown

e)

22

7.

Which of the following is a completely absolute cell reference?

a)

$J$4

b)

J4

c)

$?4

d)

$4

e)

A20

8.

What key is Help?

a)

F1

b)

F2

c)

F5

d)

F3

e)

F+A

9.

>###### means:

a)

The cell is not wide enough.

b)

You've misspelled something.

c)

You've entered a number wrong.

d)

None of the above

e)

A cell from a text book

10.

#NAME means:

a)

when Excel does not recognize text in a formula

b)

when a formula has the wrong type of argument

c)

when a formula tries to divide a number by 0 or an empty cell

d)

when a formula refers to a cell that is not valid

e)

when  a formula from other books

11.

Sorting can be 

a)

on increase or on decrease order

b)

selection of data on certain criteriaselection of data on certain criteria

c)

a calculation that describes the relationship between cells

d)

positional and none positional

e)

statistical, mathematical and logical

12.

Filtration of data -

a)

selection of data on certain criteria

b)

a way of arranging data in a particular order

c)

a calculation that describes the relationship between cells

d)

set of data held in a computer

e)

none of the above

13.

Change addressing in formula possible by key...

a)

F4

b)

F1

c)

F2

d)

F3

e)

F5

14.

What symbol represents absolute reference in MS Excel?

a)

$

b)

#

c)

&

d)

%

e)

+

15.

What is a Chart?

a)

It is a visual way to display and compare data

b)

A way of arranging data in a particular order

c)

A calculation that describes the relationship between cells

d)

None of the above

e)

A photocopy book

16.

Show functions in Excel:

a)

Statistical

b)

System

c)

Trigonometrically

d)

Symbol

e)

A photocopy from a text book

17.

An example of a range address:

a)

A1:B3

b)

C1;B3

c)

A1-B3

d)

A1=B3

e)

B5+A5

18.

Data that are entered into a cell in spreadsheet

a)

number, formula, text

b)

text, graphics, pattern

c)

ext, chart, formula

d)

formula, pattern, number

e)

photocopy,  text book

19.

The purpose of a database is:

a)

All are correct

b)

Store data

c)

Update data

d)

Query data

e)

Processing data

20.

Data in a database is stored in which of the following:

a)

Table

b)

Sheet

c)

File

d)

Form

e)

Form

21.

Rows in a database table are called?

a)

Records

b)

Fields

c)

Keys

d)

Data

e)

Query

22.

The terms 'primary key' and 'unique identifier' are synonymous:

a)

True

b)

False

c)

Not given

d)

Given

e)

Given

23.

Once you have finished populating a table, you cannot add records to it:

a)

False

b)

False

c)

Not given

d)

Given

e)

Query data

24.

To find the answer to a question in a database you would use:

a)

A Query

b)

A Form

c)

A Report

d)

A Report

e)

A data

25.

What is the address, which will be automatically changed?

a)

Relative

b)

Mixed

c)

Absolute

d)

Link

e)

Query

26.

How many sheets can we add to one book?

a)

255

b)

3

c)

256

d)

any number

e)

5 data

27.

What is the sign of absolute addresses?

a)

sign $

b)

sign equal

c)

sign &

d)

sign &

e)

sign &

28.

What is a field?

a)

Column Heading

b)

Store animals

c)

Store animals

d)

Store animals

e)

Store animals

29.

What is a report used for?

a)

Results

b)

Bill

c)

Detention

d)

Query

e)

Query

30.

What is a query?

a)

Question

b)

Table

c)

Report

d)

Form

e)

Data

31.

What program would use for a database?

a)

Access

b)

PowerPoint

c)

Publisher

d)

Word

e)

Prezi

32.

What data type would you use for 5/10/15?

a)

Date/Time

b)

Auto number

c)

Number

d)

Currency

e)

Query data

33.

What is the definition of a data base?

a)

A structured set of data held in a computer.

b)

A list of words.

c)

Computers connected locally.

d)

A group of interconnected things.

e)

Computers connected Query.

34.

One piece of data or information about a person or thing is known as...

a)

A field

b)

A name

c)

A primary key

d)

A record

e)

A connect

35.

All of the data or information about one person or thing is stored in...

a)

A record

b)

A field

c)

A primary key

d)

A data type

e)

A  type

36.

A database created in Access with the extension:

a)

*.mdb

b)

>*.dll

c)

>*.dat

d)

>*.ppt

e)

>*. dpe

37.

What’s a table in Access

a)

for storage

b)

to display the data in a form

c)

to search data

d)

for report

e)

for texting

38.

The basis of the database (DB) is…

a)

table, column is called as a field, and the lines as a record

b)

column, which is a record, and the record field

c)

objects designed to retrieve information from the database

d)

forms, queries, tables, reports,

e)

column which is the record field

39.

Types of data models, databases are….

a)

hierarchical, network, relational

b)

stacks, queues

c)

corporate, local, computer

d)

local, distributed, linear

e)

record, record field

40.

The report is

a)

Object used to print the document

b)

Document used to save the document

c)

The document of object which you want to remove

d)

Slide used for presentations

e)

The document for presentations

41.

To move the table from field to field use

a)

Tab key

b)

Enter key

c)

Shift + Tab

d)

Esc key

e)

Shift key

42.

A set of techniques and methods of use of the objects of some applications in the documents of other applications

a)

OLE technology

b)

Internet technology

c)

Programming

d)

Network Technologies

e)

Key technology

43.

OLE Object field

a)

a special type of storage for archiving pictures, photos

b)

the type for storing calendar dates and the current time

c)

all type for storing large amounts of text

d)

a type for storing unique natural numbers with automatic capacity

e)

a type for storing technology

44.

Database management system is

a)

MS Access

b)

MS Outlook

c)

MS Power point

d)

MS Excel

e)

MS Word

45.

How to search the data in Access

a)

Ctrl+F

b)

Alt+O

c)

Alt+F

d)

Shift+N

e)

F#

46.

Access to database objects does not apply

a)

scheme

b)

form

c)

request

d)

report

e)

 storing

47.

Show impossible options for numeric date format

a)

30/32/1996

b)

January 29, 1994

c)

4 - Apr-1995

d)

14/03/1999

e)

1,02,1998

48.

Database Access does not work with

a)

presentations

b)

queries

c)

reports

d)

forms

e)

tables

49.

To display the results of the calculations necessary

<variant>create a query with calculated fields

a)

enter a formula in a free table

b)

create a macro

c)

start the calculator

d)

find type for storing

e)

create a query with calculated fields

50.

What objects are stored in the database

a)

tables

b)

queries

c)

forms

d)

reports

e)

modules

51.

What types of fields used in tables

a)

all of them

b)

text, numeric

c)

date/time

d)

field Memo

e)

OLE object

Similar Resources on Wayground

Tin11-gk2

47 questions

Tin11-gk2

quiz

Worksheet

•

11th Grade

G3 - Review - Final 2 - 21.22

52 questions

G3 - Review - Final 2 - 21.22

quiz

Worksheet

•

3rd - 5th Grade

CL-5 INTERNET-ISWK

50 questions

CL-5 INTERNET-ISWK

quiz

Worksheet

•

5th Grade

Year 8: End of Year Assessment

47 questions

Year 8: End of Year Assessment

quiz

Worksheet

•

8th Grade

สอบครั้งที่ 1 วิชาธุรกิจและการเป็นผู้ประกอบการ

51 questions

สอบครั้งที่ 1 วิชาธุรกิจและการเป็นผู้ประกอบการ

quiz

Worksheet

•

12th Grade

2023 W5 Emails

48 questions

2023 W5 Emails

quiz

Worksheet

•

6th - 8th Grade

ICT Questions

47 questions

ICT Questions

quiz

Worksheet

•

7th Grade