Font size
WorksheetsWorksheet Questions Extraction
Total questions: 118
Worksheet time: 59hrs 0mins
What indicates the speed of a computer?
processor clock speed
type of video memory
type of RAM
hard disk capacity
Determine the correct sequence of the full file name. 1. \E-BOOKS\ 2. C 3. MS Word 2019.docx 4. \ 5. My Documents 6. :
2,6,4,1,5,3
3,6,4,5,1,2
5,6,2,1,4,3
2,6,5,1,3,4
How can an algorithm be implemented on a computer?
With a program
In natural language
With a diagram
With video images
When describing an algorithm using a flowchart, which operation does the following figure represent?
Allocation
Cycle
Condition
Which of the following categories are located in the Control Panel folder? 1. Programs 2. Properties 3. Hardware and Sound 4. Driver 5. Print 6. System and Security
1,3,6
2,3,4
1,5,6
2,4,5
Which operation does this figure illustrate?
Inputting and outputting data
Execution of operations
Determining of data
Ending the operation
What is the purpose of an operation block in a flowchart of an algorithm?
to describe a calculation
to indicate the beginning of the algorithm
to indicate the end of the algorithm
to check a condition
What is represented in the flowchart with the symbol?
Beginning and End
Operating block
Checking the condition
Subroutine
What is depicted in a flowchart by a symbol?
Checking the condition
Operating block
Beginning and End
Subroutine
Which block is used in all algorithms?
Beginning and end block
Subprogram
Condition
Cycle
What operations are performed on files?
Create new, move, merge, rename, delete
Create new, rename, delete, merge, scale
Move, delete, scale, view
Create new, move, view, convert, scale
What command is used to save a document to an external storage device? (MS Word)
Save
Open
New
Close
What is the keyboard shortcut for the Save command? (MS Word)
Ctrl+S
Ctrl+C
Alt+F4
Ctrl+N
What is the Ω symbol for in MS Word?
Adds various symbols to text
Adds formulas to the text
Adds equations to the text
Adds shapes to the text
On which tab is the Print command located? (MS Word)
File
Home
Mailings
View
In which part of the document is the name written in Ms Word?
Title bar
Status bar
Zoom section
Quick access toolbar
How many sheets will be printed based on the given parameters?
6
3
4
5
Mevcut belgeyi yeni bir adla nasıl kaydedersiniz?
Dosya-Farklı Kaydet
Dosya-Kaydet
Pencere-Yeni
Görünüm-Yazdırma Düzeni
What does pressing the ENTER key mean when typing text in MS Word?
The beginning of a paragraph
The beginning of a new column
The space between sentences
The beginning of a new page
Which setting ensures that text is printed on one or two sides?
Print One Sided
Copies
2 Pages Per Sheet
Collated
How to mark grammatical errors in Ms Word?
wavy green underlines
Straight green underlines
Straight red underlines
wavy red underlines
Word 2019'da bir belgenin otomatik olarak kaydedilme süresini nerede ayarlayabiliriz?
Dosya/Ayarlar
Dosya/Son Açılanlar
Görünüm/Makrolar
Ana Sayfa/Panoya
What command is used to change the color of characters in text?
4
1
3
2
Which keyboard keys are used to select all text in Ms Word?
Ctrl+A
Ctrl+X
Ctrl+Y
Ctrl+N
Ms Word'de imlecin solundaki karakteri silmek için hangi klavye tuşuna basmalısınız?
Backspace
Pageup
Del
End
What is the Table of Contents key in MS Word for?
Table of Content
List
Table
List of tables
What key on the keyboard should be pressed to delete the character located to the right of the cursor in MS Word?
Del
Pageup
Backspace
End
In the word "Formatting", the cursor is positioned immediately after the letter "m". Press DELETE 3 times, BACKSPACE 2 times. Show the word you got.
Foing
Foring
Foating
Foaing
Which element is used to print 6 pages of a document on one sheet in MS Word?
File/Print
Home/Print
File/Options
Home/Layout
Which of the following is a spreadsheet editor?
Ms Excel
Ms Power Point
Ms Word
Ms Access
What is the name of a document created in Excel?
workbook
notebook
sheet
page
What is the main structural element of a table called? (MS Excel)
cell
column
row
menu
What symbol is used to write a formula in a cell? (MS Excel)
=
+
/
–
Which of the following is a spreadsheet editor?
Excel, Quattro-Pro, Super Calc
Excel, Paradox, Electron-Table
Clipper, Quattro-Pro, Movie-Maker
Fox Pro, Excel, Super calc
Which of the following is a spreadsheet editor?
Quattro-Pro
Ms Power Point
Ms Word
Ms Access
Which of the following addresses is absolute?
A 3
$$A3
A3
A3$$
What will appear in the cell after you type 9+3 in a cell in Excel and press Enter?
9+3
9
error information will appear
12
Which is a document created in Excel?
temp.xls
book.pps
book1.wav
stat.rtf
Which of the following is a spreadsheet processor?
Super Calc
Fox Base
Oracle
Access
What is the detailed description of the formula =SUM(C3;C5;A1;A3) in Microsoft Excel?
=C3+C5+A1+A3
=C3+C5+A1
=C3+2*A3
=C5+C4+A5
In MS Excel, cell E2 contains 16, cell E5 contains 3, and cell E7 contains 5. What is the value of the formula = 2 *E2 + 8(E7– E5) written in cell E1?
48
36
12
20
What formula will you get when you copy the formula =C 2+ D3 +2 in cell B3 to cell B2?
=C 2+ D2+2
=C 1+ D2+2
=B 2+ D3+2
=B 2+ D2+2
What formula will you get when you copy the formula =C 12+ D13 +2 in cell B13 to cell B12?
=C 12+ D12 + 2
=C$12 + D12 + 2
=C 11+ D12 + 2
=B 12+ D12 + 2
How many columns are included in the range (B2:E8; H2:H11) in MS Excel?
5
6
8
7
In MS Excel, what should be written in the formula bar to write the sum of values in cells B1, B2, B3, B4, B9 to cell B10?
=Sum(B1:B4,B9)
=SumIf(B1:B4,B9)
=Sum(B1:B4)
=Max(B1:B4,B9)
If the formula =$A1*5 written in cell D1 is copied to cell D3, what formula will be executed in this cell?
=$A3*5
=D$1*5
=$C3*5
=$D5*3
Which of the following is not an object of MS Access?
codes
table
macros
module
What class of programs does MS Access belong to?
Application programs
Standard programs
Tool programs
System programs
Which of the following is not available in MS Access?
Model
Form
Report
Survey
What data types are available in Ms Access?
All
Autonumber
Number
Short text
To which structure of the DB does the model shown in the picture belong?
hierarchical
object-oriented
logical
network
The model shown in the figure belongs to which structure of the DB?
network
object-oriented
logical
hierarchical
What is the type of table used to display wages along with their currency?
Currency
Number
Auto Number
Text
What is the name of an object designed to simplify and automate the solution of frequently performed tasks?
Macros
Module
Table
Query
What is the name of the field in the Ms Access database designed to store images and videos?
OLE
Autonumber
Memo
Key
What logical expression should be used to list the people in the table who are younger than 25 and older than 18?
<25 AND >18
>25 OR <18
<25 AND >=18
<=25 AND <18
What logical expression should be used to list the people in the table who are between the ages of 25 and 30?
>25 AND <30
>=25 OR <30
<=25 AND <30
<25 AND >30
How many tuples of teachers are there in the table that satisfy the condition (age >= 25 and Salary < 500)? The table shows four rows: James, age 25, salary 500; Michael, age 23, salary 300; John, age 39, salary 420; David, age 26, salary 600.
1
2
3
4
What topology is shown?
star
ring
hierarchical
mixed
What formula can be used to calculate the value of cell A7 divided by the value of cell B3 in a spreadsheet?
=A7/B3
=A7:B3
=A7|B3
=A7B3
What topology is shown?
ring
hierarchical
If we copy the formula =B4+C5*2-4 in cell A3 of the spreadsheet to cell C7, what formula will be written in cell C7?
=D8+E9*2-4
=B4+C5*2-4
=D8+E9*5-8
=B8+C9*2-4
If we copy the formula =BS4+SC5*2-4 in cell A3 of the spreadsheet to cell C8, what formula will be written in cell C8?
=DS4+SC10*2-4
=D9+SE10*2-4
=BS4+SC5*2-4
=BS9+SE10*2-9
What topology is shown?
hierarchical
ring
star
mixed
What topology is shown?
bus
hierarchical
star
mixed
What should be written in the formula bar in MS Excel to write the sum of the values in cells C2, C3, C4, C5, D7, D8, D9, E12 to cell C6?
=Sum(C2:C5;D7:D9;E12)
=SumIf(C2:C5;D7:D9;E12)
=Average(C2:C5;D7:D9;E12)
=Sum(C2:C5;D7:E12)
How many tuples does the table consist of? The table shows fields Code, Surname, Department, Position with three rows: 010 Ahmadova A.S 017 Engineer; 015 Zeynalova D.R. 003 Editor; 021 Mahmudov R.R. 005 Chief.
3
4
5
15
If this table is sorted in ascending order by the field Quantity, in what order will the data in that field be arranged? The table rows are: 4 Printer Quantity 8; 6 Scanner Quantity 10; 5 Microphone Quantity 16; 1 Monitor Quantity 20; 2 Keyboard Quantity 26; 3 Mouse Quantity 34.
4, 6, 5, 1, 2, 3
3, 2, 1, 5, 6, 4
4, 6, 5, 1, 3, 2
4, 6, 1, 5, 2, 3
If the data in the table below is arranged in ascending order by the Memory field, in what order will the data in the field be arranged? The table rows with Memory are: 3 486 DX, 8; 1 Pentium I, 16; 2 Pentium II, 32; 4 Pentium III, 64.
3, 1, 2, 4
2, 3, 4, 1
1, 2, 3, 4
4, 1, 2, 3
Find the value of cell B13 in Excel. The table shows: A12 = INTERFACE, B12 = POWER POINT, C12 = BOOK; A13 = WORD; B13 contains the formula =LEFT(A12;3).
INT
EYS
3
POW
According to the following table in MS Excel, what is the value of the formula Power(B2;2)+C4-A1?
12
41
34
44
What is the value of the formula =SUM(A1;A3;B1:B3;C1;C3) given in the following table in MS Excel? The table shows A column values 10, 15, 20, 25, 30; B column values 2, 4, 6, 8, 10; C column values 1, 3, 5, 7, 9 for rows 1–5.
48
20
35
12
What is the value of the formula =AVERAGE(B2;C3;A1) given in the following table in MS Excel? The table shows B2 = 45, C3 = 35, and A1 is blank.
40
#VALUE
80
10
When does the #DIV/0 error occur in MS Excel?
Formula is attempting to divide by zero.
Excel doesn't recognize the name of the function you entered.
The number is too large or too small to be displayed in Excel
Column is too narrow to display the output
When does the #NAME? error occur in MS Excel?
Excel doesn't recognize the name of the function you entered.
Formula is attempting to divide by zero.
The number is too large or too small to be displayed in Excel
Column is too narrow to display the output
When does the #NUM? error occur in MS Excel?
The number is too large or too small to be displayed in Excel
Column is too narrow to display the output
When does the #VALUE! error occur in MS Excel?
An unexpected value was entered somewhere in the formula.
Formula is attempting to divide by zero.
Excel doesn't recognize the name of the function you entered.
Column is too narrow to display the output
When does the ##### error occur in MS Excel?
Column is too narrow to display the output
Formula is attempting to divide by zero.
The number is too large or too small to be displayed in Excel
Excel doesn't recognize the name of the function you entered.
When does the #REF! error occur in MS Excel?
A reference was deleted after creating the formula.
Formula is attempting to divide by zero.
The number is too large or too small to be displayed in Excel
Excel doesn't recognize the name of the function you entered.
What are the records in the database that answer the query “(Informatics=10 or English = 10) and Logic=25”?
1,4
1,2,3
4
1,2
What is the MS Access file extension?
accdb
dbs
db1
mdb
What range is the chart based on?
B1:B3
A1:C1
A1:A3
A3:C3
What range is the chart based on?
C2:C4
B2:C2
C2:C3
B2:B4
What range is the chart based on?
D2:D4
C2:C4
E2:E4
C2:D4
What range is the chart based on?
A3:C3
A1:A3
A1:C1
A2:C2
A database table consists of the fields “Employee Code”, “Employee First Name”, “Employee Last Name”, “Position”, and “Salary”. Which of these fields is appropriate to key on?
Employee Code
Employee First Name
Position
Employee last name
Which tables in a database have a one-to-one relationship?
“Countries”, “Capitals”
“Districts”, “Villages”
“Teachers”, “Students”
“Authors”, “Books”
The “Employees” table in the database has the fields “Name”, “Position”, “Age”, and “Salary”. If the table is searched using the query (Age<35 or Salary>900), which list of employees will be displayed?
Those with a salary of more than 900 or under the age of 35
Those with a salary of more than 900 and under the age of 35
Those with a salary of more than 900 and over the age of 35
Those with a salary of more than 900 or over the age of 35
Determine the "IDs" found as a result of the query (Number of books - Number of teachers < 1300) applied to the "School" table in the database.
2,3,4
1,5,6
3,4
1,4,6
How many records match the query “(English = 94 or Informatics>=85) and not(Logic<85)” in the database?
3
0
Define a query to find teachers in the table whose last name starts with A, who are no older than 20, and whose major is Physics.
Major = "Physics" and Last Name LIKE "A%" and Age<=20
Major = "Physics" or Last Name LIKE "A%" and Age<=20
Major = "Physics" and Last Name LIKE "A%" or Age<20
Major = "Physics" and Last Name LIKE "A%" and Age<20
Restore the correct IP address using the four blocks shown.
DCAB
ABCD
DABC
DCBA
Restore the correct IP address using the four blocks shown.
DBCA
ABCD
DABC
DCBA
What is the domain name for the email address khayalazizli232@gmail.com?
gmail.com
Khayalazizli
232@gmail.com
Khayal
What type of database is MS Access compatible with?
relational
network
hierarchical
graph
What is the number of fields in the database given below?
5
3
2
0
If the table data is arranged in ascending order by the "Memory" field, in what order will the data in the field be arranged?
3,1,2,4
1,2,4,3
2,3,4,1
1,3,2,4
Which of the following are field types of data?
text, memo, number, date/time
integer, real, float, double
table, query, form, report
table, row, column, cell
What is the highest level of the OSI model?
application
network
physical
DataLink
How many wires are in UTP (twisted pair)?
4 pairs
2 pairs
8 pairs
1 pair
How many layers does the OSI (International Standard for Information Transfer) model have?
7
5
4
8
What are the types of cables? 1. coaxial 2. fiber optic 3. satellite 4. twisted pair 5. radio channel
1, 2, 4
1, 3, 4
2, 4, 5
2, 3, 5
What is the maximum number of IP addresses?
255
256
32
8
Types of cloud technology: 1. Secret cloud 2. Public cloud 3. Magic Cloud 4. Private cloud 5. Hybrid cloud 6. Community cloud 7. Open cloud
2, 4, 5, 6
1, 2, 3, 4
2, 3, 4, 5
1, 3, 5, 6
Which version of the address of the e-government portal is correct?
www.e-gov.az
www.e-sign.az
www.e-gov-az
www.mincom.az
What is a provider?
An organization that provides Internet services
An organization that registers domain names
An organization that uses Internet services
A network of computers with large memory
Hangi fonksiyon tuşu bir web sayfasını yeniden yüklemek için kullanılır?
F5
F8
F12
F2
In what forms is an e-signature certificate presented? 1. On paper 2. On a USB drive 3. On compact disc drives 4. On a smart card drive 5. On microcard drives
2, 4
1, 3
4, 5
1, 5
What is the domain owned by government organizations?
gov
edu
com
org
Copyright is divided into two types:
civil, non-civil
formal, informal
natural, artificial
moral, economic
What is an electronic signature?
It is a characteristic of information exchange that is consistent with its goals
It is the signing of documents on touch monitors
It is a means of identifying an individual in the electronic world
It is an electronic copy of a signature on paper obtained by a scanner
Two keys are used in the implementation of e-signature:
private and public key
paid and unpaid key
simple and complex key
permanent and temporary key
Which department is responsible for issuing e-signatures?
National Certification Services Center
State Commission for Entrepreneurship
Cabinet of Ministers
Ministry of Taxes
Select the ones that do not exist from the interactions in the electronic government service: 1.G2C 2.G2B 3.G2V 4.G2E 5.G2S 6.G2N 7.G2G
3, 4, 5, 6
1, 2, 7
1, 3, 4, 6
2, 4, 5
What is the capacity of the hard disk shown in the picture?
931 GB
873 GB
391 GB
540 GB
Which of the following is not a part of BIOS?
It starts the application programs
It ensures the initial loading of the operating system
It is the basic input-output system
It stands for Basic Input Output System
What is a processor?
It is a device that performs arithmetic and logical operations and controls the overall operation of the computer
It is an external memory device
It is a device that prints information from the computer's memory
It is a device that transfers information from paper to the computer's memory
What value will the variable A take after the algorithm given in the following flowchart is executed?
0
1
2
3
