Which is correct Excel cells range notation

a. A1:K20

b. A1=K20

c. A1-K20

d. A1/K20

e. A1,K20

27 At the logical stage of database creation you need to ...

a. group data logically

b. collect logically unrelated data

c. group data logically and set relationships between data groups

d. release data in software

e. collect logically related data

28 Computer virus is in fact ...

a. software

b. bacteria

c. hardware

d. spam

e. worm

29 Data in the relational database is stored in ...

a. tables

b. sheets

c. forms

d. reports

e. slides

Point memory devises to proper Memory types

Flash card	Ответ 1
Google Drive	Ответ 2
Read Only Memory - ROM	Ответ 3
Random Access Memory - RAM	Ответ 4

 

 

1. Find an operations support system

a. BBS

b. OSS +

c. MEC

d. ETSI

 

2. What CLV stands for ?

a. creative low value

b. communicating life value

c. customers low value

d. customer lifetime value +

 

3. ... - are a way of representing rules in a hierarchical, sequential structure, where each object corresponds to a single node that provides a solution.

a. Decision trees +

b. Data Description

c. Classification

d. Regression

 

4. Example of touristic online platform realised in Web 2.0:

a. Booking

b. Aviasales

c. TripAdvisor+

d. Anex tour

 

5. What is one of the fastest growing areas of computing ?

a. Data Analytics Quality Data

b. Data Analytics Database Management

c. Data Analytics Big Data +

d.Data Analytics Master Data Management

 

6. Define an European data center location of choice for world leaders :

а. USA

b. Ireland+

c. Australia

d. Canada

 

7. What doesn’t data sources include?

a. Subscription data

b. Presence and location data

c. Behavior data

d. Definition data +

 

8.What is the main difference between static and dynamic data?

a. There is no difference

b. Static data is for location of a core features or a router , dynamic is for generating data in social media +

c. Static data is for social media development. Dynamic is for generating operating system

d. Static and dynamic are different by their functions in the computer

e. Static is for operating social media data, dynamic is for core features of computer.

 

9. What do Mind Commerce analytic reports cover in cloud configurations and business models?

a. MEC (Mobile Edge Computing) +

b. ETSI (European Telecommunications Standards Institute)

c. loT (Internet of Things)

d. DaaS (The Data as a Service)

 

10...........- it’s a process of research, filtration, data transformation and modeling in order to extract useful information and decision making.

a. Data management

b. Data mining

c. Data as a service

d. Data analysis +

 

11.Term that has been coined to refer to analysis of the data from IoT networks, systems and devices?

a. IBM

b. AoT +

c. DaaS

d. IoT

 

12.Data Mining – what is it

a. it is a decision support process that based on searching for hidden patterns in the data information.+

b. construction algorithm binary decision tree.

c. this is an algorithm for building a decision tree in which the number of there is no limit to the node's descendants.

e. this is a way to represent rules in a hierarchical, consistent structure

 

13.What services are used to increase productivity and standards in the business environment and with other service providers?

a. Data security and data service

b. Data processing and data conversion +

c. Daas

d. IBM

 

14.Social data includes tapping user profiles:

a. Google +

b. hard disk

c. keyboard

d. monitor

 

15.The structure of which includes Corporate Data Management: business analytics, analytics and data discovery?

a. A representative sample of Mind Commerce data analytics reports +

b. IoT

c. ETSI

d. Daas

 

16.A system of interconnected computing devices, mechanical and digital machines equipped with unique identifiers (UIDs) and the ability to transmit data over a network?

a. IOT+

b. AOT

c. LBS

d. SDM

 

17.What is data analytics?

a. it’s analyzing the historical behavior of groups of entities with similar characteristics

b. finding groups of entities with similar characteristics

c. it’s the science of examining raw data with purpose of drawing conclusions about that information +

d. it’s presenting results obtained through one or more of the other models

 

 

18.Term that has been coined by Cisco to refer a decentralized computing network in which a portion of computational infrastructure is dispersed to the edge of networks?

a. DaaS

b. loT

c. fog computing +

d. MEC

 

19.... sees carriers focusing primarily on network data (initially) as there are already systems in place, such as Self-Organizing Networks (SON), to derive data for analytics.

a. internet

b. Mind Commerce +

c. microsoft office

d. windows

 

20.Administrative process that includes acquiring, validating, storing, protecting, and processing required data to ensure the accessibility, reliability, and timeliness of the data for its users.

а. Data analytics

b. Data discovery

c. Manufacturing

d. Data Management+

 

 

21.In what generation did microprocessors appear?

a.In the first

b.in the second

c.in third

d.in the fourth +

 

22.What DaaS stands for?

a. Data mode

b. Data architecture

c. Data AnalyticS

d. Data as service +

23.The data can be…

a. structured and unstructured+                

b. Complete and incomplete                        

c. Associated with internet                              

d. Simple and complicated

 

24.What year is MEC planned and real-time data in smart cities, buildings and homes?

a.2015-2020

b. 2016-2022

c. 2017-2022+

d. 2018-2022

 

25.Most implementations have data that is easily accessible about the network and are called?

а. fast data transfer solutions+

b. Slow transmission

c. Quic logic

d. Fast network

1. ____________ controls the way in which the computer system functions and provides a means by which users can interact with the computer. 

·    The operating system

2. Word processing, spreadsheet, and photo-editing are examples of: 

·   application software.

3. Servers are computers that provide resources to other computers connected to a: 

·   network

4. ____________ is data that has been organized or presented in a meaningful way. 

·   Information

5. All of the following are examples of real security and privacy risks EXCEPT: 

6.

·   Spam

7. The set of instructions that tells the computer what to do is 

·   Software

8. Personal computers can be connected together to form a 

·   network

9. The steps and tasks needed to process data, such as responses to questions or clicking an icon, are called: 

·   instructions

