wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

икт 2 курс

Total questions: 65

Worksheet time: 33mins

Name
Class
Date
1.

Each domain name represents a unique Web address which is called

a)

An e-mail client

b)

Internet protocol (IP) address

c)

Carbon Copy

d)

Signature

e)

The SMTP Server

2.

… is an electronic spreadsheet that runs on a personal computer

a)

Microsoft Power point

b)

Microsoft Excel

c)

Microsoft Word

d)

Microsoft Access

e)

Microsoft Publisher

3.

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

a)

The Formula bar

b)

Status bar

c)

The Quick Access toolbar

d)

The Ribbon  

e)

The Title bar

4.

Which command  is used to check logical expression in MS Excel

a)

Sum

b)

If statement

c)

Max

d)

Min

e)

Avr

5.

Microsoft Excel consists of

a)

Rows

b)

Worksheets

c)

Columns

d)

Toolbars

e)

Tabs

6.

This function is used to add numbers

a)

the MAX

b)

the SUM

c)

the AVR

d)

the MIN

e)

the SIN

7.

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

a)

“/”

b)

“=”

c)

“@”

d)

“*”

e)

“&”

8.

MS Excel. The MAX function is

a)

automatically finds a minimum value of numbers

b)

automatically finds a maximum value of numbers

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

automatically adds a column of numbers

9.

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

10.

MS Excel. The Count function is

a)

automatically finds a maximum value of numbers

b)

automatically counts of the number of items in a list

c)

automatically finds an average value of numbers

d)

automatically adds a column of numbers

e)

Automatically  finds a minimum value of numbers

11.

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

a)

adds the highlighted diapason

b)

removes the highlighting

c)

appears a new column

d)

appears a new row

e)

finds an average value of numbers

12.

How many pages  does The ribbon contain in MS Excel

a)

5

b)

8

c)

10

d)

9

e)

3

13.

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

a)

On the Status bar

b)

On the Title bar

c)

On the ribbon

d)

On the Formula bar

e)

On the Quick Access tool bar

14.

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

a)

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

b)

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

c)

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

d)

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

e)

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

15.

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

a)

A formula bar

b)

A cell address

c)

A title bar

d)

A worksheet name

e)

Acolumncoordinate

16.

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

a)

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

b)

The reference to the worksheet ”test”

c)

The name of the workbook

d)

The address of the worksheet

e)

The coordinate of the cell

17.

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

a)

=AVR(R3:R17)

b)

=SUM(R3:R17)

c)

=MAX(R3:R17)

d)

=AUTOSUM(R3:R17)

e)

=SIN(R3:R17)

18.

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

a)

=AVR(R3:R17)

b)

=AVR(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MAX(R3:R17)

19.

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

a)

=AVR(R3:R17)

b)

=MAX(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MAX(R3:R17)

20.

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

a)

=AVR(R3:R17)

b)

=MIN(R18:R20)

c)

=AUTOSUM(R3:R17)

d)

=SIN(R3:R17)

e)

=MIN(R3:R17)

21.

Each worksheet contains

a)

Records

b)

columns and rows

c)

Numbers

d)

data types

e)

Symbols

22.

During execution, the application program is stored:

a)

in video memory;

b)

in the operative memory;

c)

in the processor;

d)

on the hard disk;

e)

in ROM.

23.

Function performed by peripheral devices ...

a)

data storage

b)

input and output of information

c)

information processing

d)

computer control of a given program

e)

program input control

24.

The server is

a)

network program that conducts a dialogue between one user and another

b)

an individual user's computer connected to a public network

c)

tandard 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)

A powerful computer to which other computers connect

25.

A hard disk is a device, which provides

a)

input of graphic information;

b)

output of alphanumeric and graphic information;

c)

storage of data on laser disks;

d)

data storage with random access;

e)

to connect computers to the global network.

26.

Flash drives are devices that provide

a)

output of alphanumeric and graphic information;

b)

input of graphic information;

c)

