Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ИКТ 113-224

Total questions: 90

Worksheet time: 45mins

Name
Class
Date
1.

!MS Excel. When the background formula checker finds a rule that might be in violation,

it places a ____ triangle in the cell

a)

*red

b)

*blue

c)

*grey

d)

*yellow

e)

*green

2.

*!MS Excel. Shortkeys for saving workbook

a)

*SHIFT+F1

b)

*SHIFT+F4

c)

*SHIFT+F9

d)

*SHIFT+F10

e)

*SHIFT+F12

3.

*!MS Excel. The file extension for a Microsoft Excel 2007 workbook

a)

*.xls

b)

*.exe

c)

*.docx

d)

*.book

e)

*.xlsx

4.

!MS Excel. !The absolute link is

a)

*А1

b)

*$A1

c)

*A$1

d)

*$A$1

e)

*$$A$$1

5.

*!MS Excel. The relative link is

a)

*$A1

b)

*$A1$

c)

*А1

d)

*A$1

e)

*$A$1

6.

*!The mixed link is

a)

*А1

b)

*A$1

c)

*$A1

d)

*$$A$$1

e)

*$A$1

7.

*!The size of a worksheet in Excel 2007/2010

a)

*66 536 rows and 512 columns

b)

*65 536 rows and 16 384 columns

c)

*65 536 rows and 256 256 columns

d)

*+1 048 576 rows and 16 384 columns

e)

*1 626 536 rows and 165 484 columns

8.

*!MS Excel. For an illustration of continuous data use the following type of charts

a)

*dot charts

b)

*ring charts

c)

*hystograms

d)

*dot schedules

e)

*circular charts

9.

*!Excel. Binary file format (BIFF12) in Excel

a)

*.xls

b)

*.xltx

c)

*.xlsx

d)

*.xlsm

e)

*.xlsb

10.

*!MS Excel. What kind of data found in a spreadsheet

a)

*Data, words, numbers

b)

*Numbers, data, words

c)

*Words, numbers, labels

d)

*Equations, data, numbers

e)

*Numbers, formulas, labels

11.

*!MS Excel. To merge the cells which tab do you use from the format, cells menu

a)

*Font tab

b)

*Merge tab

c)

*Number tab

d)

*Paragraph tab

e)

*Alignment tab

12.

*!MS Excel. Where a row and a column meet, what do you call that

a)

*A box

b)

*A cell

c)

*A table

d)

*A block

e)

*A range

13.

*!MS Excel. In an excel sheet the active cell is indicated by

a)

*A simple border

b)

*A dotted border

c)

*A blinking border

d)

*A dark blue border

e)

*A dark wide border

14.

*!MS Access. How do you rearrange the date in ascending or descending order

a)

*Data, table

b)

*Data, filter

c)

*Data, form

d)

*Data, sort

e)

*Data, subtotals

15.

*!MS Access. Connected fields can have

a)

*one file, but different type of data

b)

*two files, but different type of data

c)

*different names and different type of data

d)

*identical names, but different type of data

e)

*different names, but identical type of data

16.

*!MS Access. «Create» tab allows to

a)

*execute an auto format

b)

*break the table, query and a report

c)

*create new table, form, report, query, macro and module

d)

*put the new table, templates, the abstract, a request, a slide and the database

e)

*create the page, the form, a template, report, a query, a slide and the database

17.

*!MS Access. Changing the structure of a table

a)

*table mode

b)

*design mode

c)

*mode of table wizard

d)

*creation of a new table

e)

*open the table and change the name of fields

18.

*!MS Access. Special objects for input and viewing of data in the table

a)

*reports

b)

*modules

c)

*forms

d)

*queries

e)

*macros

19.

*!MS Access. For copying the records it’s necessary to select and execute comand

a)

*home - font - copy

b)

*create - reports - copy

c)

*home – data collection - insert

d)

*home - clipboard - copy

e)

*external data - clipboard - cut

20.

*!MS Access. The type of a field is set in

a)

*pages

b)

*tables

c)

*reports

d)

*+design View

e)

*datasheet View

21.

*!MS Access. This object represents formatted printouts of data in a database

a)

*form

b)

*query

c)

*filter

d)

