FINAL QUESTION EXAMPLES

HISTORY AND GENERATIONS

1) T. F. The earliest calculating device was abacus
2) T. F. First memory card was flash memory
3) T. F. Second generation computers used CPU
4) T. F. Ada King Lovelace was first engineer-designer
5) T. F. Charles Babbage was the first to design a fully programmable mechanical computer-
analytical engine

6) What company did Paul Allen and Bill Gates start

a) Apple
b) Windows
c) Minecraft
d) Microsoft
7) A term in computer terminology is a change in technology a computer is/was being used.
a) Development
b) Generation
c) Advancement
d) Growth
8) What company did Steve Jobs & Steve Wozniak start?
a) Apple
b) Windows
c) Minecraft
d) Microsoft

9) Which type of computer is designed for one person to use at a time?

a) Server
b) Personal computer
c) IBM
d) ENIAC

10) Data are _______

a) Row facts
b) İnformation
c) Whisdom
d) Big data

11) The actual physical equipment that makes up the computer system called_________________
a) System software
b) Hardware
c) Operating system
d) Drivers

12) One common input device is ____________

a) Monitor
b) CPU
c) Mouse
d) SSD

13) QWERTY is a type of ___________

a) Mouse
b) Operating system
 c) Monitor
d) Keyboard

14) LCD is a type of _______________

a) Monitor
b) Keyboard
c) CPU
d) Mouse

15) Pixel is ____________________________

a) RGB in printers
b) Binary code in numbering system
c) Smallest unit of digital image
d) All of them

16) Print quality is measured in _____________

a) DPI
b) IPD
c) IDP
d) None of them

17) Main circuit in PC and notebooks that holds and protects all internal devices ___________
a) CPU
b) RAM
c) Motherboard
d) Modem

18) A ___ is a semiconductor device used to amplify or switch electronic signals and electrical power.
a) Resistor
b) Transistor
c) Compiler
d) Driver

19) What is the result signal for given gates in picture

a) NOT
b) NAND
c) NOR
d) XOR

20) Clock speed of CPU is measured in

a) Kb/s
b) GHz
c) Km
d) GB

21) Cache memory and registers are

a) Volatile
b) Unvolatile
c) Portable
d) User friendly

22) The instructions for the POST during the booting process have been stored in ....
a) ROM
b) Flash memory card
 c) DVD
d) All of them

23) Optical storage devices are _____________________________

a) GPS
b) Flash memory card
c) BD, DVD
d) SSD

24) Capacity of Hard Disc in general ____________

a) MHz
b) Kb/s
c) MilliOn
d) GB, TB

25) Computers use 2 basic types of software system:

a) System and application
b) Android and windows
c) Translator and compiler
d) Process and memory

26) IOS, Symbian, Android, Blackberry are examples of ________________

a) Android system
b) Windows system
c) Mobile OS
d) Desktop komputer manufacturers

27) .bmp, .jpg, .jpeg are types of

a) Mobile
b) Document
c) Graphics
d) Audio

28) .mp4, .mov, .avi, .wmv are types of _________ files.

a) Mobile
b) Graphics
c) Video
d) Audio

29) Which program save a file with .pptx extensions? ________

a) Power point
b) Word
c) Excel
d) Publisher

30) Which is the basic element of Power point?

a) Slide
b) Page
c) Sheet
d) Folder

31) Microsoft PowerPoint is an example of_________

a) Web editor
b) Video editing
c) Presentation
 d) Spreadsheet
32) What is the shortcut key of creating a new presentation?
a) ALT+N
b) CTRL+A
c) CTRL+S
d) CTRL+N
33) To join together two or more cells we should use …..
a) Split
b) Bold
c) Center
d) Merge

34) Applying a color background to a cell is called:

a) Painting
b) Coloring
c) Shading
d) Styling

35) İn which view Headers and Footer are visible

a) Normal view
b) Print layout
c) Page layout
d) Draft view
36) The process of removing unwanted part of an image is called..
a) Hiding
b) Cutting
c) Bordering
d) Cropping

37) To apply center alignment to a paragraph we can press

