wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

077beka

Total questions: 160

Worksheet time: 40hrs 0mins

Name
Class
Date
1.

"MS Access . Specify the type of the field if the name of the field " number of medicines "

a)

Textual

b)

Monetary

c)

Logical

d)

Numerical

e)

Memo

2.

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

a)

IO.SYS

b)

MSDOS.SYS

c)

CОNFIG.SYS

d)

AUTOEXEC.BAT

e)

NORTON COMMANDER

3.

The group of the local area networks unrolled in the compact territory of any establishment and servicing one building

a)

WAN

b)

PAN

c)

PHAN

d)

LAN

e)

PYAN

4.

What are the systems of interconnected computers that share a central storage system and various peripheral devices ounces 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)

The internet

b)

Home PNA

c)

Firewall

d)

Metropolitan Area Network MAN

5.

What does allow web developers to alter the layout and appearance of their web pages

a)

Cascading style sheet, CSS

b)

Domain name system DNS

c)

The internet Archive

d)

Internet engineering task force IETF

e)

Hypertext transfer protocol HTTP

6.

MS Excel . The MIN function is

a)

automatically adds a column of numbers

b)

automatically finds a maximum value of numbers

c)

automatically finds a minimum value of numbers

d)

automatically counts an amount of numbers

e)

automatically finds an average value of numbers

7.

Which of the following performs modulation and demodulation?

a)

Router

b)

Hub

c)

Switch

d)

Cable

e)

Modem

8.

Any hardware component that allows you to enter data, Programs, commands, and user responses into a computer is known as

a)

BIOS

b)

An output device

c)

Processing

d)

Power supply

e)

An input device

9.

Which virus runs on computers memory

a)

Boots

b)

Worms

c)

Multipartite virus

d)

Resident virus

e)

Direct action virus

10.

The computer hardware is typically divided into four main parts which are

a)

Local , broadband , personal , regional

b)

Printer , plotter , modem , headphones

c)

Control Unit ( CU ) and the Arithmetic and Logic Unit ( ALU )

d)

Processing Devices , Memory Devices , Input / , Output Devices

e)

Printers , Xerox , input and output devices.

11.

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

a)

On the Title bar

b)

On the Formula bar

c)

On the Quick Access tool bar

d)

On the ribbon

e)

On the Status bar

12.

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)

Broadcast area

c)

Router Area

d)

Wide Area Network ( WAN )

e)

LAN

13.

General Application Programs

a)

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

b)

programs Is a collection of programs for service purposes .

c)

This is a collection of applications for solving problems in a specific area of a 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

14.

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

a)

=IF ( SUM ( C1 C10 ) = 10,85kExcellentв Tk , в kBadв бk )

b)

= IF ( SUM ( C1 C10 ) = 9 , в Excellentв б , в бкBadв к )

c)

= IF ( C1 : C10 ) = 10 ; в БќЕxcellentв Ђќ в ЂќВад” )

d)

= IF ( SUM ( C10 C1 ) = 10 ”Bad†TM ”Excellent” ”BadeЂx

e)

= SUM ( IF ( C1 C10 ) = 10 , BBkExcellente TK , в 5kBadв бx )

15.

An e - mail must have a

a)

ID

b)

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

c)

Recipient

d)

Address

e)

Server

16.

The file system on the disk has

a)

network structure .

b)

relational structure .

c)

dynamic structure .

d)

linear structure .

e)

tree structure

17.

A hardware device that connects multiple devices on a computer network .

a)

modem

b)

router

c)

switch

d)

cable

e)

hub

18.

Which one defines the physical equipment that is involved in the computer functioning

a)

Hardware

b)

Firmware

c)

Nextware

d)

Software

e)

Hard disc

19.

HTML stands for

a)

Hyper Text Manipulating Links

b)

Hyper Text Manipulation Language

c)

Hyper Text Management Language

d)

Hyper Text Managing Links

e)

Hyper Text Markup Language

20.

Access . The data representation model is

a)

logical structure stored in the database

b)

software system for storing , adding , deleting and editing data in a database

c)

system of making managerial decisions involving computer

d)

diagram

e)

a set of programs for data exchange

21.

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

a)

= AUTOSUM ( R3 : R17 )

b)

= MAX ( R3 : R17 )

c)