*module

e)

*report

22.

*!Which of the following is not a valid data type in MS Access

a)

*memo

b)

*yes/No

c)

*picture

d)

*currency

e)

*autoNumber

23.

*!MS Access. Records are sorted by increase

a)

*12, 144, 245, 53, 94

b)

*$10, $25, $35, $50

c)

*Lily, Rose, Carnation, Aster

d)

*Folder, Directory, Container

e)

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

24.

*!MS Access. Logical operator «not»is used to select

a)

*coincident files

b)

*coincident queries

c)

*coincident values

d)

*in coincident values

e)

*coincident first symbols

25.

*!MS Access. Logical operator «not Т» is used for select

a)

*words which contain letter «Т»

b)

*words which don’t contain letter «Т»

c)

*words which begin from letter «Т»

d)

*words which do not begin from letter «Т»

e)

*words which end with letter «Т»

26.

*!MS Access. Logical operator «С asterics» is used for select

a)

*words which contain letter «С»

b)

*words which don’t contain letter «С»

c)

*words which begin from letter «С»

d)

*words which don’t begin from letter «С»

e)

*words which end with letter «С»

27.

*!MS Access. Logical operator «[B-C]» is used for select

a)

*words which contain letter «D»

b)

*words which don?t contain letter «В»

c)

*words which begin from letter «В»

d)

*+words which begin from letters «В», «С», «D»

e)

*words which end with letters «В», «С», «D»

28.

*!The appropriate data type to store time in MS Access

a)

*time

b)

*time only

c)

*time/date

d)

*date/time

e)

*time cannot be stored

29.

*!MS Access. Database properties are also known as

a)

*Keywords

b)

*Metadata

c)

*Database objects

d)

*Standard properties

e)

*Database certificates

30.

*!MS Access. A table is represented as a collection of rows and columns called a

a)

*Metadata

b)

*Clientsheet

c)

*Datasheet

d)

*Reportsheet

e)

*Recordsheet

31.

*!MS Access. If your criterion for filtering is that the value in a particular field matches or

does not match a certain value, use

a)

*Autofilter

b)

*Filter by Form

c)

*Common Filter

d)

*Filter by Selection

e)

*Advanced Filter/Sort

32.

*!MS Access. A form typically has ____ sections

a)

1

b)

2

c)

5

d)

4

e)

3

33.

*!MS Access. View which allows you to make changes to the form, but does not show the

actual form

a)

*Form view

b)

*Table view

c)

*Layout view

d)

*Print preview

e)

*Design view

34.

*!MS Access. The arrange tab button called ____ opens the object's property sheet to set its

properties

a)

*Object

b)

*Scroll Tab

c)

*Property Sheet

d)

*Control Margins

e)

*Control Padding

35.

*!MS Access. ____ are the details about a file

a)

*Database views

b)

*Database sheets

c)

*Database objects

d)

*Database certificates

e)

*Database properties

36.

*!MS Access. Database design refers to the arrangement of data into:

a)

*Lists

b)

*Forms

c)

*Reports

d)

*Html and reports

e)

*Tables and fields

37.

*!MS Power Point. The ____ slide transition gently uncovers one slide to reveal the next

a)

*Wipes

b)

*Push and Cover

c)

*Stripes and Bars

d)

*Entities and labels

e)

*Fades and Dissolves

38.

*!MS Power Point. ____ Are defined combinations of formatting options

a)

*Quick Points

b)

*Quick Styles

c)

*Quick Options

d)

*Quick Formats

e)

*Quick Selections

39.

*!MS PowerPoint assumes you want your bulleted list to appear ____ of your slide

a)

*In the center

b)

*On the width

c)

*On the right side

d)

*On the left side

40.

*!MS PowerPoint. The entrance, exit, and emphasis animations are grouped into categories

that do not include

a)

*Basic

b)

*Slight

c)

*Exciting

d)

*Moderate

e)

*Colorful

41.

*!PowerPoint's ____ allows you to advance through the slides with your timing recorded

a)

*Try it feature

b)

*None of these

c)

*Timing feature

d)

*Rehearsal feature

e)

*Presentation feature

42.

*!MS PowerPoint. To select sequential slides, click the first slide, press and hold down the

