Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

иновационный технология

Total questions: 75

Worksheet time: 38mins

Name
Class
Date
1.

A personal area network (PAN) a computer network that will be useful in communicating computerizes devices such as

a)

Telephones and PDAs

b)

HUB and client

c)

Firewalls and routers

d)

Servers and clients

e)

Node and server

2.

The basis of Metropolitan Area Network (MAN) category is a

a)

Node

b)

Scale

c)

Network Topology

d)

Area

e)

Entity

3.

A computer network covering a small geographic area, like a home, office, or group of buildings is

a)

Wide Area Network (WAN)

b)

A local area network (LAN)

c)

Security area Network

d)

Mobile handheld devices

e)

Firewalls

4.

A group of computers and network devices connected across large physical areas such as states or countries is called

a)

The Web Site connection

b)

Wide Area Network (WAN)

c)

Router Area

d)

Broadcast area

e)

Wide Area Network(LAN)

5.

The largest WAN in existence is

a)

Mozilla

b)

The Internet

c)

Ethernet

d)

Optical fiber

e)

Home PAN

6.

A  network that interconnects users with computer resources in a geographic area or region larger than that covered by a local area network (LAN) but smaller than the area covered by wide area network (WAN) is called

a)

Wireless LAN

b)

Home PNA

c)

Metropolitan Area Network (MAN)

d)

The Internet

e)

Firewall

7.

Network topology`s category is

a)

Client-server networking

b)

Peer-to-peer (workgroup)

c)

Ethernet

d)

Personal Area Network (PAN)

e)

Tree or Hierarchical topology

8.

The basis of Active-Networking category is

a)

Functional Relationship (Architecture)

b)

Home PNA

c)

Scale

d)

Network topology

e)

Client-server networking

9.

Which one is a category of  Connection method basis

a)

Laptops

b)

VoIP phones

c)

Broadcasts

d)

Wireless LAN

e)

DLC

10.

Computer networks can be classified by considering which of the  following aspect

a)

Data Link Control (DLC) address

b)

Media Access Control (MAC)address

c)

fault-tolerant features

d)

Local and wide area networks

e)

The functional relationship (Network Architectures)

11.

Most of the computer viruses are designed to

a)

Improve systems` work

b)

Update installed programs

c)

Not self-replicate

d)

Exploit some kind of an error (security hole)

e)

Help uploading applications

12.

Which virus runs on computers memory

a)

Worms

b)

Boots

c)

Direct Action Virus

d)

Resident virus

e)

Multipartite virus

13.

Nonresident viruses are activated

a)

When user performs specific activity such as accessing floppy/removable media

b)

Through the storage devices

c)

By executable code found in specific system areas on a disk

d)

Through email account

e)

Through the replication of malicious code

14.

Which programs make it possible to automate series of operations so that they are performed as a single action

a)

Adobe Flash

b)

MACROS

c)

Cleaners

d)

DevOps

e)

Anti-virus programs

15.

The functions of e-mail servers

a)

Restore , zip

b)

Store,relocate

c)

Archive,transmit

d)

Provides a way to locate a resource on the web

e)

To accept, forward, deliver, and store messages

16.

An e-mail must have a

a)

Server

b)

Username followed by an @ (at sign) which is followed by the domain name with a domain suffix

c)

Recipient

d)

Address

e)

ID

17.

What is an email client

a)

It`s an online e-mail service

b)

It's a new message

c)

It is a server of the recipient`s email service

d)

It is a computer program used to access and manage a user's email

e)

It is the location you type your main message

18.

Each domain name represents a unique Web address which is called

a)

The SMTP Server

b)

An e-mail client

c)

Internet protocol (IP) address

d)

Signature

e)

Carbon Copy

19.

… is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Excel

b)

Microsoft Access

c)

Microsoft Word

d)

Microsoft Power point

e)

Microsoft Publisher

20.

Which bar does give the user information about: the current worksheet,  data the worksheet contains and etc.

a)

The Formula bar

b)

The Title bar

c)

The Quick Access toolbar

d)

Status bar

e)

The Ribbon

21.

Which command  is used to check logical expression in MS Excel

a)