a) Ctrl + S
b) Ctrl + C
c) Ctrl + C + A
d) Ctrl + E
38) The space left between the margin and the start of a paragraph is called
a) Spacing
b) İndentation\
c) Gutter
d) Alignment
39) Text-styling feature of MS word is
a) WordColor
b) WordFont
c) WordFill
d) WordArt
40) We can insert a page number at
a) Header
b) Footer
c) None
d) Both A and B
41) We can remove / hide border of a shape by selecting …
a) No line
b) White line
c) No outline
d) No border
42) Microsoft Word is an example of a/an
a) Operating system
b) Processing device
c) Application software
d) İnput device

43) Your table of contents needs to be changed because you have added more information to the report. Word
lets you automatically update the:
a) Page numbers
b) The hierarchy
c) The sources
d) The footnote
44) Which tab would you choose to change the font size of a word from 12 points to 18 points? ___
a) Insert
b) Home
c) File
d) View

45) Which tab would you choose to change the margins of document? _____
a) Design
b) Layout
c) References
d) View

46) What is the function of line spacing button in Home tab?

a) Adjust space between tabs in the document
b) Adjust space between page margins in the document
c) Adjust space between lines in the document
d) Adjust space between symbols in lines in the document
47) The essential portion or core, of an operating system.
a) CPU
b) Kernel
c) VRAM
d) Driver

48) A memory- management technique that uses hard drive space as additional RAM
a) SRAM
b) VRAM
c) Virtual memory
d) Buffer

LOGİC GATES

49) Write the formula for logic circuit :

50) What gate is this truth table for?

a) And
b) Or
c) Not
d) nor
51) The NOR gate is OR gate followed by ....
a) OR
 b) AND
c) NOT
d) GOT

52) What is the output Y of this logic circuit if A = 1, B = 1, and C = 1

a) 1
b) 0
c) Both of them
d) None of them
53) What is the output Z of this logic circuit if A = 1 and B = 1
a) 1
b) 0
c) Both of them
d) None of them

54) Which of the following logic expressions represents the logic

diagram shown?
a)
b)
c)
d)

NUMBER SYSTEM
55) Convert the following number 1510=?2
a) 11001
b) 1101
c) 1111
d) 0101
56) Convert the following number 5C16 =?8
a) 131
b) 132
c) 133
d) 134
57) Convert the following number 1001002=?10
a) 26
b) 36
c) 46
d) 56
58) Convert the following number 1438 =?10
a) 80
b) 90
c) 89
d) 99
59) Convert the following number 3B16=?10
a) 59
b) 95
c) 17
d) 27
60) Sites that creates a community of individuals who can communicate with and/ or share information
with one another
a) Educational network
b) Social network
c) Medical expert systems
d) Artifitial network
61) Network characteristics are
a) Topology, architecture, size
b) Cables, area, price
c) Routers, modems, cables
d) Wi-fi, hotspot

62) Star, bus, mesh, ring are types of...

a) Topology
b) Size
c) Architecture
d) Price
63) Peer –to-peer and client –server are types of ...
a) Topology
b) Size
c) Architecture
d) Price

64) LAN, PAN, MAN, WAN are types of ....

a) Topology
b) Size
c) Architecture
d) Price

65) Twisted- pair, coaxial, fiberoptic are types of ...

a) Types of wireless network
b) Types of wired network
c) Wi-fi types
d) Providers
66) TCP/IP is ....
a) Protocol
b) Booting file
c) Compiler
d) Driver
67) Ipv6 , Ipv4 are
a) Virtual memory in internet
b) Versions of IP
c) Ethernet cable standard
d) All of them
68) Protocol used to display web pages
a) HTTP and HTTPS
b) Switch
c) Router
d) Modem
69) To join together two or more cells we should use …..
a) Split
b) Bold
c) Center
d) Merge
70) Which tab would you choose to change the font size of a word from 12 points to 18 points? ___
a) Insert
b) Home
c) File
d) View