10. The operating system is the most common type of ____________ software. 

·   system

11. The ability to recover and read deleted or damaged files from a criminals computer is an example of a law enforcement specialty called: 

·   computer forensics.

12. Computer software includes 

·   All of these

13. The Operating System Manages 

· All of the above

14. Allocation of a resources in a time dependent manner to several program simultaneously called 

· time sharing

15. Data that are accumulated and processed in group called 

· Batch Processing

16. Multiprocessing supports more then one_____ at the same time 

· Process

17. Which of the following are true about firewalls? 

· All the above

18. The process of transferring files from a computer on the Internet to your computer is called 

· Downloading

19. A person who uses his expertise to gain access to other people's computers to get information illegally or to cause damage is a 

· Hacker

20. What is the commonly used unit for measuring the sped of data transmission? 

·   Bits per second

21. 'Blue tooth' technology allows 

· Wireless communication between equipments

22. All of the following statements concerning windows are true EXCEPT: 

· windows are an example of a command-driven environment.

23. Verification of a login name and password is known as: 

· authentication

24. ____________ is the ability of an operating system to control the activities of multiple programs at the same time. 

· Multitasking

25. The operating system does all of the following EXCEPT: 

· enable users to perform a specific task such as document editing.

26. In MS-Access press CTRL+O to

· Open an existing database

27. Which symbol must all formula begin with in MS Access query:

· :

28. Functional Dependencies are the types of constraints that are based on______

· Key

29. Which forms are based on the concept of functional dependency:

· 3NF

30. Empdt1(empcode, name, street, city, state,pincode).For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in

· 2 NF and hence also in 1 NF

31. A ________ in a table represents a relationship among a set of values.

· Row

32. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

· Domain

33. The time required to complete a single, continuous execution of an object program is called

· Run time

34. Anonymous FTP is the

· Both (a) & (b)

35. Following is not the form of secondary storage

· Scanner

36. The overall design, construction, organization and interconnecting of the various components of a computer system is referred as

· Computer Architecture

37. In the IBM PC's, the CPU, the device drives, memory, expansion slots and active components are mounted on a single board referred as

· Motherboard

38. An association of several structure of a data base can be expressed graphically by?

· Relationship

39. The overall logical structure of data base can be expressed graphically by?

· Entity relationship diagram

40. The overall design of a database is called?

· Scheme of the database

41. The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

· entity integrity rule

42. The process by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is _________

· Normalization

43. Referential integrity controls relationships between:

· tables in a database

44. What rows will this select statement return? SELECT * FROM products WHERE ordernumber > = 1000

· All rows in the products table whose order number is greater than or equal to 1000

45. The code that relational database management systems use to perform their database task is referred to as ...

· SQL

46. How is it possible that both programs and data can be stored on the same floppy disk?

· Programs and data are both software, and both can be stored on any memory device

47. Related fields in a database are grouped to form?

· Data Record

48. The raw facts and figures are:

· Data

49. ................. requires that data should be made available to only authorized users.

· Security

50. What is Hypertext Transfer Protocol (HTTP)?

· The transfer protocol to transfer Web pages to a browse

51. Where does a computer add and compare data?

· CPU chip

52. Which generation of computers is converted by the period 1964-1977

· Third

53. The word "Computer" usually refers to the Central processing unit plus?

· Internal memory

54. Which of the following belongs to the first generation of computer?

· UNIVAC

55. What hardware was used by first generation computer?

· Vacuum lamps

56. A typical modern computer uses?

· SLIC chips

57. Which device can produce the final product of machine processing into a form usable by humans?

· Output devices

58. Which can read data convert them to a form that computer can use?

· Input device

59. Which is not true for primary storage?

· I is part of processor

60. A person who used his or expertise to gain access to other peoples computers to get information illegally or do damage is

· Hacker

61. High level language is also called-

· All of the above

62. Which language is directly understood by the computer without translation program?

· Machine language

63. Which transmission media is fastest?

· fiber optics

64. Process is:

· a program in execution

65. The most frequently used instructions of a computer program are likely to be fetched from:

· cache memory

66. UNIVAC is

· Universal Automatic Computer

67. A storage area used to store data to a compensate for the difference in speed at which the different units can handle data is

· Buffer

68. Which of the following is not valid version of MS Office

· Office Vista

69. The pattern of printed lines on most products are called-

70.

· barcodes

71. Which of the following is not an example of hardware?

· Interpreter

72. ---------- is the process of carrying out commands.

· Executing

73. AN EDUCATIONAL INSTITUTION WOULD GENERALLY HAVE THE FOLLOWING IN ITS DOMAIN NAME--

· .edu

74. Which of the following is not a term pertaining to the Internet?

· keyboard

75. WHICH OF THE FOLLOWING IS THE PRIMARY OUTPUT DEVICE OF COMPUTERS?

· VIDEO MONITER

76. Something which has easily understandable instruction is said to be-------

· user-friendly

77. ------ are distinct items that don't have much meaning to you in a given context?

· data

78. A proxy server is used for which of the following?

· to provide security against unauthorized access

79. A directory within a directory is called a---

· Sub-Directory

80. The capability of a computer to perform more thane one task at the same time is called----

· multitasking

81. Which of the followng is an example of optical disk?

· Blue-ray disk

82. Handheld computers come under which category of computer?

· MIni computer

83. A transaction file is a type of---

· data file

84. A function inside another function is termed as

· nested function

85. The main circuit board of the system unit (tower) is the---

· mother board

86. --------- is the first available high-level language developed by IBM in 1957.

· FORTRAN

87. ----- is a set of computer programs used in a computer to help perform tasks.

· software

88. The kind of the memory that comes from the CPU that is erased when you shut the computer off or exit the program that you were in.

· RAM

89. Hard Disk is a kind of -----

· Magnetic Disk

90. The list of coded in computer language instructions is called

· Computer program