Avr

b)

Min

c)

Max

d)

Sum

e)

If statement

22.

Microsoft Excel consists of

a)

Tabs

b)

Worksheets

c)

Columns

d)

Toolbars

e)

Rows

23.

This function is used to add numbers

a)

the SIN

b)

the MAX

c)

the SUM

d)

the MIN

e)

the AVR

24.

In the MS Excel, a formula begins with … sign.

a)

“&”

b)

 “=”

c)

“@”

d)

“*”

e)

“/”

25.

MS Excel. The MAX function is

a)

automatically finds a maximum value of numbers

b)

automatically finds an average value of numbers

c)

automatically adds a column of numbers

d)

automatically finds a minimum value of numbers

e)

automatically counts an amount of numbers

26.

MS Excel. The MIN function is

a)

automatically finds a maximum value of numbers

b)

automatically finds a minimum value of numbers

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

automatically counts an amount of numbers

27.

MS Excel. The Count function is

a)

automatically finds a minimum value of numbers

b)

automatically adds a column of numbers

c)

automatically counts of the number of items in a list

d)

automatically finds a maximum value of numbers

e)

automatically finds an average value of numbers

28.

MS Excel. What happens by pressing Esc key and clicking anywhere on the worksheet

a)

finds an average value of numbers

b)

removes the highlighting

c)

adds the highlighted diapason

d)

appears a new column

e)

appears a new row

29.

How many pages  does The ribbon contain in MS Excel

a)

3

b)

8

c)

10

d)

5

e)

9

30.

Where does  Microsoft Excel display the name of the workbook you are currently using.

a)

On the Title bar

b)

On the Status bar

c)

On the ribbon

d)

On the Formula bar

e)

On the Quick Access tool bar

31.

If the =SUM(C1:C10) function is nested within an =IF() function and value is equal to 10, which expression displays value “Excellent”?

a)

=IF(C1:C10)=10;”Excellent”;”Bad”)

b)

=SUM(IF(C1:C10)=10;”Excellent”;”Bad”)

c)

=IF(SUM(C10:C1)=10;”Bad’;”Excellent”;”Bad”)

d)

=IF(SUM(C1:C10)=10;”Excellent”;”Bad”)

e)

=IF(SUM(C1:C10)=9;”Excellent”;”Bad”)

32.

How is the combination of a column coordinate and a row coordinate called?

a)

Acolumncoordinate

b)

A worksheet name

c)

A formula bar

d)

A cell address

e)

A title bar

33.

What does “test!” mean in the following expression:

a)

The coordinate of the cell

b)

The name of the workbook

c)

The reference to the worksheet ”test”

d)

=IF(test!D11=1;1;0).

e)

The address of the worksheet

34.

Which expression calculates the SUM of the highlighted range (R1:R17) ?

a)

=SIN(R3:R17)

b)

=SUM(R3:R17)

c)

=AVR(R3:R17)

d)

=MAX(R3:R17)

e)

=AUTOSUM(R3:R17)

35.

Which expression calculates the average of the highlighted range (R18:R20) ?

a)

=AVR(R3:R17)

b)

=AVR(R18:R20)

c)

=SIN(R3:R17)

d)

=MAX(R3:R17)

e)

=AUTOSUM(R3:R17)

36.

Which expression finds the maximum of the highlighted range (R18:R20) ?

a)

=MAX(R18:R20)

b)

=AUTOSUM(R3:R17)

c)

=MAX(R3:R17)

d)

=SIN(R3:R17)

e)

=AVR(R3:R17)

37.

 Which expression finds the minimum of the highlighted range (R18:R20) ?

a)

=MIN(R18:R20)

b)

=MIN(R3:R17)

c)

=AVR(R3:R17)

d)

=AUTOSUM(R3:R17)

e)

=SIN(R3:R17)

38.

Each worksheet contains

a)

Symbols

b)

data types

c)

Records

d)

Numbers

e)

columns and rows

39.

During execution, the application program is stored:

a)

in the operative memory;

b)

in video memory;

c)

in the processor;

d)

on the hard disk;

e)

in ROM.

40.

Function performed by peripheral devices ...