= AVR ( R3 : R17 )

d)

= SUM ( R3 : R17 )

e)

= SIN ( R3 : R17 )

22.

DNS in internet technology stands for .

a)

Domain Name System

b)

Delivered Name system

c)

Dynamic Name System

d)

Distributed Name System

e)

Digited Name System

23.

Which option below researches the design and use of computer technology , focused on the interfaces between users and computers

a)

Task Bar

b)

Computer Hardware

c)

Humanв To computer interaction

d)

Shortcut Icons

e)

System software

24.

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

a)

finds an average value of numbers

b)

appears a new column

c)

appears a new row

d)

adds the highlighted diapason

e)

removes the highlighting

25.

What is the в ЂњНUB”

a)

A device used to run applications

b)

A device used to extend a network so that additional workstations can be attached

c)

Type of operating system

d)

Is a device for providing programs access

26.

Which is the largest unit of storage among the following ?

a)

Gigabyte

b)

Byte

c)

Megabyte

d)

Terabyte

e)

Kilobyte

27.

Specify a package that allows you to work with databases

a)

MS Access .

b)

Notepad

c)

Math Lab .

d)

MS Word .

e)

MathCAD .

28.

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

a)

file ;

b)

picture ;

c)

mathematical expressions .

d)

extensions ;

e)

digits ,

29.

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

a)

Node

b)

Network

c)

Topology Area

d)

Entity

e)

Scale

30.

The functions of e - mail servers

a)

To accept , forward , deliver , and store messages

b)

Restore , zip

c)

Archive , transmit

d)

Provides a way to locate a resource on the web

e)

Store , relocate

31.

In the MS Excel , a formula begins with BЂ ; sign .

a)

“ = ”

b)

“ * ”

c)

“ / ”

d)

“ & ”

e)

“ @ ”

32.

FTP is commonly used to

a)

Transfer Web page files from their creator to the computer

b)

Transmit the information from one place to the other

c)

Make connection

d)

Install applications

e)

Download programs

33.

During execution , the application program is stored :

a)

in the processor

b)

Stry on the hard disk

c)

in the operative memory

d)

in ROM

e)

in video memory

34.

Network topology's category is

a)

Personal Area Network ( PAN )

b)

Ethernet

c)

Tree or Hierarchical topology

d)

Peer - to - peer ( workgroup )

e)

Client - server networking

35.

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

a)

Local and wide area networks

b)

Media Access Control ( MAC ) address

c)

fault - tolerant features

d)

The functional relationship ( Network Architectures )

e)

Data Link Control ( DLC ) address

36.

This is an application layer protocol which moves files between a client and server on a computer network .

a)

HTTP

b)

POP3

c)

FTP

d)

TCP / IP

e)

SMPT

37.

One byte equals to

a)

1024 bits

b)

1 bits

c)

16 bits

d)

8 bits

e)

256 bits

38.

What are the systems of interconnected computers that share a central storage system and various peripheral devices

a)

Computer systems

b)

Networking

c)

Hardware

d)

ICloud system

e)

Firmware

39.

Avr Microsoft Excel consists of

a)

Columns

b)

Toolbars

c)

Worksheets

d)

Tabs

e)

Rows

40.

Windows registry is an example of the following database :

a)

Related

b)

Relational

c)

Network

d)

Hierarchical

e)

object – oriented

41.

A hardware device that divides the network connection among multiple devices

a)

hub

b)

modem

c)

router

d)

cable

e)

switch

42.

A hard disk is a device , which provides

a)

storage of data on laser disks

b)

output of alphanumeric and graphic information

c)

to connect computers to the global network

d)

input of graphic information

e)

data storage with random access

43.

RAM means :

a)

Revolving Access Memory

b)

Random Access Memory

c)

Range Access Memory

d)

Rapid Access Memory

e)

Rigid Access Memory

44.

Most of the computer viruses are designed to

a)

Exploit some kind of an error ( security hole )

b)

Not self - replicate

c)

Update installed programs

d)

Help uploading applications

e)

Improve systems ' work

45.

The first technical characteristics of a CPU is a

a)

Reliability

b)

Speed

c)

The accuracy

d)

No feeling

e)

Diligence

46.

What is a browser

a)

Largest service acquired amongst the services provided by the Internet

b)