____ key, and then click the last slide

a)

*TAB

b)

*ALT

c)

*CTRL

d)

*ENTER

e)

*SHIFT

43.

*!MS Power Point. The ____ slide transition uses blinds and checkerboard patterns

a)

*Wipes

b)

*Push and Cover

c)

*Stripes and Bars

d)

*Falls and Appears

e)

*Fades and Dissolves

44.

*!MS Power Point. Clips that reside on a shared network file server are part of ____

a)

*Gallery styles

b)

*My Collections

c)

*Web Collections*Web Collections

d)

*Office Collections

e)

*Shared Collections

45.

*!MS Power Point. Video, music and sound files are examples of ____

a)

*Clip art

b)

*Multimedia

c)

*Presentation

d)

*Transitions

e)

*Animation

46.

*!MS Power Point. The ____, on the scroll bar, indicates the location of the slide in the

document window

a)

*Slide icon

b)

*Status bar

c)

*Slide arrow

d)

*Slide menu

e)

*Scroll box

47.

*!MS Power Point. ____ defines the appearance and shape of the letters, numbers,

punctuation marks, and symbols

a)

*Size

b)

*Font

c)

*Type

d)

*Color

e)

*Style

48.

*!MS Power Point. The ____ shows the number and title of the slide you are about to

display

a)

*Status bar

b)

*Slide menu

c)

*Scroll bar

d)

Slide indicator

49.

*!MS Power Point. ____ allows you to point to a gallery choice and see its effect in the

document

a)

*Ribbon

b)

*Active tab

c)

*Live preview

d)

*Quick Access preview

e)

*Microsoft Office Button

50.

*!MS Power Рoint. A presentation is also called a ____

a)

*File

b)

*Report

c)

*Gallery

d)

*Preview

e)

*Slide show

51.

!MS Power Рoint. !Power Point files formats are

a)

*.bmp and .png

b)

*.xls and .xlsx

c)

*.doc and .docx

d)

*.ppt and .pptx

e)

*.mdb and .accdb

52.

*!MS Power Рoint. Elements of slides design

a)

*animation, transitions

b)

*figures, charts, clips

c)

*slide marking, type of the presentation

d)

*color scheme, background, colors of objects

e)

*control of time, addition of a sound, protection

53.

*!Statistical set

a)

*casual events

b)

*a set of units of the studied phenomenon

c)

*a set of the studied diverse objects

d)

*group of the fixed casual events

e)

*group of the fixed diverse objects

54.

*!Statistical observation

a)

*organization of information registration

b)

*work on collecting mass primary data

c)

*scientific organization of information registration

d)

*extensive program of statistical researches

e)

*an assessment and registration of signs of the studied set

55.

*!Statistical indicator

a)

*quantity of units of the studied object

b)

*quantity of units of the studied phenomenon

c)

*result of properties measurement of the studied object

d)

*the size of the studied phenomenon in physical units of measurement

e)

*the result of the studied phenomenon in physical units of measurement

56.

*!The values of a sign repeating with the largest frequency

a)

*mode

b)

*median

c)

*regression

d)

*variance

e)

*correlation

57.

*!Indicator of a variance

a)

*a deviation from an average

b)

*average square of deviations

c)

*deviation of an average square

d)

*square of an average deviation

e)

*a deviation from average of a population

58.

*!The meaning of correlation in statistics

a)

*relation

b)

*function

c)

*equation

d)

*comparison

e)

*ratio

59.

*!What is the fundamental issue of the person – computer interaction?

a)

*increase in reliability of the computer

b)

*the person becomes dependent on the computer

c)

*the computer becomes the opponent of mankind

d)

*the person becomes unadapted to new rate of development of a civilization

e)

*negative impact of the latest information means and technologies on human health

60.

*!Person – computer interaction. Ergonomic design of systems is:

a)

*Process of architecture determination of the COMPUTER.

b)

*Process of definition of the COMPUTERS components.

c)

*Landscape design with the accounting of a human factor.

d)

*Design of systems on the basis of the COMPUTER with the accounting of a human

factor.

e)

*Process of interfaces determination of system with the accounting of a human factor.

61.

