wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

*ИКТ*

Total questions: 100

Worksheet time: 2hrs 40mins

Name
Class
Date
1.

Using drag-and-drop to move text is most useful when both the text and the

destination are on the same:

a)

Section

b)

Screen

c)

View State

d)

Document

e)

Document

2.

Which line spacing is used for research papers and reports using MLA style?

a)

Double- Spaced

b)

1.5-spaced

c)

Triple-spaced

d)

Single-spaced

e)

1-spaced

3.

To position Works Cited entries onto a new page

a)

insert a manual line break.

b)

insert a manual page break.

c)

insert a section break.

d)

press the Enter key

4.

Which of the following would be an unlikely data source for a mail merge?

a)

an Access database

b)

a Word table

c)

an Excel spreadsheet

d)

a PowerPoint presentation

5.

During a mail merge, which of the following statements is true regarding the data

source?

a)

During a mail merge, which of the following statements is true regarding the data

source?

b)

Word saves the source material as a wsm file

c)

Data sources must be based on Excel files.

d)

Each row name becomes afield name

6.

    Column text that is aligned to both the left and right margin is referred to as:

a)

Justified

b)

Justified

c)

Justified

d)

Indented

e)

Dented

7.

In mail merge, the document that contains the text or formatting that remains

constant is that:

a)

Main document

b)

Mailing list

c)

Data source

d)

Home document

e)

Standard document

8.

The computer is:

a)

An electronic machine

b)

   An electric machine         

c)

A racing machine             

d)

An ambulance machine

e)

machine

9.

The first electronic computer is

a)

PC

b)

CPU

c)

ENIAC

d)

ALU

e)

ENUC

10.

Who invented a technology for program storage?

a)

Dr. John von Neumann

b)

Norbert Wiener

c)

Bill Gaits 

d)

Mitch Kapor

e)

Стив Джобс

11.

  When company IBM introduced its first personal computer

a)

In 1930

b)

In 1981

c)

In 1943

d)

In 1971

e)

In 1990

12.

One bit represents a

a)

0 or 1

b)

2 or 3

c)

1 or 2

d)

0 or 2

e)

8 or 7

13.

The components of the computer

a)

RAM, video card, hard disk, table

b)

disk drives, byte

c)

motherboard, CPU, RAM, video card, hard disk, disk drives, and the power supply

d)

mother board, gigahertz

14.

CPU speed is measured in

a)

Gigabyte

b)

Bit

c)

Gigahertz

d)

Terabyte

15.

The software is:

a)

A musical performance

b)

Selected stories

c)

Video performance

d)

A gallery of pictures

e)

Information in the form of data and programs

16.

What is RAM?

a)

Random Access Memory

b)

Read American Memory

c)

Read Apple Memory

d)

Read Advanced Memory

e)

Random Memory

17.

Standard keyboards have

a)

103 or 104

b)

104 or 105 keys

c)

100 or 101

d)

102

18.

Input devices

a)

the keyboard

b)

the RAM

c)

ROM

d)

the monitor

e)

the printer

19.

Output devices

a)

the keyboard

b)

the monitor

c)

the mouse

d)

the ALU

e)

ROM

20.

A CPU will have:

a)

ALU

b)

RAM

c)

ROM

d)

input/output devices

21.

Main memory

a)

It holds the programs and data being used by the processor

b)

It does all the processing and controls the peripherals

c)

It allows data to be entered

d)

It displays the processed data

22.

Output device

a)

It holds the programs and data being used by the processor

b)

It displays the processed data

c)

It does all the processing and controls the peripherals

d)

It allows data to be entered

e)

It provides permanent storage for programs and data

23.

What is Registers

a)

Central Processing Unit

b)

internal memory of the processor

c)

is intended for storage of the invariable (constant) programming and help information

d)

is intended for storage of the invariable (constant) programming and help information

e)

the buffer area in the processor

24.

What is RAM

a)

is intended for operational record, storage and reading of the information

b)

Central Processing Unit

c)

  internal memory of the processor

d)

is intended for storage of the invariable (constant) programming and help information

25.