Transmission of information from one place to the other

c)

A computer software which can be used to view documents on the Internet

d)

Foundation of data communication

e)

Set of rules and guidelines for communicating data

47.

Rules of an exchange of information between computers through a network

a)

Spreadsheet

b)

The executed program

c)

Protocol

d)

Standard programs

e)

Text editor

48.

Which one is used to connect tables in MS Access ?

a)

Macros

b)

Data scheme

c)

Table

d)

Forms

e)

Record

49.

What is a router

a)

Devices used to connect end devices to the network

b)

A device used to extend a network so that additional workstations can be attached

c)

Device attached to the network to obtain human computer interaction

d)

A device which makes the use of computer technology cost effective

e)

A networking device that forwards packets between networks using information in protocol headers

50.

Each domain name represents a unique Web address which is called

a)

Signature

b)

The SMTP Server

c)

Carbon Copy

d)

Internet protocol ( IP ) address

e)

An e - mail client

51.

Utilities are

a)

application programs .

b)

collection of tools

c)

used for creating application programs

d)

resident programs

e)

system programs for service purposes

52.

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

a)

Telephones and PDAs

b)

Firewalls and routers

c)

Servers and clients

d)

HUB and client

e)

Node and server

53.

What does вбtеst ! вк mean in the following expression :

a)

The coordinate of the cell

b)

The name of the workbook

c)

The reference to the worksheet BTktestв Tk

d)

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

e)

The address of the worksheet

54.

While the operating system is loading there is a

a)

copying files to the hard disk .

b)

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

c)

copying the contents of RAM to the hard disk

d)

copying operating system files from CD - ROM to hard disk

e)

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

55.

MS Excel . The MAX function is

a)

automatically adds a column of numbers

b)

automatically finds a maximum value of numbers

c)

automatically finds a minimum value of numbers

d)

automatically counts an amount of numbers

e)

automatically finds an average value of numbers

56.

Hardware is

a)

reboot program

b)

one of the components of information technology - hardware

c)

a hard disk inside the system unit

d)

one of the components of information technology – software

e)

CD

57.

Which command is used to check logical expression in MS Excel

a)

If statement

b)

Min

c)

Sum

d)

Max

e)

Middle

58.

The configuration ( topology ) of a local computer network in which all workstations are consistently connected with each other is called :

a)

Mesh

b)

Bus

c)

Tree

d)

Ring

e)

Star

59.

What of the given network topologies represents the closed chain ?

a)

Ring

b)

Star

c)

Mesh

d)

Bus

e)

Tree

60.

Most common type of computers in the society are в¹б

a)

Super computers

b)

Minicomputers

c)

Mainframes

d)

Double computers

e)

Personal computers

61.

Which of the followings is used by the user to interact directly with the computer system by typing commands ( instructions ) in the command line

a)

A Graphic user interface

b)

A Text interface with menus

c)

A Desktop Interface

d)

A Command Line interface

e)

A Voice user interfaces

62.

What contains the CPU , BIOS , memory , mass storage interfaces , serial / parallel ports , expansion slots , and all the controllers required to control standard peripheral devices

a)

storage device

b)

ALU

c)

Control unit

d)

the motherboard

e)

RAM

63.

The main problem of human - computer interaction is how to improve

a)

the reliability of CPU

b)

the usability of computer interfaces

c)

The diligence of computer interfaces

d)

The accuracy of computer interfaces

e)

the speed of CPU

64.

The binary number system consists of the following symbols :

a)

0..7

b)

0..1

c)

0..9

d)

0..5

e)

0..9 ; a..f

65.

The server is

a)

network program that conducts a dialogue between one user and another

b)

A powerful computer to which other computers connect

c)

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

d)

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

e)

an individual user's computer connected to a public network

66.

Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide ?

a)

Transition Settings

b)

There is no right answer

c)

Handouts

d)

Color Schemes

e)

Animation

67.

This protocol specifies how data is exchanged over the internet by providing end - to - end communications that identify how it should be broken into packets , addressed , transmitted , routed and received at the destination .

a)

SMPT

b)

FTP

c)

TCP / IP

d)

HTTP

e)

POP3

68.

Each worksheet contains ( MS Excel )

a)

Numbers

b)

Symbols

c)

Records

d)

data types

e)