*!Person – computer interaction. Between what tags is placed an office information?

a)

<hl>and</hl>

b)

<pre>and</pre>

c)

<html>and</html>

d)

<head>and</head>

62.

*!Person – computer interaction. The color image with a palette from 8 flowers has the size

of 100х200 points. What information volume does have the image?

a)

*7500 bytes

b)

*17500 bytes

c)

*6000 bits

d)

*60050 bits

e)

*160000 bits

63.

*!Person – computer interaction. How many colors are there in a palette if the color image

has the size of 20х30 points, and information volume is equal to 150 bytes?

a)

*2 colors

b)

*3 colors

c)

*4 colors

d)

*5 colors

e)

*6 colors

64.

*!Depending on the habitat computer viruses are divided as:

a)

*resident, non-resident

b)

*harmless, dangerous, very dangerous

c)

*detectors, doctors, auditors, filters, vaccines

d)

*network, file, loading, file and loading

e)

*parasitic, replicators, invisible beings, mutants, trojan

65.

*!On a way of infection computer viruses are divided as:

a)

*resident, non-resident

b)

*harmless, dangerous, very dangerous

c)

*detectors, doctors, auditors, filters, vaccines

d)

*network, file, loading, file and loading

e)

*parasitic, replicators, invisible beings, mutants, trojan

66.

*!MS Windows. File characteristics

a)

*changing, moving and deleting the file

b)

*date of moving of the file, creation date and time

c)

*copying, moving, deleting file and attributes

d)

*file name, creation date and time, file size and attributes

e)

*renaming, moving, deleting file and time of creation

67.

*!MS Windows. 3rd level catalog

a)

*C:\Pharmacy

b)

*Dentistry

c)

*C:\Faculty\Course\Group

d)

*F:\Faculty\/-Course-Group

e)

*A:/General medicine-Dentistry

68.

*!MS Windows. Setting of date and time

a)

*desktop - control panel - settings

b)

*control panel - settings - date and time

c)

*my computer - control panel - settings - time

d)

*start - control panel - settings - date and time

e)

*start - settings - control panel - date and time

69.

*!MS Windows. Command of creating a new file in Windows Explorer

a)

*file - create - folder

b)

*file - create - shortcut

c)

*view - create - choose of the created file type

d)

*file - create - choose of the created file type

e)

*edit - create - choose of the created file type

70.

*!MS Windows. Disk defragmentation

a)

*start - all programs - disk defragmentation

b)

*my computer – system tools - disk defragmentation

c)

*desktop - all programs - disk defragmentation

d)

*start - all programs - accessories - system tools - disk defragmentation

e)

*start - accessories - all programs - system tools - disk defragmentation

71.

*!MS Windows. Settings of a language

a)

*my computer -  settings - languages

b)

*desktop - settings

c)

*start - settings - control panel - language and regional standards - languages

d)

*start - control panel - help - language and regional standards - languages

e)

*my documents - language and regional standards - languages

72.

*!MS Word. Ways of changing of page numbers

a)

*insert – page number - delete

b)

*insert – page number – change the number of the page

c)

*click on the page number with the main button of the mouse

d)

*double click on the page number with the left button of the mouse

73.

*!MS Word. Combination of several selected graphical objects

a)

*sending - group

b)

*menu - drawing- group

c)

*insert - shapes - group

d)

*context menu - grouping - group

74.

*!MS Word. Transition to a new line

a)

*press on Tab key

b)

*press on CapsLock key

c)

*carries out automatically

d)

*press Space Bar and continue to enter the text

75.

*!MS Word. To create a new paragraph when entering a text

a)

*press on Insert key

b)

*press on Enter key

c)

*go to a new line and press on Esc

76.

*!MS Word. How to automatically go to the next page

a)

*press on Break key

b)

*choose command insert- rupture

c)

press on short keys Ctrl + Enter

d)

click on the pictogram «unprinted symbols»

e)

enter the text until courser won’t be transited to the next line

77.

*!MS Word. Changing of numbered list into marked one

a)

*choose styles command - plain

b)

*delete the list and type a new marked list 

c)

*cut the list, choose command font - markers

d)

*insert the list, choose command paragraph  - list

e)