a)

data storage

b)

information processing

c)

program input control

d)

input and output of information

e)

computer control of a given program

41.

The server is

a)

network program that does not conduct a dialogue between one user and another

b)

network program that conducts a dialogue between one user and another

c)

A powerful computer to which other computers connect

d)

an individual user's computer connected to a public network

e)

standard defining the form of presentation and the method for forwarding the message

42.

A hard disk is a device, which provides

a)

to connect computers to the global network.

b)

data storage with random access;

c)

output of alphanumeric and graphic information;

d)

input of graphic information;

e)

storage of data on laser disks;

43.

Flash drives are devices that provide

a)

output of alphanumeric and graphic information on the sheet;

b)

input of graphic information;

c)

data storage with random access;

d)

output of alphanumeric and graphic information;

e)

input alphanumeric and graphic information.

44.

The biggest and complex integral microcircuit of the computer

a)

Network Card

b)

Video card

c)

Sound card

d)

Motherboard

e)

CPU

45.

Device used for transmitting information over telephone lines:

a)

network card

b)

Scanner

c)

Modem

d)

Microphone

e)

Printer

46.

Any information (text, graphic, sound, etc.) is written to disk in the form:

a)

picture;

b)

mathematical expressions.

c)

file;

d)

extensions;

e)

digits;

47.

While the operating system is loading there is a

a)

copying operating system files from a floppy disk to a hard disk;

b)

copying the contents of RAM to the hard disk;

c)

copying files to the hard disk.

d)

sequential downloading of files from the operating system to the random access memory;

e)

copying operating system files from CD-ROM to hard disk;

48.

The function of the operating system does not include:

a)

launching programs for execution

b)

dialogue with the user

c)

allocation of resources (RAM, cache, processor, etc.)

d)

input-output and data management

e)

transfer of information to a remote user

49.

Translate the number 32 from decimal to binary.

a)

010010

b)

100001

c)

111111

d)

100001

e)

100000

50.

Hardware is

a)

a hard disk inside the system unit

b)

one of the components of information technology - software

c)

one of the components of information technology - hardware

d)

CD

e)

reboot program

51.

Software is

a)

a hard disk inside the system unit

b)

CD

c)

one of the components of information technology - hardware

d)

All programs that installed on a computer

e)

reboot program

52.

Define the system software

a)

This is part of the software that serves to solve user tasks.

b)

It is a means of creating application programs.

c)

This is part of the software used to provide work of PC hardware and work with application programs.

d)

This is the set of programs of the operating system.

e)

These are standard programs

53.

Define the application software

a)

This is part of the operating system program

b)

This is a collection of utilities.

c)

This is the set of programs of the operating system

d)

This is part of the software needed to develop application programs.

e)

This is part of the software for solving application problems.

54.

Utilities are

 

 

a)

used for creating application programs.

b)

system programs for service purposes.

c)

application programs.

d)

 collection of tools.

e)

resident programs.

55.

General Application Programs

a)

This is a collection of applications for solving problems in a specific area of a PC application.

b)

Is a collection of programs for service purposes.

c)

These are the programs for solve problems in any area of the PC application.

d)

This is part of the software needed to develop system programs.

e)

This is the main part of the software needed to develop it.

56.

Anti-virus programs are:

a)

Utilities

b)

programming systems

c)

application programs.

d)

system programs.

e)

tools.

57.

The software tools are designed for:

a)

programming languages

b)

creation of system programs

c)

creation of application programs.

d)

creating utilities.

e)

creation of system and application programs.

58.

The software of the PC includes:

a)

system and tool software.

b)

none

c)

system, applied, instrumental software.

d)

system, problem and application programs.

e)

applied, problematic and instrumental software.

59.

Windows registry is an example of the following database:

a)

Network

b)

Hierarchical

c)

Relational

d)

Related

e)

object-oriented

60.

File is

a)

RAM

b)

Scanner

c)

Named area for storing documents

d)

Microprocessor

e)

Place on the disk in which the file names are stored

61.

A file that loads the drivers of external devices and sets the operating system parameters is represented as

a)

NORTON COMMANDER

b)

IO.SYS

c)