columns and rows

69.

File is

a)

Microprocessor

b)

RAM

c)

Place on the disk in which the file names are stored

d)

Scanner

e)

Named area for storing documents

70.

What does Humanв computer interaction study in communication

a)

A human and a machine

b)

A computer and applications

c)

User and users

d)

Computer and software

e)

A computer and Computer systems

71.

Nonresident viruses are activated

a)

Through the replication of malicious code

b)

Through the storage devices

c)

By executable code found in specific system areas on a disk

d)

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

e)

Through email account

72.

Define drivers

a)

These are application programs that serve individual peripheral devices .

b)

These are the tools for developing operating systems .

c)

These are devices for controlling external devices .

d)

These are system programs that serve individual peripheral devices

e)

These are operating system control devices

73.

Unique address of the Web page

a)

FTP

b)

URL

c)

POP3

d)

URN

e)

IP

74.

Function performed by peripheral devices ...

a)

information processing

b)

input and output of information

c)

computer control of a given program

d)

data storage

e)

program input control

75.

The geometrical scheme of computer association is called

a)

Ring topology

b)

Local network

c)

Network topology

d)

Local topology

e)

Tire topology

76.

Anti - virus programs are :

a)

system programs .

b)

programming systems

c)

tools .

d)

Utilities

e)

application programs .

77.

Specify a symbol that combines the name and file type

a)

Dot

b)

Comma

c)

Colon

d)

Star

e)

Question mark

78.

Which type of computer is capable of handling and processing very large amounts of data quickly

a)

Mainframes

b)

Microcomputers

c)

Minicomputers

d)

Double computers

e)

Super computers

79.

The hexadecimal number system consists of the symbols

a)

0..5 , A..F

b)

0..1

c)

0..9

d)

0..7

e)

0..9. A . F

80.

List the main objects of the Access database :

a)

In the Access database , the main objects are tables , queries , forms , reports

b)

In the Access database , the main objects are tables , queries , macros , and modules

c)

In the Access database , the main objects are tables , queries , macros , and forms

d)

In the Access database , the main objects are tables , queries , forms , reports , macros , and modules

e)

In the Access database , the main objects are tables , reports , macros , and modules

81.

Query in MS Access :

a)

Formalized requirements for sampling data from tables or performing certain actions with data

b)

An object in which the developer places controls that accept user actions or serve to enter , display , and modify data in fields

c)

Displays all the fields of a single entry , it is convenient for entering and editing dat

d)

Represents the macro sequence of the built - in Access language

e)

To enter and edit data

82.

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

a)

= MAX ( R18 : R20 )

b)

= AVR ( R3 : R17 )

c)

= SIN ( R3 : R17

d)

= AUTOSUM ( R3 : R17 )

e)

= MAX ( R3 : R17 )

83.

Types of addressing in Excel spreadsheet :

a)

Relative , absolute , simple

b)

Absolute , simple , mixed .

c)

Absolute , relative , mixed .

d)

Absolute , mixed , simple .

e)

Relative , mixed , simple

84.

Network topology's category is

a)

Ethernet

b)

Peer - to - peer ( workgroup )

c)

Client - server networking

d)

Personal Area Network ( PAN )

e)

Tree or Hierarchical topology

85.

Gigabyte is equal to

a)

2048 Megabytes

b)

1024 Kilobytes

c)

1024 bits

d)

2048 Terabytes

e)

2048 Bytes

86.

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

a)

Anti - virus programs

b)

MACROS

c)

Cleaners

d)

Adobe Flash

e)

DevOps

87.

What does have several processors rather than just one and may be dedicated to a specific support function

a)

Intermediary device

b)

Router

c)

Network

d)

Server

e)

Broadcast

88.

This is the practice of protecting systems , networks , and programs from digital attacks . These are usually aimed at accessing , changing , or destroying sensitive information , extorting money from users , or interrupting normal business processes .

a)

Cybersecurity

b)

Encryption

c)

decryption

d)

coding

e)

decoding

89.

The octal number system consists of the following symbols :

a)

0..9 ; a..f

b)

0..1

c)

0..7

d)

0..5

e)

0..9

90.

Basic topology of a computer network in which all computers of network are attached to central node ( usually the switch ) , forming physical network segment .

a)

Cell

b)

Bus