91. Which output device is used for translating information from a computer into pictorial form on paper?

92.

· Plotter

93. Any storage device added to a computer beyond the immediately usable main storage is known as

· Backing store

94. Which of the following can be output by a computer?

· All of the above

95. Who is called the "grand father" of the computer?

· Charles Babbage

96. Which language is artificial intelligence language?

· LISP

97. Which company is the first and biggest player in the microprocessor industry

· Intel

98. The OR, XOR & AND functions can be performed by _____ of the computer in a CPU.

· ALU

99. Primary storage is _____ as compared to secondary storage.

· Fast and expensive

100. Periferal device is

· a device which is not connected to CPU

101. What is the term which represents the use of links between information of all sorts whether text, graphics, video oi audio-based?

· Hypermedia

102. A sizeable geographical area with communication based on the telephone system is though as

· Wide area network

103. One nibble is equal to

· 4 bits

104. Which of the following is not valid version of MS office?

· office vista

105. Personal computers use a no. of chips mounted on a main circuit board. what is the common name for such boards?

· motherboard

106. Programs designed to perform specific tasks is known as

· application software

107. A program that converts computer data into some code system other than the normal one is known as?

· Encoder

108. Which of the following is used for manufacturing chips?

· Semiconductor

109. You can create hyperlinks from the Excel workbook to

· All of the above

110. The advantage of using a spreadsheet is

· All of the abov

111. There are types of data found in a spreadsheet:

· Numbers, formulas, text, references, graphs

112. How do you rearrange the date in ascending or descending order?

· Data, sort

113. Which of these toolbars allows changing of Fonts and their sizes?

· Formatting

114. What is the function of Ctrl + B in Ms-Word?

· It makes selected text bold

115. In MS-Word shortcut SHIFT+DELETE is used to

· Delete the selected item permanently without placing the item in the Recycle Bin

116. In MS Word to move the insertion point to the beginning of the next word command used is

· CTRL+RIGHTARROW

117. A bookmark is an item or location in document that you identify a name for future Reference.Which of the following task is accomplished by using bookmarks?

· To quickly jump to a specific location in the document

118. How can you insert a sound file in your word document?

· From insert -> object menu option

119. Thesaurus tool in MS Word is used for...

· Spelling suggestions

120. What feature helps you to inserts the contents of the Clipboard as value without any formula and formatting in MS Excel?

· Paste Special

121. What is place to the left of horizontal scroll bar?

1. View buttons

122. What is gutter margin?

· Margin that is added to the binding side of page when printing

123. If you need to change the typeface of a document, which menu will you choose?

· Format

124. To autofit the width of column

· Double click the right border of column

125. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that?

· Click on Page Number Format tool and specify required setting

126. If you need to double underline a word, how will you do that?

· Select the text then choose Format >> Font and on Font tab open Underline Style and choose Double Underline

127. Which of the following line spacing is invalid?

· Triple

128. How can you apply exactly the same formatting you did to another text?

2. Select the text then click on Format Painter and select the new text

129. What should you do if you require pasting the same format in many places?

· Double click the format painter then go on pasting in many places

130. Which of the following is used to create newspaper style columns?

· Format Columns

131. To open Columns dialog box quickly…

· double click the space between area on ruler

132. MS Office provides help in many ways, which of these is one of them?

· All of the above

133. You wished to justify text over the height of paper, which option will you choose...

· Page Setup from File menu

134. There can be many ways to insert page number in a document. Which of the following lets you insert page number

· Page number from Insert menu

135. Which of the following is not the part of standard office suite?

· File manager

136. Tags and text that are not directly displayed on the page are written in _____ section.

· <title>

137. How can you make an e-mail link?

· <a href="mailto:xxx@yyy">

138. In HTML document the tags

· can be written in both uppercase or lowercase

139. Which of the following HTML code is valid?

· <font color="red">

140. Which of the following is an attribute related to font tag?

· All of above are style tags

141. What is a search engine?

· a web site that searches anything

142. "Yahoo", "Infoseek" and "Rambler" are _________?

· Search Engines

143. <TITLE> … </TITLE> tag must be within ________

· Header

144. Which of the following is used to explore the Internet?

· Browser

145. How do you select an entire column?

· Click the column heading letter

146. In a worksheet you can select

· All of the above

147. You can copy data or formulas

· All of the above

148. Which of the following is a valid data type in excel?

· all

149. Right clicking something in Excel:

· Opens a shortcut menu listing everything you can do to the object

150. Which of the following is not an example of a numeric value?

· Serial Number 50771

151. A worksheet range is a

· A group of cells

152. Getting data from a different cell is called …

· Referencing

153. Excel uniquely identifies cells within a worksheet with a cell name

· Column letters and row numbers

154. What is coded in bitmap graphics?

· color

155. What is coded in vector graphics?

· shape

156. What is not a bitmap graphics feature?

· easy file size

157. Selects specific paragraph

· Click before first letter-hold SHIFT - click last letter

158. In MS Word, Which of these toolbars allows changing of Fonts and their sizes?

· Formatting

159. Why are headers and footers used in document?

· To allow page headers and footers to appear on document when it is printed

160. How to set bulleted list for the ordinary list

· Both A and C

161.  Thesaurus tool in MS Word is used for...

· Synonyms and Antonyms words

162. Using Find command in Word, we can search?

· All of the above

163. The ability to combine name and addresses with a standard document is called ______

· mail merge

164. Which of the following commands should you always use before submitting a document to others

· Spelling and Grammar

165. If the cell B1 contains the formula = $A$1, which of the following statements is true

· There is an absolute reference to cell A1

166. PowerPoint is best described asˇ

· Presentation Software

167. You can insert the following on a slide

· All of the above

168. How can you stop a slide show?

· Press Escape

169. The arrangement of elements such as Title and subtitle text, pictures, tables etc. is called:

· Layout

170. Is it possible to add sound or video clips to your presentation?

· Yes

171. Once you've deleted text, you can't get it back.

· False

172. What would you see while spell checking the phrase "My father was write"?

· A blue squiggly underline under the word "write"

173. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?

· Yes

174. A Formula and a function are the same thing.

· No

175. How do you know a range is active?

· It is highlighted on the screen.

176. What does COUNTA () (СчетЗ) function do?

· D. counts non-empty cells

177. To insert slide numbers in presentation

178.

· Insert a new textbox and select Insert >> slide Number

179. When sharing documents there are two options, depending on how much access you would like others to have. These are …..

· Viewers or collaborators

180. Google docs are

· Only accessible to others that you explicitly share them with

181. Borders can be applied to

· All of above

182. Which is the best slide layout for displaying blocks of text?

· Title and Body

183. Google Docs allows you to create the following documents:

· Documents

184. Which of the following objects can you add to a Google Presentation slide?

· All of the above

185. A predesigned collection of background images, color schemes, and fonts

· Theme

186. Some things you can do with Google presentations include

· All of the above

187. Which of the following is not a part of Slide Design?

· Slide Numbering

188. To add a chart to your presentation, do which the following?

· Insert an object as an image from Google Spreadsheets

189. A symbol such as a heavy dot or other character that precedes text in a presentation is called a(an) ____.

· Bullet

190. Which of the following method can insert a new slide in current presentation?

· All of above

191. These are design templates that can be applied to an entire presentation that allows for consistency throughout the presentation.

· Themes

192. Where are Google presentations files stored?

· On Google Drive

193. Which of the following is not a category of transition?

· Emphasis

194. What is the text that appears on every slide but depending on the theme applied may not always appear at the bottom of a slide?

· Footer

195. Which of the following option is not available in Insert tab?

· Footnote

196. Which of the following is true regarding page Orientation of a Document?

· Page Orientation can be change at any time

197. To start a slide show using the keyboard, press ____.

· F5

198. In a PowerPoint presentation

· Both can be inserted

199. What is meant by Slide Transitions?

· They are animation-like effects that occur in the Slide Show View when the user moves from one slide to the next

200. The effect applied to display when slides changes in slide show view is

· Slide Transition

201. These are effects that are in place when you switch from one slide to the next.

· Transitions

202. Which menu do you choose to shade words and paragraph?

· format, borders and shading

203. You need to insert an image of only part of a web page that is currently open in your browser. You would use:

· Insert, Screenshot

204. In MS-Word, for what does ruler help?

· All of the above

205. To create a new presentation based on pre-selected fonts, colors, and graphics use a _____.

· Template

206. What is the best way to create another copy of a slide?

· From Insert Menu choose Duplicate Slide

207. Which of the following font effect is not available in PowerPoint Font dialog box?

· Shadow

208. Which of the following options is not included under the File tab in Microsoft PowerPoint 2010?

· Page Layout

209. What is the region of a slide reserved for inserting text or graphics called?

· Placeholder

210.

1) Are types of changes that occur when text has been omitted from a document and must be inserted later.

i) ~Copy

ii) ~Paste

iii) =Cut

iv) ~Paste Special

2) controls the way in which the computer system functions and provides a means by which users can interact with the computer.{

i) =The operating system

ii) ~The motherboard

iii) ~The platform

iv) ~Application software

3) is data that has been organized or presented in a meaningful way.{

i) ~A process

ii) =Information

iii) ~Software

iv) ~Storage

4) is the ability of an operating system to control the activities of multiple programs at the same time.{

i) ~Streamlining

ii) ~Multiuser

iii) =Multitasking

iv) ~Simulcasting

5) the heart of the computer and this is where all the computing is done.{

i) ~Keyboard

ii) ~Monitor

iii) =Central Processing Unit

iv) ~Printer

6) is a set of computer programs used in a computer to help perform tasks.{

i) =software

ii) ~memory

iii) ~A processor

iv) ~hardware

7) are distinct items that don't have much meaning to you in a given context?{

i) ~field

ii) =data

iii) ~properties

iv) ~information

8) is the first available high-level language developed by IBM in 1957.{

i) ~PROLOG

ii) =FORTRAN

iii) ~ALGOL

iv) ~LEO

9) is the process of carrying out commands.

i) ~Fetching

ii) =Executing

iii) ~sorting

iv) ~Decoding

10) TD tag is used for ________

i) ~Table heading

ii) =Table data (column or cell)

iii) ~Table row

iv) ~none of the above

11) UL tag is used to ________

i) ~display the numbered list

ii) ~underline the text

iii) =display the bulleted list

iv) ~bold the text

12) TITLE tag must be within ________

i) ~Title

ii) ~Form

iii) =Header

iv) ~Body

13) requires that data should be made available to only authorized users.

i) =Security

ii) ~Data integrity

iii) ~Privacy

iv) ~none

14) 'Blue tooth' technology allows{

i) ~Satellite communication

ii) =Wireless communication between equipments

iii) ~Signal transmission on mobile phones only

iv) ~Landline phone to mobile phone communication

15) LAN' means{

i) ~Least Area Network

ii) ~Large Area Network

iii) =Local Area Network

iv) ~Light Area Network

16) "Ctrl + End" is used to{

i) ~Moves the cursor to the end of Line

ii) =Moves the cursor to the end of Document

iii) ~Moves the cursor to the beginning of Paragraph

iv) ~Moves the cursor to the end of Paragraph

v) ~None of the Above

17) "Ctrl + Home" is used to{

i) =Moves the cursor to the beginning of Document

ii) ~Moves the cursor to the beginning of Line

iii) ~Moves the cursor to the beginning of Paragraph

iv) ~Moves the cursor to the beginning of Passage

v) ~All of the above

18) "Yahoo", "Infoseek" and "Rambler" are _________?{

i) =Search Engines

