wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ICT. рк-2 (нақты емес)

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

A program designed to work with databases:

a)

Access.

b)

Excel.

c)

Word.

d)

Power Point.

2.

The MS Excel program is:

a)

Spreadsheet.

b)

Text editor.

c)

DBMS.

d)

Graphic editor.

3.

The Access program is:

a)

DBMS.

b)

Spreadsheet.

c)

Text editor.

d)

Graphic editor

4.

You can enter in the cell:

a)

number

b)

slide

c)

document

d)

drawing

5.

The objects of the spreadsheet are:

a)

Columns

b)

Formula

c)

Document

d)

Number

6.

The objects of the spreadsheet are:

a)

Rows

b)

Formula

c)

Document

d)

number

7.

Main objects of database:

a)

Tables

b)

Graphs

c)

Slides

d)

Drawings

8.

Main objects of database:

a)

Requests

b)

Graphs

c)

Slides

d)

Drawings

9.

Main objects of database:

a)

Macros

b)

Graphs

c)

Slides

d)

Drawings

10.

Type of addressing in MS Excel:

a)

the relative

b)

index

c)

Graphs

d)

tree-like

11.

The type of address $A$5:

a)

absolute

b)

the relative

c)

index

d)

mixed

12.

The type of address $A5:

a)

mixed

b)

the relative

c)

index

d)

tree-like

13.

The type of address A$5:

a)

mixed

b)

the relative

c)

index

d)

tree-like

14.

The type of address A5:

a)

the relative

b)

>index

c)

mixed

d)

combined

15.

The element of application window, which used to maximize, minimize or close the window:

a)

Buttons to manipulate the window

b)

Ribbon

c)

Quick Access Toolbar

d)

Title bar

16.

Graphical representation of numerical data is:

a)

diagram

b)

table

c)

row

d)

column

17.

The < > sign means:

a)

is not equal to

b)

greater than

c)

equally

d)

less

18.

When you copy the formula, the address is changed:

a)

the relative

b)

index

c)

mixed

d)

combined

19.

When you copy the formula, the address is partially changed:

a)

mixed

b)

the relative

c)

index

d)

tree-like

20.

When you copy the formula, the address does not change:

a)

absolute

b)

the relative

c)

index

d)

mixed

21.

File of MS Excel is named:

a)

book

b)

worksheet

c)

table

d)

page

22.

MS Excel. Choose a correct designation of range (диапазон ячеек) in Excel:

a)

B2:C4.

b)

B2 ... C4.

c)

C4-B2.

d)

B2.C4.

23.

The columns of the worksheet in the Excel program are denoted by:

a)

A2

b)

12A

c)

FAS

d)

21

24.

Number of cells in the range A2:B4:

a)

6

b)

8

c)

10

d)

4

25.

The range is the set of cells:

a)

A1:B3

b)

A1;A5

c)

B3;B10

d)

A1;B3

26.

The text is aligned to EXCEL by default:

a)

on the left

b)

centered

c)

on the right

d)

in width

27.

The numbers are aligned in the EXCEL by default:

a)

>on the right

b)

centered

c)

on the left

d)

in width

28.

MS Access has relationships:

a)

one to one

b)

three to many

c)

two to one

d)

all answers are correct

29.

MS Access. The number of relationship between tables in the Access MS:

a)

3

b)

2

c)

1

d)

6

30.

Types of databases are:

a)

Hierarchical

b)

Index

c)

Matrix

d)

object

31.

The database, where the data is the objects, is called:

a)

Object-oriented

b)

Hierarchical

c)

Relational

d)

Index

32.

Hybrid database is a combination of:

a)

the relational and object-oriented databases

b)

the relational and hierarchical databases

c)

hierarchical and object-oriented databases

d)

index and object-oriented databases

33.

Table of database consists of:

a)

fields and records

b)

tabs

c)

records and buttons

d)

buttons

34.

The name of database field is:

a)

The column header of the table

b)

The record header of the table

c)

Type date

d)

Number of record

35.

A database object used for printing data is:

a)

Report

b)

Modules

c)

Form

d)

Request

36.

An object that allows you to obtain the necessary data by any criterion:

a)

Request

b)

Macros

c)

Report

d)

Modules

37.

A blank designed for entering data with the name of database field is:

a)

Form

b)

Modules

c)

Macros

d)

Report

38.

At the base there are two modes of data:

a)

table mode, design mode

b)

output mode, design mode

c)

table mode, output mode

d)

edit mode, table mode

39.

In the design mode you can enter, change:

a)

the field names, data types

b)

query criterion, forms

c)

data types, report

d)

report, he field names

40.

Ways of creating tables:

a)

By entering data

b)

By entering criterion

c)

with the help of macros

d)

with the help of report

41.

Types of database data:

a)

Text

b)

Index

c)

Percentages

d)

Letter

42.

Types of database data:

a)

Logical

b)

signs

c)

Letter

d)

Percentages

43.

Types of database data:

a)

Counter

b)

Percentages

c)

Index

d)

Letter

44.

Types of database data:

a)

date/time

b)

Percentages

c)

Index

d)

Letter

45.

The computer uses:

a)

binary system

b)

decimal system

c)

0-9

d)

roman numeral system

46.

The correct HTML for adding a background color

a)

<body bgcolor=yellow>

b)

<body bgcolor:yellow>

c)

<background>yellow</background>

d)

<body style=”yellow”></background>

47.

A database is:

a)

A systematized collection of data

b)

Drawing

c)

Graph

d)

Slide

48.

Key ICT growth directions:

a)

Cloud technologies

b)

Graphics

c)

Cellphones

d)

Case-tasks

49.

Private networks, usually located in the same building or in the territory of any organization:

a)

Local Networks

b)

MAN

c)

Internet

d)

Global Networks

50.

Web address is usually known as:

a)

URL

b)

WWW

c)

UML

d)

ADA

51.

A set of program instructions that attaches itself to a file, reproduces itself and spreads to other files

a)

Virus

b)

display

c)

Winrar

d)

Driver

52.

Internet services:

a)

WWW, E-Mail

b)

MS Office

c)

HTML

d)

MS Access

53.

Logical operation CONJUNCTION is…

a)

AND

b)

NOT

c)

OR

d)

XOR

54.

Software for create video:

a)

Windows Movie Maker

b)

Fine Reader

c)

MS Excel

d)

MS Word

55.

A multimedia program is a program that uses:

a)

sound, video, animation

b)

function

c)

diagram

d)

cell, video

56.

Types of clouds:

a)

public, private, hybrid

b)

common, public

c)

combine, hybrid

d)

public, combine

57.

Main objects of database:

a)

Tables, Requests, Forms

b)

Graphs, Requests, Slides

c)

Requests, Forms, Slides

d)

Forms, Slides, Drawings

58.

Address of cell consists of:

a)

name of column and name of raw

b)

name of raw

c)

name of column

d)

name of raw and name of column

59.

In the cloud you can create:

a)

document, table, presentation

b)

formula, video, music

c)

document, formula

d)

music, video, formula

60.

A multimedia program is a program that uses:

a)

sound, video, audio

b)

audio, video, text

c)

video, text, table

d)

text, video, audio

61.

The password consists of:

a)

letters, numbers, special characters

b)

slides, numbers, graphs

c)

numbers

d)

graphs

62.

>HTML is:

a)

means of creating Web pages

b)

programming language translator

c)

the Internet server

d)

Web browser

63.

Browsers are:

a)

web viewer

b)

antivirus software

c)

programming language translators

d)

Internet servers

64.

A computer connected to the Internet must have:

a)

IP Address

b)

Web server

c)

Home web page

d)

Domain name

65.

The basic protocol on the Internet is:

a)

TCP/IP

b)

HTTP

c)

HTML

d)

TCP

66.

There are browsers:

a)

Internet, Explorer Opera ,Mozilla Firefox

b)

Opera, Djv

c)

FTP, Mail

d)

Mozilla, Firefox FTP

67.

The Internet is:

a)

a global computer network

b)

a local computer network

c)

a regional computer network

d)

Campus computer network

68.

Internet service is:

a)

World Wide Web, E-mail, Usenet

b)

E-mail, HTML ,TC

c)

HTML, Usenet

d)

Usenet, TC

69.

IP address is:

a)

dynamic, statistic

b)

continuous, discrete

c)

discrete, statistic, continuous

d)

dynamic, constant

70.

An element of the graphical user interfaces that appears in a window and requests information, such as command parameters from a user:

a)

Dialog box

b)

Templates

c)

Basket

d)

My Computer

71.

In the context of user interfaces, a list of commands or options is often displayed as a list.

a)

Menu

b)

Dialog box

c)

Basket

d)

Desktop

72.

ACCESS data base management objects

a)

Macros, Module, Report

b)

Foreign key, Module

c)

DataTime

d)

DataTime, Report

73.

In Database system this logical operands is used to get specific information:

a)

AND, OR, NOT

b)

OR, NOT, ElSE

c)

NOT, Mixed

d)

ElSE, IF, NOT

74.

All information is erased when you turn off the computer:

a)

in RAM

b)

in ROM

c)

in CPU

d)

on a floppy disk

75.

The brains of the computer is the:

a)

CPU

b)

ROM

c)

RAM

d)

Hard disk

76.

Excel. Correctly written formula

a)

=A1+A2+A3

b)

Sum(A2:A10)

c)

A2+A3+AC=

d)

Sum(B1+B8)/A$2

e)

=1A+2A+5D

77.

Correctly written formula

a)

=Sum(A3:B6)*$A$1

b)

Sum(A3:B6)*A1=

c)

A1*B2+192

d)

D1= A1*B2+192

e)

=Sum(#A#3:B#6)*#A#1

78.

Select examples of input devices:

a)

keyboard,mouse

b)

printer,monitor

c)

printer, mouse

d)

mouse, monitor

79.

Select examples of output devices:

a)

monitor ,printer

b)

mouse, speaker

c)

printer, speaker

d)

speaker, keyboard

80.

Examples of peripheral devices:

a)

printers

b)

CPU

c)

unit

d)

monitor

81.

Types of software:

a)

Application software, System software

b)

Antivirus software, System software

c)

System software, Device software

d)

Device software

82.

Kinds of system software:

a)

Operating system

b)

Graphics software

c)

Word Processing

d)

Application software

83.

Types of software:

a)

Application software

b)

Global software

c)

Type software

d)

Local software

84.

Hardware components are:

a)

Speaker, printer, mouse

b)

Disk, modem

c)

Hard disk, driver

d)

Drivers, hub

85.

The types of OS:

a)

Windows

b)

MS Office Excel

c)

MS Office Word

d)

MS Office Power Point

86.

The smallest unit of information is:

a)

Bit

b)

KByte

c)

MByte

d)

Code

87.

MS Access. Maximum number of characters in a field name:

a)

64

b)

(4; 8; 16)

c)

16

d)

(16; 32; 62; 128)

88.

MS Excel. Value of logical expression = 18>-9:

a)

RIGHT

b)

ON

c)

YES

d)

TRUE

89.

A decimal number 224 equal

a)

E016

b)

3008

c)

C016

d)

2563

90.

A binary number 11100000 equal

a)

E016

b)

3008

c)

C016

d)

19210

91.

A hexadecimal system is made up of only:

a)

0-9, A, B, C, D, E,F

b)

0-7, A, B, C, D, E,F

c)

0

d)

1

92.

An octal system is made up of only:

a)

0-7

b)

0-9

c)

1

d)

A, B, C, D, E,F

93.

Advantages of Bus Topology:

a)

The smallest total length of the physical medium

b)

ease of organization and implementation

c)

Workstations

d)

Workstations can be inexpensive

94.

Computers are directly connected to a single cable in the topology:

a)

Bus topology

b)

Star topology

c)

Tree topology

d)

Hybrid

95.

All computers are interconnected in topology:

a)

Mesh topology

b)

Bus topology

c)

Star topology

d)

Hybrid

96.

Computers are connected to a single hub through a cable in the topology:

a)

Star topology

b)

Bus topology

c)

Mesh topology

d)

Hybrid

97.

Advantages of Mesh Topology:

a)

It is robust, Fully connected

b)

Every node has its own connection to the hub

c)

It transmits data only in one direction

d)

Every device is connected to a single cable

98.

Each computer is connected to two other computers:

a)

Ring topology

b)

Bus topology

c)

Mesh topology

d)

Tree topology

99.

Each computer is connected to two other computers:

a)

Ring topology

b)

Bus topology

c)

Mesh topology

d)

Tree topology

100.

These are image files formats:

a)

.jpg

b)

.txt

c)

.xlsx

d)

.doc

Similar Resources on Wayground

Seleksi iMSPQ-IMPHO 2022

100 questions

Seleksi iMSPQ-IMPHO 2022

quiz

Worksheet

•

University

Test 1 Botany Algae and Vocabulary

100 questions

Test 1 Botany Algae and Vocabulary

quiz

Worksheet

•

University

อุอิ

99 questions

อุอิ

quiz

Worksheet

•

University

Biol 232 Ch. 6 & Ch. 8

99 questions

Biol 232 Ch. 6 & Ch. 8

quiz

Worksheet

•

University

Word Within The Word Lists 1-4

100 questions

Word Within The Word Lists 1-4

quiz

Worksheet

•

3rd Grade - University

Bio 102 Exam 4 practice

103 questions

Bio 102 Exam 4 practice

quiz

Worksheet

•

University

Digestive System

100 questions

Digestive System

quiz

Worksheet

•

8th Grade - University

Quiz Pengetahuan Umum Jawa Timur

104 questions

Quiz Pengetahuan Umum Jawa Timur

quiz

Worksheet

•

University