c)

Ring

d)

Tree

e)

Star

91.

HTML is basically used to design :

a)

Calculations Pe

b)

Web – site

c)

Graphics

d)

Tables and Frames

e)

Web - page

92.

The file extension of MS - Power Point document is

a)

txt

b)

Stry .

c)

docx .

d)

xlsx .

e)

pptC ...

93.

Which one of the following is an example of Operating System ?

a)

Microsoft Excel

b)

Microsoft Word

c)

Microsoft Windows

d)

Microsoft Access

e)

Microsoft Power Point

94.

The protocol , domain , directories , and files are all separated by

a)

Periods ( )

b)

Low lines (_)

c)

Asterisks ( * )

d)

Commas ( ₁ )

e)

Forward slashes ( / )

95.

Nonresident viruses are activated

a)

Through the replication of malicious code

b)

Through the storage devices

c)

Through email account

d)

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

e)

By executable code found in specific system areas on a disk

96.

Which of the following is the appropriate definition of a computer ?

a)

Computer is a machine that can process information .

b)

Computer is an electronic device that can store , retrieve and process both qualitative and quantitative data quickly and accurately

c)

Computer is a machine that can store , retrieve and process quickly and accurately only qualitative information .

d)

Computer is an electronic device that can store , retrieve and quickly process only quantitative data .

e)

Computer is a car that can store , retrieve and process quickly and accurately only qualitative information .

97.

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

a)

Foots

b)

Clusters

c)

Vectors

d)

Heads

e)

Sectors

98.

The largest WAN in existence is

a)

Mozilla

b)

Home PAN

c)

Ethernet

d)

Optical fiber

e)

The Internet

99.

Computer programs installed in the computer are called BT5

a)

Engineering

b)

Hardware

c)

Firmware

d)

Software

e)

Hard disc

100.

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

a)

Firewalls

b)

Wide Area Network ( WAN )

c)

Security area Network

d)

A local area network( LAN )

e)

Mobile handheld devices

101.

Define the operating system

a)

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

b)

This is a tool for developing user programs .

c)

These are devices for controlling external devices .

d)

This is a system program for controlling external devices .

e)

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

102.

The software of the PC includes :

a)

system , applied , instrumental software .

b)

none

c)

applied , problematic and instrumental software

d)

system , problem and application programs .

e)

system and tool software .

103.

What are the systems of interconnected computers that share a central storage system and various peripheral devices

a)

Computer systems

b)

Hardware

c)

Networking

d)

ICloud system

e)

Firmware

104.

MS Access . Specify the field type if the field name is " date of birth "

a)

Logical

b)

Currency

c)

Number

d)

Text

e)

Date Time

105.

A computer which is capable of receiving the information from the server in the Internet is called a

a)

Service

b)

Client

c)

Locator

d)

Domain

e)

Server

106.

What is a presentation ?

a)

Something that comes on TV

b)

program for watching movies

c)

A collection of data and information that is delivered to a specific audience

d)

A special program of data and information used to make a point

e)

A function and collection of data and files

107.

During execution , the application program is stored :

a)

in the operative memory

b)

on the hard disk ;

c)

in video memory ;

d)

in ROM .

e)

in the processor ,

108.

An Internet Protocol ( IP ) address is a

a)

Set of devices which perform typical tasks for appropriate function of hard disk

b)

Set of devices which form the interface between the human network and the underlying communication network

c)

Set of devices which obtain protection functions

d)

Numerical identification ( logical address ) that is assigned to devices participating in a computer network

e)

Numerical identification ( logical address ) that is assigned to provide network

109.

The main functions of the operating system include :

a)

Dialog with the user , control the resources of the computer , start the program .

b)

Print information by the printer

c)

Copying information from the scanner to the computer , starting the program

d)

Management of computer resources , execution of computer programs .

e)

Dialogue with the user , creating a computer program

110.

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

a)

Security area Network

b)

Firewalls

c)

Mobile handheld devices

d)

Wide Area Network ( WAN )

e)

A local area network ( LAN )

111.

ICT stands for :

a)

Information and Communication Technology

b)

Intera Common Terminology

c)

International Communication Technology

d)

Inter connected Terminals

e)

Internet and Communication Technology

112.

WWW stands for

a)

word wide web

b)

world wide web