ii) ~Browsers

iii) ~News groups

iv) ~None of the above

19) 1024 bytes equals\:{

i) =1 KB

ii) ~1 MB

iii) ~1 GB

iv) ~1 TB

20) A ________ in a table represents a relationship among a set of values.{

i) ~Column

ii) ~Key

iii) =Row

iv) ~Entry

21) A ____________ is approximately one billion bytes.{

i) ~bit

ii) ~kilobyte

iii) =gigabyte

iv) ~megabyte

22) A bookmark is an item or location in document that you identify a name for future Reference.Which of the following task is accomplished by using bookmarks?{

i) ~To mark the ending of a page of document

ii) =To quickly jump to a specific location in the document

iii) ~To add hyperlinks in a web page

iv) ~None of These

23) A byte consists of{

i) ~one bit

ii) =eight bit

iii) ~four bit

iv) ~ten bit

24) A character that is raised and smaller above the baseline is known as{

i) =Superscript

ii) ~Raised

iii) ~Outlined

iv) ~Subscript

25) A character that is raised and smaller above the baseline is known as{

i) ~Raised

ii) ~Outlined

iii) ~Italics

iv) =Superscript

26) A character that is raised and smaller above the baseline is known as{

i) ~outlined

ii) ~italic

iii) =superscript

iv) ~subscript

v) ~bold

27) A directory within a directory is called a---{

i) ~mini-Directory

ii) =Sub-Directory

iii) ~Junior Directory

iv) ~none of these

28) A field or a combination of fields that has a unique value is called \:{

i) ~Foreign key

ii) ~Secondary key

iii) =Primary key

iv) ~Alternate key

29) A Formula and a function are the same thing.{

i) ~Yes

ii) =No

30) A function inside another function is termed as{

i) =nested function

ii) ~sum function

iii) ~test function

iv) ~round function

31) A Google Docs account can be created{

i) ~By using any active email address

ii) =By using a Gmail account

iii) ~You do not use an email account to create a Google docs account

iv) ~None of above

32) A person who used his or expertise to gain access to other peoples computers to get information illegally or do damage is{

i) =Hacker

ii) ~Analyst

iii) ~Instant messenger

iv) ~Programmer

33) A person who uses his expertise to gain access to other people's computers to get information illegally or to cause damage is a{

i) ~Programmer

ii) ~Analyst

iii) ~Spammer

iv) =Hacker

34) A predesigned collection of background images, color schemes, and fonts{

i) ~Format

ii) =Theme

iii) ~Template

iv) ~Layout

v) ~None of the above

35) A program that converts computer data into some code system other than the normal one is known as?{

i) ~Emulator

ii) =Encoder

iii) ~Trigger

iv) ~Decoder

36) A proxy server is used for which of the following?{

i) =to provide security against unauthorized access

ii) ~to provide TCP/ip

iii) ~tonprocess client requests for web pages

iv) ~none

37) A relational database consists of a collection of{

i) =Tables

ii) ~Fields

iii) ~Records

iv) ~Keys

38) A single "page" in a presentation that contains text, images, videos, or combination.{

i) ~Sheet

ii) ~Page

iii) =Slide

iv) ~Layout

v) ~None of above

39) A sizeable geographical area with communication based on the telephone system is though as{

i) ~Local area network

ii) =Wide area network

iii) ~Modulator-Demodulator

iv) ~All of the above

40) A storage area used to store data to a compensate for the difference in speed at which the different units can handle data is{

i) ~Memory

ii) =Buffer

iii) ~Accumulator

iv) ~Address

41) A symbol such as a heavy dot or other character that precedes text in a presentation is called a(an) ____.{

i) ~Asterisk

ii) =Bullet

iii) ~List

iv) ~Text slide

v) ~Shape

42) A transaction file is a type of---{

i) =data file

ii) ~master file

iii) ~access method

iv) ~none of these

43) A typical modern computer uses?{

i) =SLIC chips

ii) ~Vacuum tubes

iii) ~Values

iv) ~All of above

44) A typical worksheet has .... Number of columns{

i) ~128

ii) =256

iii) ~512

iv) ~1024

45) A Web site's main page is called{

i) ~Browser Page

ii) ~Search Page

iii) =Home Page

iv) ~Bookmark

46) A worksheet range is a{

i) ~A command used for data modeling

ii) ~A range of values such as from 23 to 234

iii) =A group of cells

iv) ~A group of worksheets

47) A(n) ____ is the basic unit of a PowerPoint presentation.{

i) ~Object

ii) ~Placeholder

iii) =Slide

iv) ~Task Pane

48) A(n) ____ is the basic unit of a PowerPoint presentation.{

i) ~Object

ii) ~Placeholder

iii) =Slide

iv) ~Task pane

v) ~Animation

49) All of the following are examples of input devices EXCEPT a\:{

i) ~scanner

ii) ~mouse

iii) =printer

iv) ~keyboard

50) All of the following are examples of real security and privacy risks EXCEPT\:{

i) ~Viruses

ii) ~Identity theft.

iii) ~Hackers

iv) =Spam

51) All of the following statements concerning windows are true EXCEPT\:{

i) =windows are an example of a command-driven environment.

ii) ~windows can be resized and repositioned on the desktop.

iii) ~more than one window can be open at a time.

iv) ~toolbars and scrollbars are features of windows.

52) Allocation of a resources in a time dependent manner to several program simultaneously called{

i) ~multi user

ii) ~multi tasking

iii) =time sharing

iv) ~None of these

53) ALU is{

i) =Arithmetic Logic Unit

ii) ~Array Logic Unit

iii) ~Application Logic Unit

iv) ~none

54) An association of several structure of a data base can be expressed graphically by?{

i) ~Tuple

ii) ~Record

iii) =Relationship

iv) ~Field