The CPU is:

a)

The "stomach" of the computer

b)

The "eyes" of the computer

c)

The "stomach" of the computer

d)

The "brain" of the computer

26.

The Mobile Operating Systems

a)

MAC OS

b)

Linux

c)

Os/2

d)

Unix

e)

Bada

27.

The Computer Operating Systems

a)

Os/2

b)

Bada

c)

Palm OS

d)

MeeGo OS

28.

Mobile operating system which is the result of merging two products Maemo (Nokia  and Moblin (Intel)

a)

MeeGo OS

b)

Palm OS

c)

BlackBerry OS

d)

Bada

29.

Which is a mobile operating system that runs on the Linux kernel?

a)

Palm OS

b)

web OS

c)

Mee Go OS

d)

BlackBerry OS

e)

Symbian OS

30.

Which is single-user operating system with a command-line interface?

a)

MS-DOS

b)

PC-DOS

c)

Windows 95

d)

Mac Os

e)

Os/2

31.

The operating system was one of the first graphical operating system for home and office PCs

a)

PC-DOS

b)

MS-DOS

c)

Mac Os

d)

Microsoft Windows

e)

Os/2

32.

The Macintosh operating system has had different names:

a)

PC-DOS

b)

Microsoft Windows

c)

Mac Os

d)

Os/2

33.

Formulas in Excel register in:

a)

line of formulas

b)

status bar

c)

menu bar

d)

title

e)

in the Master of functions

34.

The electronic spreadsheet is:

a)

the application program intended for processing structured in the form of the data sheet

b)

application program for processing of code charts

c)

the device of the personal computer controlling its resources in processing of data in the plate form

d)

the system program controlling resources of the personal computer when processing tables

e)

program of creation of graphic objects

35.

Lines of the electronic spreadsheet:

a)

it is numbered in ascending order

b)

are designated by letters of the Latin alphabet

c)

are designated by letters of the Russian alphabet An I

d)

are named the user arbitrarily

36.

In an electronic cell of H5 the formula = $B$5 * V5. What formula will be received from it when copying in H7 cell:

a)

= $B5*V7

b)

= $B$7 * V7

c)

= $B$5 * $V7

d)

= $B$5 * V7

37.

The range is:

a)

all cells of one line

b)

set of the cells forming squared area in the table

c)

all cells of one column

d)

the cells which are on different work sheets

e)

set of admissible values

38.

How many cells of the electronic spreadsheet in A2:B4 range:

a)

2

b)

8

c)

4

d)

10

e)

6

39.

The chart is:

a)

diagram

b)

beautifully issued table

c)

the form of graphical representation of numerical values which allows to provide numeric data visually

d)

district map

e)

figure

40.

Columns of the electronic spreadsheet:

a)

are designated by letters of the Latin alphabet

b)

it is numbered in ascending order

c)

are designated by letters of the Russian alphabet

d)

it is named the user arbitrarily

e)

it is numbered in decreasing order

41.

Among the given formulas find a formula for the electronic spreadsheet:

a)

A1=A3*B8+12

b)

A3*B8+12

c)

A3*B8+12

d)

A3B8+12

e)

IF = (F2; B4; G3)

42.

In case of relocation or copying in the electronic spreadsheet the relative references:

a)

will be transformed depending on the new provision of a formula

b)

will be transformed regardless of the new provision of a formula

c)

won't change

d)

will be transformed depending on formula length

e)

are deleted from a formula

43.

In an electronic cell of H5 the formula = is written by B5*V5. What formula will be received from it when copying in H7 cell:

a)

= B7*V7

b)

= B5*V5

c)

= $B5* $V

d)

= $B5*V5

44.

How to copy a formula, having saved the link?

a)

to select a cell with a formula and "to drag", "having grabbed" by a marker

b)

to select a cell with a formula and to copy by means of the menu or a toolbar

c)

to select a cell with a formula; to copy and insert by means of the menu or a toolbar

d)

to select a cell with a formula; to make a reference absolute and "to drag", having grabbed by a marker

e)

to copy by means of a clipboard

45.

How to use Avtosumma?