c)

who what and where

d)

weird wide web

e)

Wind wild web

113.

File is

a)

Scanner

b)

Microprocessor

c)

Place on the disk in which the file names are stored

d)

Named area for storing documents

e)

RAM

114.

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

a)

= MAX ( R3 : R17 )

b)

= AUTOSUM 3 : R17 )

c)

= AVR ( R3 : R17 )

d)

= AVR ( R18 : R20 )

e)

= SIN ( R3 : R17 )

115.

Technologies designed for the joint implementation of information and communication processes .

a)

Emerging technologies

b)

Information and communication technology

c)

Cryptography

d)

Computer science

e)

Robot technology and automation

116.

A graphic that allows you to compare and contrast data in a visual format

a)

Chart

b)

Drawings

c)

Figures

d)

Plot

e)

Legend

117.

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

a)

LAN

b)

Broadcast area

c)

Wide Area Network ( WAN )

d)

Router Area

e)

The Web Site connection

118.

The service intended for data communication for the World Wide Web , where hypertext documents include hyperlinks to other resources that the user can easily access .

a)

POP3

b)

TCP / IP

c)

FTP

d)

SMPT

e)

HTTP

119.

Software is

a)

CD

b)

a hard disk inside the system unit

c)

one of the components of information technology - hardware

d)

reboot program

e)

All programs that installed on a computer

120.

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

a)

A cell address

b)

A title bar

c)

A formula bar

d)

Acolumncoordinate

e)

A worksheet name

121.

What is blog ?

a)

Online music

b)

Intranet

c)

A personal or corporate Google search

d)

Data storage

e)

A personal or corporate website in the form of an online journal

122.

The biggest and complex integral microcircuit of the computer

a)

Network Card

b)

CPU

c)

Video card

d)

Motherboard

e)

Sound card

123.

Slide sorter of PowerPoint is available on menu .

a)

Layout

b)

File

c)

Edit

d)

View

e)

Insert

124.

Type of Operating Systems

a)

micro - user single – task

b)

single - user single – task

c)

mini - user single - task

d)

mini - user mini – task

e)

multi - user micro – task

125.

Microsoft Excel consists of

a)

Rows

b)

Worksheets

c)

Columns

d)

Toolbars

e)

Tabs

126.

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

a)

appears a new column

b)

removes the highlighting

c)

adds the highlighted diapason

d)

finds an average value of numbers

e)

appears a new row

127.

How many pages does The ribbon contain in MS Excel

a)

8

b)

9

c)

10

d)

5

e)

3

128.

Catalog ( or directory ) ...

a)

This is a special place on the disk where file names 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 system program for controlling external devices

e)

This is the hard drive where user files are stored

129.

The device needed to connect computers to the local network :

a)

Plume

b)

video card

c)

Network Card

d)

Tire

e)

TV tuner

130.

FTP is commonly used to

a)

Install applications

b)

Transmit the information from one place to the other

c)

Transfer Web page files from their creator to the computer

d)

Downlo programs

e)

Make connection

131.

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

a)

Entity

b)

Node

c)

Area

d)

Network Topology

e)

Scale

132.

This is a network model that offers centralized access to services and devices and one computer plays the role of a server .

a)

Ethernet

b)

Client server network

c)

ATM

d)

Peer to peer network

e)

Token Ring

133.

In HCI on the human side , there are not considered concepts such as

a)

social sciences

b)

linguistics

c)

communication theory

d)

computer graphics

e)

cognitive psychology

134.

What is an email client

a)

It's an online e - mail service

b)

It is the location you type your main message

c)

It's a new message

d)

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

e)

It is a server of the recipient's email service

135.

What is the BбHHUBBTK

a)

A device used to extend a network so that additional workstations can be attached

b)

Name of the Browser

c)

Is a device for providing programs access

d)

A device used to run applications

e)

Type of operating system

136.

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

a)

The Ribbon

b)

The Formula bar

c)

The Quick Access toolbar

d)

The Title bar

e)

Status bar

137.

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

a)

.txt

b)

.pptC ...

c)

.html

d)

.docx

e)

.xlsx

138.

Which PowerPoint feature allows the user to create a simple presentation without having to spend too much time on it ?

a)

AutoContent Wizard

b)

Animation

c)

Triggers