data storage with random access;

d)

output of alphanumeric and graphic information on the sheet;

e)

input alphanumeric and graphic information.

27.

The biggest and complex integral microcircuit of the computer

a)

Motherboard

b)

Network Card

c)

Sound card

d)

CPU

e)

Video card

28.

Device used for transmitting information over telephone lines:

a)

Microphone

b)

Scanner

c)

Modem

d)

network card

e)

Printer

29.

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

a)

picture

b)

file

c)

digits

d)

extensions

e)

mathematical expressions

30.

While the operating system is loading there is a

a)

copying files to the hard disk.

b)

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

c)

copying the contents of RAM 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;

31.

The function of the operating system does not include:

a)

input-output and data management

b)

dialogue with the user

c)

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

d)

transfer of information to a remote user

e)

launching programs for execution

32.

Translate the number 32 from decimal to binary.

a)

100001

b)

010010

c)

111111

d)

100000

e)

100001

33.

Hardware is

a)

one of the components of information technology - hardware

b)

CD

c)

reboot program

d)

a hard disk inside the system unit

e)

one of the components of information technology - software

34.

Software is

a)

one of the components of information technology - hardware

b)

a hard disk inside the system unit

c)

All programs that installed on a computer

d)

CD

e)

reboot program

35.

Define the system software

a)

This is the set of programs of the operating system

b)

It is a means of creating application programs.

c)

This is the set of programs of the operating system

d)

These are standard programs

e)

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

36.

Define the application software

a)

This is part of the software for solving application problems.

b)

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

c)

This is the set of programs of the operating system

d)

This is a collection of utilities.

e)

This is part of the operating system program

37.

Utilities are

a)

system programs for service purposes.

b)

collection of tools.

c)

collection of tools.

d)

application programs

e)

used for creating application programs.

38.

General Application Programs

a)

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

b)

This is part of the software needed to develop system programs

c)

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

d)

Is a collection of programs for service purposes.

e)

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

39.

Anti-virus programs are:

a)

system programs.

b)

application programs.

c)

tools.

d)

programming systems

e)

Utilities

40.

The software tools are designed for:

a)

creation of application programs.

b)

creation of system programs.

c)

creation of system and application programs.

d)

creating utilities.

e)

programming languages

41.

The software of the PC includes:

a)

system, problem and application programs.

b)

system and tool software.

c)

applied, problematic and instrumental software.

d)

system, applied, instrumental software.

e)

none

42.

Windows registry is an example of the following database:

a)

Relational

b)

Related

c)

Network

d)

Hierarchical

e)

object-oriented

43.

File is

a)

Microprocessor

b)

Place on the disk in which the file names are stored

c)

RAM

d)

Named area for storing documents

e)

Scanner

44.

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

a)

MSDOS.SYS

b)

CONFIG.SYS

c)

AUTOEXEC.BAT

d)

IO.SYS

e)

NORTON COMMANDER

45.

Define the operating system

a)

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

b)

This is a system program for controlling external devices

c)

This is a tool for developing user programs

d)

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

e)

These are devices for controlling external devices.

46.

Define drivers

a)

These are application programs that serve individual peripheral devices.

b)

These are system programs that serve individual peripheral devices.

c)

These are the tools for developing operating systems.

d)

These are devices for controlling external devices.

e)

These are operating system control devices.

47.

Specify a package that allows you to work with databases ...

a)

MathCAD.

b)

Math Lab.

c)

MS Access.

d)

MS word.

e)

Notepad

48.

Which one is used to connect tables in MS Access?

a)

Forms

b)

Macros

c)

Record

d)

Data scheme

e)

Table

49.

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

a)

Text

b)

Date Time

c)

Number

d)

Logical

e)

Currency

50.

Query in MS Access:

a)

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

b)

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

c)

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

d)

To enter and edit data.

e)

Represents the macro sequence of the built-in Access language

51.

The first computers appeared in ...

a)

1948

b)

1936

c)