55) AN EDUCATIONAL INSTITUTION WOULD GENERALLY HAVE THE FOLLOWING IN ITS DOMAIN NAME--{

i) ~.org

ii) =.edu

iii) ~.com

iv) ~.sch

56) An excel workbook is a collection of{

i) ~Workbooks

ii) =Worksheets

iii) ~Charts

iv) ~Worksheets and tables

57) An Excel Workbook is a collection of{

i) ~Workbooks

ii) =Worksheets

iii) ~Charts

iv) ~Diagrams

58) Animations in PowerPoint are the same thing as transitions.{

i) ~True

ii) =FalsE

59) Anonymous FTP is the{

i) ~Internet file transfer protocol

ii) ~Protocol that requires password

iii) =Both (a) &amp;(b)

iv) ~None of these

60) Any storage device added to a computer beyond the immediately usable main storage is known as{

i) ~Floppy disk

ii) ~Hard disk

iii) =Backing store

iv) ~Punched card

61) AutoCorrect was originally designed to replace _________ words as you type.{

i) ~Grammatically incorrect

ii) ~Short, repetitive

iii) =Misspelled

iv) ~None of the above

62) Awebpage displays a picture. What tag was used to display that picture?{

i) ~picture

ii) ~image

iii) =img

iv) ~src

63) Borders can be applied to{

i) ~cells

ii) ~paragraph

iii) ~text

iv) =All of above

64) Borders can be applied to...{

i) ~Cells

ii) ~Text

iii) ~Paragraph

iv) =All of above

65) By default, on which page the header or the footer is printed?{

i) ~on first page

ii) ~on alternate page

iii) =on every page

iv) ~none of the above

66) Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?{

i) =Yes

ii) ~No

67) CD-ROM stands for{

i) ~Compactable Read Only Memory

ii) ~Compact Data Read Only Memory

iii) ~Compactable Disk Read Only Memory

iv) =Compact Disk Read Only Memory

68) Choose the correct HTML tag for the largest size heading?{

i) ~heading

ii) ~h6

iii) =h1

iv) ~head

69) Choose the correct HTML tag for the smallest size heading?{

i) ~heading

ii) =h6

iii) ~h1

iv) ~head

70) Choose the correct HTML tag to make a text bold?{

i) =b

ii) ~bold

iii) ~bb

iv) ~bld

71) Choose the correct HTML tag to make a text italic{

i) ~ii

ii) ~italics

iii) ~italic

iv) =i

72) Choose the smallest memory size{

i) =kilobyte

ii) ~megabyte

iii) ~gigabyte

iv) ~terabyte

73) Computer software includes{

i) ~Packaged programs

ii) ~Application programs

iii) ~Operating system programs

iv) =All of these

74) Computers use the ____________ language to process data.{

i) ~relational

ii) ~megabyte

iii) =binary

iv) ~processing

75) Conversion of a decimal number 20(D) to its binary number is{

i) =10100(2)

ii) ~10111(2)

iii) ~10110(2)

iv) ~11110(2)

76) Ctrl+H{

i) =Open Find and Replace Dialog box with activating Replace Tab

ii) ~Open Format Dialog box activating Insert Hyper Link tab

iii) ~Open Insert Dialog box activating Insert Hyper Link Tab

iv) ~Open Insert Hyper Link Dialog box

v) ~None of the Above

77) Ctrl+N{

i) ~Save Document

ii) ~Open Document

iii) =New Document

iv) ~Close Document

v) ~Delete Document

78) Data that are accumulated and processed in group called{

i) ~Group processing

ii) =Batch Processing

iii) ~Time sharing

iv) ~None of these.

79) Empdt1(empcode, name, street, city, state,pincode).For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in{

i) ~1 NF only

ii) =2 NF and hence also in 1 NF

iii) ~3NF and hence also in 2NF and 1NF

iv) ~BCNF and hence also in 3NF, 2NF and 1NF

80) End Key{

i) =Moves the cursor end of the line

ii) ~Moves the cursor to the beginning of the line

iii) ~Moves the cursor end of the document

iv) ~Moves the cursor end of the paragraph

v) ~Moves the cursor end of the screen

81) Excel uniquely identifies cells within a worksheet with a cell name{

i) ~Cell names

ii) ~Column numbers and row letters

iii) =Column letters and row numbers

iv) ~Cell locator coordinates

82) Following is not the form of secondary storage{

i) ~Magnetic tape

ii) ~CDs

iii) =Scanner

iv) ~Hard disk

83) For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.{

i) =Domain

ii) ~Relation

iii) ~Set

iv) ~Schema

84) Formulas in Excel start with{

i) ~%

ii) =\=

iii) ~+

iv) ~?

85) From which menu you can access Picture, Test Box and Chart etc.?{

i) ~File

ii) ~Edit

iii) =Insert

iv) ~View

v) ~References

86) From which menu you can insert Header and Footer?{

i) ~Format menu

ii) ~View Menu

iii) ~Tools Menu

iv) =Insert Menu

87) Functional Dependencies are the types of constraints that are based on______{

i) =Key

ii) ~Key revisited

iii) ~Superset key

iv) ~None of these

88) Getting data from a different cell is called ...{

i) ~Accessing

ii) =Referencing

iii) ~Updating

iv) ~Functioning

89) Google Docs allows you to create the following documents\:{

i) =Documents

ii) ~Spreadsheets

iii) ~Presentation

iv) ~Forms

v) ~All of the above

90) Google docs are{

i) ~Accessible to everyone on the internet

ii) =Only accessible to others that you explicitly share them with

iii) ~Cannot be shared at all

iv) ~Only accessible to friends

v) ~None of above

91) Graphics for word processor{

i) ~Peripheral

ii) =Clip art

iii) ~Highlight

iv) ~Execute

92) Handheld computers come under which category of computer?{

i) =MIni computer

ii) ~Micro computer

iii) ~Super computer