a)

to click on Avtosumma's button, then to specify cell items

b)

specifying on next the composed cells, to click on Avtosumma's button

c)

to select all items of a cell and to press Avtosumma's button

d)

to select all items of a cell and a cell in which there shall be an amount and press Avtosumma's button

e)

to copy by means of a clipboard

46.

How to format display of number?

a)

Menu-Edit: toolbars; setup; parameters

b)

Menu – Format: cell: number

c)

Menu- Edit: toolbars; setup; commands; editing

d)

Menu- Edit: toolbars; formatting

47.

Stages of creation of the chart

a)

to specify data span; to open the Chart wizard; to enter parameters; to click the OK key

b)

to specify data span; to open the Chart wizard; to select a look; to enter parameters; to click the OK key

c)

to specify data span; to open the Chart wizard; to select a look; to enter parameters; to specify the place of an insertion; to click the OK key

d)

to specify data span; to open the Chart wizard; to select a look; kN. Further; to enter parameters; to click the OK key

e)

to specify data span; to open the Chart wizard; to select a look; to click the OK key

48.

How to enter corrections into the chart?

a)

to click in the field of the chart, to correct the necessary element

b)

to double click in the field of the chart, to correct the necessary element

c)

to double click on the necessary element, to correct

d)

to cause the Chart wizard

e)

to begin creation of the chart again

49.

It is impossible to enter into a cell of the electronic spreadsheet Excel:

a)

illustration

b)

formula

c)

text

d)

number

e)

character

50.

Electronic spreadsheets of Excel have by default standard extension:

a)

Cal

b)

Html

c)

Elt

d)

 Xls

e)

Dbf

51.

>     MS Access. Specify field type if field name "quantity of medicines"

a)

numerical

b)

 text

c)

monetary

d)

logical

e)

meme

52.

MS Access. What of the given sequences is sorted in decreasing order?

a)

10/12/98, 02/12/98, 02/11/97,14/10/96

b)

Hole, Tina, Ravine, Stone, Coast...

c)

12,144,245, 53,94

d)

Aster, Carnation, Lily of the valley, Rosa

e)

$10, $25, $5, $33...

53.

   A basic element of MS Access is

a)

 field

b)

form

c)

table

d)

macro

54.

MS Access. What is the report?

a)

The object intended for the presentations.

b)

The object intended for document deletion.

c)

The object intended for the document printing.

d)

The object intended for creation of the document.

e)

The object intended for saving the document.

55.

An object window operation mode "Table" the Microsoft Access in which its prototype is created or changes:

a)

Form.

b)

Structure

c)

Designer.

d)

Print preview.

56.

What of packets allows to work with databases?

a)

MS Access.

b)

MathCAD

c)

Math LaP

d)

Notepad

57.

Excel. Cells which is at the left on the right, above and below from the current cell, is called:

a)

non-adjacent

b)

special

c)

adjacent

d)

normal

58.

How many columns in the electronic spreadsheet Excel?

a)

255

b)

256

c)

289

d)

5

e)

65536

59.

Excel. The absolute cell address is

a)

The designation of a cell made by means of $ and column number and (or)

row numbers.

b)

The designation of a cell made of column number and row number.

c)

The designation of a cell made of number sinks.

d)

The designation of a cell made of column number.

60.

>     How to write C3:B5 block address in a formula that when copying this formula in other cells the block address didn't change:

a)

C3:B5

b)

С$3: É$5

c)

$С$3: $В$5

d)

$С3: $В5

61.

HTML-it

a)

Language of a hypertext marking

b)

The structured language of requests.

c)

Hypertext transfer protocol.

d)

File transfer protocol.

e)

Programming language

62.

Select the correct signing up of a formula in Excel:

a)

= A1:B1C1

b)

= А1/(B1*C1).

c)

А1/(B1C1)

d)

А/(BC1).

e)

B1= А1/(SU)

63.

    The intersection of a row and column, called

a)

Cell

b)

Label

c)

Query

d)

Formula

e)

worksheet

64.

Data is organized in rows and columns, which collectively are called

a)

worksheet