1946

d)

1949

e)

1951

52.

List the main objects of the Access database:

a)

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

b)

In the Access database, the main objects are tables, queries, forms, reports, 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, reports, macros, and modules.

e)

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

53.

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

a)

= SIGNAL (A1, A10).

b)

= AVERAGE (A1: A10).

c)

= SUM (A1: A10).

d)

= CP3HA4 (A1; A10) ..

e)

= DA1; A10)

54.

1 megabyte is equal to

a)

1024 KB

b)

8 bytes

c)

8 bits

d)

2

e)

1000 KB

55.

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

a)

monetary

b)

textual

c)

logical

d)

numerical

e)

memo

56.

MS Excel. Specify the correct summation formula entry ...

a)

of the sums A1: A10

b)

= sums (A1: A10)

c)

= sumA1: A10

d)

sums (A1: A10)

e)

sum (A1: A10)

57.

Specify which of the following is the "brain" of the computer

a)

CD-R.

b)

Monitor

c)

Keyboard

d)

Processor

e)

RAM

58.

The hyperlink allows:

a)

move to the place of the bookmark.

b)

save documents.

c)

view pictures.

d)

archive documents.

e)

create new documents.

59.

MSAccess. Macros is ....

a)

An object that represents a structured description of several actions that Access Basic must perform

b)

An object that is a structured description of one action that Access Basic must perform

c)

An object that is a structured description of one action

d)

An object that is a structured description of several actions that [Human computer interaction] must perform

e)

An object that is a structured description of one or more actions that Access Basic must perform, and which allows you to break the process into smaller actions

60.

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

a)

Cascading Style Sheet, CSS

b)

Internet Engineering Task Force (IETF)

c)

Domain Name System (DNS)

d)

HyperText Transfer Protocol (HTTP)

e)

The Internet Archive

61.

Why are web pages called “hypertext documents”

a)

Because when you click a word or a picture which is hyper linked you can go to another location

b)

They contain only text

c)

Because it accepts information through text

d)

Because it is made for readable manner

e)

Documents are used for storing text

62.

FTP is commonly used to

a)

Make connection

b)

Transfer Web page files from their creator to the computer

c)

Transmit the information from one place to the other

d)

Download programs

e)

Install applications

63.

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

a)

Server

b)

Domain

c)

Service

d)

Client

e)

Locator

64.

What is a browser

a)

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

b)

Foundation of data communication

c)

Set of rules and guidelines for communicating data

d)

Transmission of information from one place to the other

e)

Largest service acquired amongst the services provided by the Interne

65.

This type of virus can steal information from user`s computers and upload to web sites

a)

Boots

b)

Worms

c)

Resident virus

d)

Polymorphic virus

e)

Multipartite virus

Similar Resources on Wayground

IPA INTENSIVE - SESI 2.2

60 questions

IPA INTENSIVE - SESI 2.2

quiz

Worksheet

•

1st - 5th Grade

Science 4 – Atmosphere Test Study Guide

64 questions

Science 4 – Atmosphere Test Study Guide

quiz

Worksheet

•

1st - 5th Grade

Earth, Rocks and Light

70 questions

Earth, Rocks and Light

quiz

Worksheet

•

1st Grade

Pharmacology (Prelims)

68 questions

Pharmacology (Prelims)

quiz

Worksheet

•

1st - 3rd Grade

ôn tập cuối kì 2 lớp 11

62 questions

ôn tập cuối kì 2 lớp 11

quiz

Worksheet

•

1st Grade

Healthy Foods

60 questions

Healthy Foods

quiz

Worksheet

•

KG - 2nd Grade

Science exam revision quiz

69 questions

Science exam revision quiz

quiz

Worksheet

•

1st Grade

3SCI3 FIRST TEN WEEK TEST 2022 TEACHER -SC

67 questions

3SCI3 FIRST TEN WEEK TEST 2022 TEACHER -SC

quiz

Worksheet

•

1st - 3rd Grade