iv) ~Personal computer

93) Hard Disk is a kind of -----{

i) ~Optical Disk

ii) ~Floppy Disk

iii) =Magnetic Disk

iv) ~Temproary Memory

94) High level language is also called-{

i) ~Problem oriented language

ii) ~Business oriented language

iii) ~Mathematically oriented language

iv) =All of the above

95) Home Key{

i) ~Moves the cursor beginning of the document

ii) ~Moves the cursor beginning of the paragraph

iii) ~Moves the cursor beginning of the screen

iv) =Moves the cursor beginning of the line

v) ~Moves the cursor to the end of the line

96) How can you apply exactly the same formatting you did to another text?{

i) ~Copy the text and click on Paste Special tool on new place

ii) =Select the text then click on Format Painter and select the new text

iii) ~Copy the text and paste in new location. Then type the new text again

iv) ~All of above

97) How can you insert a sound file in your word document?{

i) ~From insert -> sound menu option

ii) ~From insert -> file menu option

iii) =From insert -> object menu option

iv) ~None of These

98) How can you make a bulleted list?{

i) ~<list>

ii) ~<nl>

iii) =<ul>

iv) ~<ol>

99) How can you make a numbered list?{

i) ~<dl>

ii) =<ol>

iii) ~<list>

iv) ~<ul>

100) How can you make an e-mail link?{

i) ~<a href\="xxx@yyy">

ii) ~<mail href\="xxx@yyy">

iii) ~<mail>xxx@yyy</mail>

iv) =<a href\="mailto\:xxx@yyy">

101) How can you stop a slide show?{

i) ~Press the right Arrow

ii) =Press Escape

iii) ~Press the left Arrow

iv) ~Press the down Arrow

102) How do you know a range is active?{

i) =It is highlighted on the screen.

ii) ~It has a marquee around it.

iii) ~The data changes to Bold to let me know it's active

iv) ~I'm psychic &amp; I just Know!!

103) How do you rearrange the date in ascending or descending order?{

i) ~Data, table

ii) =Data, sort

iii) ~Data, form

iv) ~Data subtotals

104) How do you select an entire column?{

i) ~Select Edit > Select > Column from the menu

ii) =Click the column heading letter

iii) ~Hold down the shift key as you click anywhere in the column.

iv) ~Hold down the Ctrl key as you click anywhere in the column

105) How is it possible that both programs and data can be stored on the same floppy disk?{

i) ~Floppy disks can only store data, not programs

ii) =Programs and data are both software, and both can be stored on any memory device

iii) ~A floppy disk has to be formatted for one or for the other

iv) ~A floppy disks has two sides, one for data and one for program

106) How many margins are on a page?{

i) ~Two (header and footer)

ii) =Four (top, bottom, right, left)

iii) ~Two (landscape and Portrait)

iv) ~Two (top and bottom)

107) How many megabytes make a gigabyte?{

i) =1024

ii) ~128

iii) ~256

iv) ~512

108) How many rows can you insert in a word document in maximum?{

i) ~40

ii) ~45

iii) ~50

iv) ~55

v) =As you wish

109) How to set bulleted list for the ordinary list{

i) ~Select list and press bullets icon in toolbar

ii) ~Press bullets icon in toolbar

iii) ~Select list and select format --> bullets and numbering

iv) =Both A and C

110) HTML document start and end with which tag pairs?{

i) ~HEAD..../HEAD

ii) ~BODY..../BODY

iii) =HTML..../HTML

iv) ~WEB..../WEB

111) If the cell B1 contains the formula \= $A$1, which of the following statements is true{

i) ~There is a relative reference to cell A1

ii) =There is an absolute reference to cell A1

iii) ~Further changes in value of A1 will not affect the value of B1

iv) ~Further changes in value of B1 will affect the value of A1

112) If you need to change the typeface of a document, which menu will you choose?{

i) ~Edit

ii) ~View

iii) =Format

iv) ~Tools

113) If you need to double underline a word, how will you do that?{

i) ~From Format menu choose Font option and then from Font tab open Underline Style and select Double Underline

ii) ~Go to Format menu and then Font option. Open Underline Style and choose Double Underline

iii) ~Click double underline tool on formatting toolbar

iv) =Select the text then choose Format >> Font and on Font tab open Underline Style and choose Double Underline

114) In a PowerPoint presentation{

i) ~Sound clips can be inserted but not movie clips

ii) ~Movie clips can be inserted but not sound clips

iii) ~Only Movie clips can be inserted

iv) =Both can be inserted

v) ~Only Sound clip can be inserted

115) In a worksheet you can select{

i) ~The entire worksheet

ii) ~Rows

iii) ~Columns

iv) =All of the above

116) In Excel, what are the boxes called?{

i) ~Spreadsheet

ii) ~Squares

iii) =Cells

iv) ~Rectangles

117) In HTML document the tags{

i) ~Should be written in upper case

ii) ~should be written in lower case

iii) ~should be written in propercase

iv) =can be written in both uppercase or lowercase

118) In Microsoft Word shortcut key CTRL+W is used for{

i) ~open the Print dialog box

ii) ~Update the current Web page

iii) =close the current window

iv) ~None of these

119) In MS Word to move the insertion point to the beginning of the next word command used is{

i) =CTRL+RIGHTARROW

ii) ~CTRL+LEFT ARROW

iii) ~CTRL+DOWN ARROW

iv) ~None of these

120) In MS Word, Which of these toolbars allows changing of Fonts and their sizes?{

i) ~Standard

ii) =Formatting

iii) ~Print Review

iv) ~None of these

121) In MS-Access press CTRL+O to{

i) ~Open a new database

ii) =Open an existing database

iii) ~Exit MS-Access

iv) ~None of these

122) In MS-Access to open new database press{

i) =CTRL+N

ii) ~CTRL+O

iii) ~ALT+F4