b)

Cell

c)

Label

d)

Query

e)

Formula

65.

Computer-aided design (CAD) software is

a)

the process of arranging text and graphics in a document

b)

assists in creating engineering, architectural, and scientific designs

c)

helps companies record and report their financial transactions

d)

software that includes an appointment calendar to schedule activities

e)

create presentations that communicate ideas, messages, and other information to a group through a slide show

66.

software is used to design and produce sophisticated documents

a)

A personal information manager (PIM)

b)

Multimedia authoring software

c)

Project management software

d)

Desktop publishing (DTP) software

e)

Photo-editing software 

67.

A computer that stores and manages files for multiple users on a network is

a)

Web server

b)

client/server

c)

server

d)

server/client

e)

File server

68.

Local-area network (LAN)

a)

A network that connects two or more local-area networks over a potentially large geographic distance

b)

A network that connects a relatively small number of machines in a relatively close geographical area

c)

The communication infrastructures that have been developed in and around large cities

d)

The communication infrastructures that have been developed in and around small cities

e)

A network that connects two or more local-area networks over a potentially small geographic distance

69.

topologies, have been used to administer LANs

a)

Ring topology, Star topology, Bus topology   

b)

Oval topology, Star topology

c)

Rhomb

d)

Start topology

70.

Bus topology is

a)

A configuration that centers around one node to which all others are connected and through which all messages are sent

b)

A configuration that connects all nodes in a closed loop on which messages travel in one direction

c)

All nodes are connected to a single communication line that carries messages in both directions

d)

One nodes are connected to a single communication line that carries messages in both directions

e)

One nodes are connected to a all communication line that carries messages in both directions

71.

Wide-area network (WAN)is

a)

A network that connects two or more local-area networks over a potentially large geographic distance

b)

A network that connects a relatively small number of machines in a relatively close geographical area

c)

The communication infrastructures that have been developed in and around small cities

d)

The communication infrastructures that have been developed in and around large cities

e)

A network that connects two or more local-area networks over a potentially small geographic distance

72.

Metropolitan-area network (MAN)

a)

A network that connects two or more local-area networks over a potentially large geographic distance

b)

The communication infrastructures that have been developed in and around large cities

c)

A network that connects a relatively small number of machines in a relatively close geographical area

d)

The communication infrastructures that have been developed in and around small cities

e)

A network that connects two or more local-area networks over a potentially smallgeographic distance

73.

popular today are the big public "cloud"

a)

Word, Access

b)

Gmail, Mail

c)

Google, Microsoft and Amazon

d)

Pascal

e)

Processor

74.

Cloud data storage is

a)

a chip of online storage, in which data is stored on multiple

b)

a disc of online storage, in which data is stored on multiple

c)

a model of online storage, in which data is stored on multiple

d)

a data of online storage, in which data is stored on multiple

e)

a program of online storage, in which data is stored on multiple

75.

free cloud data store, which can be added for 5 GB of free space

a)

Google Drive

b)

Yandex. Disk

c)

Drop box

d)

Mega

e)

Sopy.com

76.

What is Multimedia?

a)

a database to the user by electronic or digitally manipulated means

b)

a combination of text, graphic, sound, animation, and video that is delivered interactively to the user by electronic or digitally manipulated means

c)

a combination of text, graphic, sound, animation, and video that is editing

d)

a model of online storage, in which data is stored on multiple

77.

Elements of Multimedia

a)

a data, audio, formula, animation, video

b)

text, graphic, audio, animation, video

c)

a text, graphic, formula, animation, file

d)

a text, graphic, audio, animation, file

78.

is the most basic element of multimedia

a)

audio

b)

graphic

c)

animation

d)

text

e)

video

79.

A Multimedia Project is identified as Linear when

a)

It is interactive

b)

Users have control over the content that is being showed to them

c)

Users are given navigational control

d)

It is not interactive

e)

Example: Games

80.

A Multimedia Project is identified as Non-Linear when:

a)

It is not interactive

b)

It is interactive

c)

User have no control over the content that is being showed to them

d)

A movie

81.