71) Which tab would you choose to change the margins of document? _____
a) Design
b) Layout
c) References
d) View
72) D5=6, D6=8,D7=9, D8=6. Which function will return the largest value of given numbers in Excel?
a) =COUNT(D5:D8)
b) =IF(D5:D8)
c) =SUM(D5:D8)
d) =MAX(D5:D8)
73) Which string will be shown as a text in given variants
a) =6+3
b) A*3+B*6
c) =A4+C6
d) =D$5*F$9
74) Which formula would you use to capture the first 4 characters of the data string located in B4?
e) =Left(B4,4,4)
f) =Mid(B4,4,4)
g) =Right(B4,4,4)
h) = Left(B4,4)
75) Which function finds the lowest value in a range. __________
a) Min
b) Max
c) Small
d) Large
76) Network that covers a relatively small geographical area, such as a home, official, office building, or
school.
a) LAN
b) MAN
c) PAN
d) WAN
77) Use a central cable to which all network devices connect.
a) BUS topology
b) Mesh topology
c) Star topology
d) Peer-to-peer architecture

78) A _____ contains data that is stored for a short amount of time, typically in the computer's memory
(RAM).
a) Buffer
b) Modulator
c) Trigger
d) Multiplexer

79) One of the most common network standarts used with wireless LAN
a) Qi-Vi
b)Wi-fi
c) Wimax
 d)Wimin

80) What is the intersection of a column and a row on a worksheet called ?

a) Address
b) Column
c) Value
d) Cell

81) Which function in Excel tells how many numeric entries are there ?
a) NUM
b) COUNT
c) SUM
d) SUMIF

82) Which one is not a Function in MS Excel ?

a) SUM
b) MIN
c) MAX
d) AVG

83) Functions in MS Excel must begin with ___

a) ( )
b) *
c) =
d) /

84) In Excel, Columns are labelled as ___

a) A,B,C etc
b) 1,2,3 etc.
c) $1!$2$3$.. etc
d) None of them

85) B7:B9 indicates:

a) Cells B7 and cell B9 only
b) Cells B7 through B9
c) Cell B8 only
d) None of them
86) Absolute address is labeled as:
a) E(9)
b) E-9
c) E$9
d) E9
87) Microsoft Excel is what type of software?
a) Word processing
b) Drawing
c) Spreadsheet
d) Presentation

88) Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of
the correct formula to do this?
a) =A1+A2+A3^4
b) =average(A1,A2,A3)
c) =(A1+A2+A3)/4
d) =sum(A1,A2,A3)
89) If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')
a) Pass
b) Fail
c) 60
d) 68

90) Using the following string of characters, DLM343456B82, which formula will extract 343456? The
data is located in cell B2.
a) =Left(4,6)
b) =Mid(B2,4,6)
c) =Right(B2,4,6)
d) =Mid(B2,3,6)
e) =Mid(6,4)

91) Which formula would you use to capture the first 4 characters of the data string located in B4?
a) =Left(B4,4,4)
b) =Right(B4,4)
c) =Left(B4,4)
d) =Mid(B4,4)

92) Which is the correct way to write this function:

IF B4 is greater than 200, show "High", otherwise, show "Low"
a) IF(B4>200,"High","Low")
b) =IF(B4<200,"High","Low")
c) =IF(B4>200,"High","Low")
d) =IF(B4>200"High","")

93) IF, AND, OR and NOT are all part of which category of functions?
a) Math
b) Text
c) Logical
d) Statistical

94) The following string of characters is entered into cell D4, DLM343456B82. You would like to
extract the last 3 characters and have them display in D5. What formula do you enter in D5?

a) =(right,9,3)
b) =Right(9,3)
c) =Right(D4,9,3)
d) =Right(D4,3)
e) =(right,D4,3)

95) Which of the following is a valid formula?

a) =product(C7>10, “yes”, “no”)
b) =count(A1+A8)
c) =sum(E10)
d) =max(A1:A10)

96) In this IF function example: =IF(G8>40,"Yes","No")

What would show in the cell after you hit enter if the value in G8 was 62?
a) Yes
b) No
c) Nothing would show
 d) Both would show

97) L3 is a type of _...

a) RAM
b) CPU
c) Cache
d) HDD___________
98) The part of CPU that coordinates its operations.
a) Control unit
b) ALU
c) Cache
d) Register

99) A pathway, such as on the motherboard or inside the CPU, along which bits can be transferred
a) Motherboard
b) Bus
c) Ram
d) USB port
100) Print speed is typically measured in _____
a) PPM
b) APP
c) CPU
d) C++