MSDOS.SYS

d)

CONFIG.SYS

e)

AUTOEXEC.BAT

62.

Define the operating system

a)

These are devices for controlling external devices.

b)

This is a tool for developing user programs.

c)

This is a system program that manages  all operations in the PC.

d)

It is an application program that allows the user to communicate with a PC.

e)

This is a system program for controlling external devices.

63.

Define drivers

a)

These are devices for controlling external devices.

b)

These are the tools for developing operating systems.

c)

These are application programs that serve individual peripheral devices.

d)

These are system programs that serve individual peripheral devices.

e)

These are operating system control devices.

64.

Catalog (or directory)…

.

a)

This is the hard drive where user files are stored

b)

This is a special place for storing the parameters of the operating system.

c)

This is a special place in the RAM where user files are stored.

d)

This is a special place on the disk where file names are stored.

e)

This is a system program for controlling external devices.

65.

Specify a symbol that combines the name and file type

a)

Comma

b)

Question mark

c)

Colon

d)

Star

e)

Dot

66.

The file system on the disk has

a)

network structure.

b)

dynamic structure.

c)

relational structure.

d)

tree structure.

e)

linear structure.

67.

2 Gigabyte is equal to

a)

2048 Bytes

b)

2048 Terabytes

c)

1024 Kilobytes

d)

2048 Megabytes

e)

2000 bits

68.

A hard disk is divided into tracks which is further subdivided into

a)

Clusters

b)

Vectors

c)

Heads

d)

Sectors

e)

Foots

69.

The file extension of MS-Power Point document is

a)

.xlsx

b)

doc

c)

.txt

d)

.PPT

e)

. docx

70.

The file extension of MS-Excel document in Office 2007 is

a)

.xlsx

b)

.txt

c)

. docx

d)

doc

e)

.ppt

71.

The main function of E-Government 

a)

the interaction among citizens, and the commercial institutions.

b)

the usual interaction among the Government, citizens, and the commercial institutions.

c)

the non-digital interaction among the Government, citizens, and the commercial institutions

d)

The computer interaction among the Government

e)

the digital interaction among the Government, citizens, and the commercial institutions.

72.

E-learning

a)

Traditional learning

b)

learning face-to-face

c)

Learning on a computer

d)

comprises of distributed learning, network or web-based learning

e)

Learning with electronic text

73.

SMART stands for

a)

Same-Monitoring Analysis and Recruitment Technology

b)

Self-Monitoring Analysis and Reporting Technology

c)

Self-Managing Analysis and Regarding Technology

d)

Self-Meaning Analysis and Recording Technology

e)

Safety-Monitoring Analysis and Recording Technology

74.

Multimedia Components are

a)

Graphics, Sound, speech

b)

Sound, speech

c)

text, sound, images, animation and video

d)

animation and video

e)

Text, IP address, file size, file name

75.

Platform-as-a-service (PaaS) refers to

a)

software applications over the Internet

b)

other datacenter infrastructure

c)

Internet services that supply software applications

d)

cloud computing services that supply an on-demand environment for developing, testing, delivering and managing software applications.

e)

Databases needed for development

Similar Resources on Wayground

เครือข่ายคอมพิวเตอร์เบื้องต้น

80 questions

เครือข่ายคอมพิวเตอร์เบื้องต้น

quiz

Worksheet

•

University

WebDev

79 questions

WebDev

quiz

Worksheet

•

University

H446 Section 1: Components of a computer

71 questions

H446 Section 1: Components of a computer

quiz

Worksheet

•

11th Grade - University

QUIZ FINALS 101TEN

70 questions

QUIZ FINALS 101TEN

quiz

Worksheet

•

University

QUIZZ RESEAU SISR SEMESTRE 1

76 questions

QUIZZ RESEAU SISR SEMESTRE 1

quiz

Worksheet

•

University

ID and Access Management

70 questions

ID and Access Management

quiz

Worksheet

•

10th Grade - University

Internet

70 questions

Internet

quiz

Worksheet

•

University

Computer Organization and Architecture Test 1

70 questions

Computer Organization and Architecture Test 1

quiz

Worksheet

•

University