Online Analytical Processing (OLAP) was introduced by

a)

F.F. Mark

b)

D.F. Neumann

c)

E.F. Codd

d)

A.A. Clod

e)

MAC

82.

OLAP data is stored in

a)

ROLAP

b)

MOLAP

c)

a Multidimensional Database (MBD)

d)

FLAP

e)

Database

83.

DATA MINING TECHNIQUESCATEGORIES is

a)

Classification

b)

Definition

c)

Accessible

d)

Consistent Reporting

e)

Client-Server architecture

84.

DATA MINING TECHNIQUESCATEGORIES is

a)

Cluster

b)

Accessible

c)

Consistent Reporting

d)

Client-Server architecture

e)

Definition

85.

DATA MINING TECHNIQUESCATEGORIES is

a)

Multi-user Support

b)

Cross-Dimensional Operations

c)

Association

d)

Cross-Dimensional Operations

e)

Accessible

86.

DATA MINING TECHNIQUES CATEGORIES is

a)

Multi-user Support

b)

Cross-Dimensional Operations

c)

Sequence

d)

Intuitive Data Manipulation

e)

Accessible

87.

Element of Multimedia

a)

text

b)

a data

c)

a file

d)

a formula

88.

Element of Multimedia

a)

a data

b)

graphic

c)

a file

d)

a formula

89.

Element of Multimedia

a)

a data

b)

audio

c)

a file

d)

map

e)

a formula

90.

Element of Multimedia

a)

animation

b)

a data

c)

a file

d)

a formula

91.

Element of Multimedia

a)

a data

b)

a file

c)

video

d)

a formula

92.

topology, use to LANs

a)

Oval topology

b)

Ring topology

c)

Rhomb topology

d)

Row topology

93.

topology, use to LANs

a)

Oval topology

b)

Rhomb topology

c)

Row topology

d)

Star topology

e)

Start topology

94.

topology, use to LANs

a)

Oval topology

b)

Romp topology

c)

Bus topology   

d)

Row topology

e)

Start topology

95.

Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?

a)

Crystal Fill

b)

Texture Fill

c)

formula

d)

Gradient Fill

e)

mark

96.

Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?

a)

Values

b)

Row Labels

c)

Report Filter

d)

Column

97.

    What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?

a)

.xslt

b)

.xltx

c)

.xlsx

d)

.slk

98.

Which among the following settings is the default macro security setting?

a)

Disable all macros except digitally signed macros

b)

Enable all macros

c)

Disable all macros with notification

d)

macros command

e)

select macros

99.

Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?

a)

Excel Calculation Services (ECS)

b)

Excel Web Services (EWS)

c)

Excel Web Access (EW)

d)

Excel Web Reporting

100.

When you double-click on a pivot report value of a PivotTable in Microsoft Excel

2010, Excel creates new ________ with data corresponding to the pivot report valu

a)

Table

b)

Worksheet

c)

Macros

d)

Module

e)

Report

Similar Resources on Wayground

ສອບເສັງກາງພາກ C programming 1CEEE

99 questions

ສອບເສັງກາງພາກ C programming 1CEEE

quiz

Worksheet

•

University

Informatika untuk SMA/MA Kelas XII - Sistem Komputer

100 questions

Informatika untuk SMA/MA Kelas XII - Sistem Komputer

quiz

Worksheet

•

University

Tes LCTK Lanjutan

100 questions

Tes LCTK Lanjutan

quiz

Worksheet

•

10th Grade - University

UAS Manajemen Proyek TI

100 questions

UAS Manajemen Proyek TI

quiz

Worksheet

•

University

AI QUIZ

100 questions

AI QUIZ

quiz

Worksheet

•

University

UJIAN AKHIR SEMESTER DASAR DESAIN GRAFIS

100 questions

UJIAN AKHIR SEMESTER DASAR DESAIN GRAFIS

quiz

Worksheet

•

University

Programming in Java

101 questions

Programming in Java

quiz

Worksheet

•

University

Internet and Mobile Programming Final Review

96 questions

Internet and Mobile Programming Final Review

quiz

Worksheet

•

University