iv) ~None of these

123) In MS-Word shortcut SHIFT+DELETE is used to{

i) =Delete the selected item permanently without placing the item in the Recycle Bin

ii) ~Copy the selected item

iii) ~Rename the selected item

iv) ~Create a shortcut to the selected item

124) In MS-Word, for what does ruler help?{

i) ~to set tabs

ii) ~to set indents

iii) ~to change page margins

iv) =All of the above

125) In order to perform a calculation in a spreadsheet, you need to use a\:{

i) ~table

ii) =formula

iii) ~field

iv) ~variable

126) In the binary language each letter of the alphabet, each number and each special character is made up of a unique combination of\:{

i) ~eight bytes.

ii) ~eight characters.

iii) =eight bits.

iv) ~eight kilobytes.

127) In the formula, which symbol specifies the fixed columns or rows?{

i) =A.      $

ii) ~B.      *

iii) ~C.      %

iv) ~D.      &amp;

128) In the IBM PC's, the CPU, the device drives, memory, expansion slots and active components are mounted on a single board referred as{

i) =Motherboard

ii) ~Breadboard

iii) ~Daughter board

iv) ~Father board

129) In which Microsoft Office product do you work with animations?{

i) ~Excel

ii) ~Word

iii) =Power Point

iv) ~Access

130) In Word and PowerPoint, what command tab do you go to when you want to add a picture, text box, or word art to your document or presentation?{

i) ~Home

ii) =Insert

iii) ~Design

iv) ~Page Layout

131) Information on a computer is stored as--{

i) ~analog data

ii) =digital data

iii) ~modem data

iv) ~watts data

132) Is it possible to add sound or video clips to your presentation?{

i) =Yes

ii) ~No

133) Java is a{

i) ~Operating System

ii) ~Compiler

iii) ~Input Device

iv) =Programming Language

134) Maximum font size of MS Word is{

i) =1638

ii) ~72

iii) ~512

iv) ~1024

135) MS OFFICE Is Application Software{

i) =True

ii) ~False

136) MS Office provides help in many ways, which of these is one of them?{

i) ~Help menu

ii) ~What is this?

iii) ~Office Assistant

iv) =All of the above

137) Multiprocessing supports more then one_____ at the same time{

i) ~User

ii) =Process

iii) ~Hardware

iv) ~None of these.

138) Once you've deleted text, you can't get it back.{

i) ~True

ii) =False

139) One byte is equival to{

i) =8 bit

ii) ~16 bit

iii) ~32 bit

iv) ~64 bit

140) One nibble is equal to{

i) =4 bits

ii) ~8 bits

iii) ~6 bits

iv) ~16 bits

141) PDF extension is used for which of the following?{

i) ~MS- excel

ii) =adobe Reader

iii) ~photoshop

iv) ~MS Excel

142) Periferal device is{

i) =a device which is not connected to CPU

ii) ~a device which is connected to CPU

iii) ~a direct access storage device

iv) ~an I/O device

143) Personal computers can be connected together to form a{

i) ~server

ii) =network

iii) ~supercomputer

iv) ~enterprise

144) Personal computers use a no. of chips mounted on a main circuit board. what is the common name for such boards?{

i) ~Daughter board

ii) =motherboard

iii) ~Breadboard

iv) ~microchip

145) Portrait and Landscape are{

i) =Page Orientation

ii) ~Paper Size

iii) ~Page Layout

iv) ~All of above

146) PowerPoint is best described asˇ{

i) =Presentation Software

ii) ~Database Software

iii) ~Drawing Software

iv) ~Desktop Publishing Software

147) Pressing F8 key for three times selects{

i) ~A paragraph

ii) =A sentence

iii) ~A word

iv) ~Entire document

148) Primary storage is _____ as compared to secondary storage.{

i) ~Slow and inexpensive

ii) ~Fast and inexpensive

iii) =Fast and expensive

iv) ~Slow and expensive

149) Print{

i) ~Command +X

ii) =Command +P

iii) ~Command +A

iv) ~Command +S

150) Process is\:{

i) ~contents of main memory

ii) ~a job in secondary memory

iii) =a program in execution

iv) ~program in High level language kept on disk

151) Programs designed to perform specific tasks is known as{

i) ~system software

ii) =application software

iii) ~operating system

iv) ~utility program

152) Referential integrity controls relationships between \:{

i) ~attributes in a table

ii) ~operations of an object

iii) ~instances of a class

iv) =tables in a database

153) Related fields in a database are grouped to form ?{

i) ~Data Field

ii) =Data Record

iii) ~Menu

iv) ~Bank

154) Right clicking something in Excel\:{

i) ~Deletes the object

ii) ~Nothing the right mouse button is there for left handed people

iii) =Opens a shortcut menu listing everything you can do to the object

iv) ~Selects the object

155) Selects specific paragraph{

i) ~Double-click word

ii) =Click before first letter-hold SHIFT - click last letter

iii) ~Spellcheck

iv) ~Triple click anywhere

156) Servers are computers that provide resources to other computers connected to a\:{

i) ~mainframe

ii) ~supercomputer

iii) =network

iv) ~client

157) Some things you can do with Google presentations include\:{

i) ~Import presentations in .ppt and .pps file types and export your online ones

ii) ~Insert images and videos, and format your slides as you want

iii) ~Allow simultaneous real-time viewing of presentations, online, from remote locations

iv) ~Publish and embed your presentations in a website for the world to view

v) =All of the above

158) Something which has easily understandable instruction is said to be-------{

i) =user-friendly

ii) ~information

iii) ~icon

iv) ~ruler

159) Superscript, subscript, outline, emboss, engrave are known as{

i) =font effects

ii) ~text effects

iii) ~font styles

iv) ~word art

160) Superscript, subscript, outlines, emboss and engrave are known as .....{

i) =font effects

ii) ~text effects