*select the text, choose command paragraph - markers

78.

*!MS Excel. Error in formula «СУММ(С7:С10)»

a)

*the wrong cell range is set

b)

*insufficient quantity of arguments

c)

*the function name isn't correctly written

d)

*absence of a sign "=" at the beginning of a formula

e)

*here should be one more bracket near the SUM function

79.

*!MS Excel. Appearance of  symbols " " means

a)

*the cell is protected

b)

*there is an error in a formula

c)

*there is an error in a formula

d)

*the number is large and also is not completely displayed

e)

*content of a cell is hidden and isn't displayed

80.

*!MS Excel. In А2 cell is written 10%. The formula of calculating this percent from the number which is written in B2 cell

a)

*=B2 multiply A2

b)

*=B2 multiply 0.10

c)

*=B2/100 multiply 10

d)

*=B2 multiply A2 multiply 0.1

e)

*=B2 multiply А2 multiply 10%

81.

*!MS Excel. In А1 cell is written number 5, and in В1 cell is written the formula =А1 multiply 2, in С1 cell is written =А1 В1.  The result of calculating the С1 cell:

a)

5

b)

10

c)

15

d)

20

e)

25

82.

*!MS Excel.  The range of cells В2:В10 contain numbers44, 64, 52, 37, 82, 52, 32, 93, 48.  Show result of MEDIAN(В2:В10)

a)

9

b)

32

c)

93

d)

56

e)

52

83.

*!MS Excel. The range of cells В2:В10 contain numbers44, 64, 52, 37, 82, 52, 32, 93, 48.  Show result of  MODE(В2:В10)

a)

52

b)

56

c)

58

d)

82

e)

8

84.

*!MS Excel. The range of cells В2:В10 contain numbers 44, 64, 52, 37, 82, 52, 32, 93, 48.  Show result of COUNT(В2:В10)

a)

9

b)

32

c)

56

d)

52

e)

93

85.

*!MS Excel. The range of cells В2:В10 contain numbers 44, 64, 52, 37, 82, 52, 32, 93, 48. Show result of COUNTIF(В2:В10;"<48")

a)

1

b)

2

c)

3

d)

5

e)

9

86.

*!MS Excel. The range of cells В2:В10 contain numbers 44, 64, 52, 37, 82, 52, 32, 93, 48.  Show result of MAX(В2:В10)

a)

9

b)

32

c)

52

d)

56

e)

93

87.

*!MS Excel. Number of cells in the following formula:  =SUM(А1;С3)   

a)

6

b)

3

c)

4

d)

5

e)

2

88.

*!MS Excel. Number of cells in highlited groupА2:С4

a)

2

b)

4

c)

6

d)

8

e)

9

89.

*!MS Excel. Samples belong to two different populations if

a)

*p<1,00

b)

*p<0,08

c)

*p<0,10

d)

*p<0,50

e)

*p<0,05

90.

*!MS Excel. Samples belong to the same population

a)

*p<1,00

b)

*p<0,08

c)

*p<0,10

d)

p>0,05

Similar Resources on Wayground

HPC 1 - KITCHEN ESSENTIALS FINAL EXAMINATION

91 questions

HPC 1 - KITCHEN ESSENTIALS FINAL EXAMINATION

quiz

Worksheet

•

University

SPORTS

90 questions

SPORTS

quiz

Worksheet

•

University

Mandarin level 1 chapter 1- 4

89 questions

Mandarin level 1 chapter 1- 4

quiz

Worksheet

•

KG - University

Final Exam Review SOC 1301 - Chapters 1 through 16

90 questions

Final Exam Review SOC 1301 - Chapters 1 through 16

quiz

Worksheet

•

University

Tentang Perang

92 questions

Tentang Perang

quiz

Worksheet

•

7th Grade - University

materi 6 Persiapan (Nurul)

90 questions

materi 6 Persiapan (Nurul)

quiz

Worksheet

•

University

Kuis Bahasa Indonesia Okt Nov XII

90 questions

Kuis Bahasa Indonesia Okt Nov XII

quiz

Worksheet

•

12th Grade - University

Library Quiz Game!

92 questions

Library Quiz Game!

quiz

Worksheet

•

University