d)

Chart Wizard

e)

Color Schemes

139.

Define the system software

a)

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

b)

This is the set of programs of the operating system .

c)

These are standard programs

d)

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

e)

It is a means of creating application programs

140.

Single - user single - task OS allows

a)

many applications running at the same time

b)

Keep logs of how much processing time and resources they use

c)

only one person running only one application at a time

d)

Each user logged on to the system , their workspace and so on

e)

Work out the most efficient use of computer processing cycles

141.

MS Excel . The count function is

a)

automatically adds a column of numbers

b)

automatically counts of the number of items in a list

c)

automatically finds an average value of numbers

d)

automatically finds a minimum value of numbers

e)

automatically finds a maximum value of numbers

142.

Utilities are

a)

system programs for service purposes .

b)

collection of tools

c)

resident programs .

d)

used for creating application programs .

e)

application programs .

143.

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

a)

LAN

b)

Router Area

c)

The Web Site connection

d)

Broadcast area

e)

Wide Area Network ( WAN )

144.

Device used for transmitting information over telephone lines :

a)

Modem

b)

Printer

c)

Scanner - network card

d)

Microphone

145.

Flash drives are devices that provide

a)

input of graphic information ;

b)

output of alphanumeric and graphic information ;

c)

output of alphanumeric and graphic information on the sheet ,

d)

input alphanumeric and graphic information .

e)

data storage with random access ;

146.

Which device is not classified as an input device

a)

Printer

b)

Trackball

c)

Joystick

d)

Mouse

e)

Keyboard

147.

A series of instructions that tells a computer how to perform the tasks is called

a)

Device

b)

A program

c)

Number

d)

Command

e)

Text

148.

Which one is a category of Connection method basis

a)

Broadcasts

b)

Wireless LAN

c)

VoIP phones

d)

DLC

e)

Laptops

149.

The average of the contents of the cells from A1 to A10 is calculated by the formula in Excel :

a)

= SIN ( R3 : R17 )

b)

= AVERAGE ( A1 : A10 ) .

c)

= MAX ( R17 : R21 )

d)

= AVR ( R3 : R17 )

e)

= AUTOSUM ( R3 : R17 )

150.

Which one of the following is not a network device ?

a)

CPU

b)

Hub

c)

bridge

d)

Switch

e)

Router

151.

What does вбtestlвk mean in the following expression :

a)

The name of the workbook

b)

The address of the worksheet

c)

The reference to the worksheet в TktestвTK

d)

= IF ( testID11 = 1,1,0 ) .

e)

The coordinate of the cell

152.

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

a)

= SIN ( R3 : R17 )

b)

= AUTOSUM ( R3 : R17 )

c)

= AVR ( R3 : R17 )

d)

= MIN ( R18 : R20 )

e)

= MIN ( R3 : R17 )

153.

The first computers appeared in …

a)

1956

b)

1957

c)

1935

d)

1948

e)

1946

154.

The software tools are designed for :

a)

creation of system and application programs .

b)

programming languages

c)

creating utilities .

d)

creation of application programs .

e)

creation of system programs .

155.

BT is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Excel

b)

Microsoft Access

c)

Microsoft Publisher

d)

Microsoft Word

e)

Microsoft Power point

156.

What contains the CPU , BIOS , memory , mass storage interfaces , serial / paralel ports , expansion slots , and all the controllers required to control standard peripheral devices

a)

Control unit

b)

ALU

c)

RAM

d)

the motherboard

e)

storage device

157.

The function of the operating system does not include :

a)

Input - output and data management

b)

Dialogue with the user

c)

Launching programs for execution

d)

Transfer of information to a remote user

e)

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

158.

Define the application software

a)

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

b)

This is part of the software for solving application problems .

c)

This is part of the operating system program

d)

This is a collection of utilities .

e)

This is the set of programs of the operating system

159.

The basis of Active - Networking category is

a)

Network topology

b)

Functional Relationship ( Architecture )

c)

Client - server networking

d)

Scale

e)

Home PNA

160.

Which one is used to connect tables in MS Access ?

a)

Forms

b)

Forms

c)

Table

d)

Macros

e)

Data scheme

Similar Resources on Wayground

Mạng máy tính

156 questions

Mạng máy tính

quiz

Worksheet

•

University