Question Bank
Question Bank
2
Ans: Integrated Circuits
17. ULSI Stands for __________.
a) Ultra Large Storage Integrator
b) Ultra Large Storage Integration
c) Ultra Large Scale Integration
d) Ultra Large Scale Integrator
Ans: Ultra Large Scale Integration
18. Name the full name of AI technology
a) Automatic Integrated
b) Automated Intelligence
c) Artificial Intelligence
d) Artificial Integration
Ans: Artificial Intelligence
19. Microsoft word is ____ software
a) Application
b) Compiler
c) System
d) Programming
Ans: Application
20. Select all the text in MS Word document by
a) Ctrl +S
b) Ctrl + N
c) Ctrl + A
d) Ctrl + V
Ans: Ctrl + A
21. Ctrl + N is used to A. Save the Document
B. Open the Document
C. Close the Document
D. Create a New Document
Ans: Create a New Document
22. Documents can be ____ with MS Word.
a) Created
b) Edited
c) Saved
d) All of the mentioned
Ans: All of the mentioned
23. What tab in MS Word you'll use to access Mail Merge options in MS Word ?
a) Home tab
b) Insert tab
c) References tab
d) Mailings tab
Ans: Mailings tab
24. Which is not in MS Word
a) Italic
b) Magic tool
c) Font
d) Bold
3
Ans: Magic tool
25. ____ cannot be used to work in MS Office.
a) Joystick
b) Scanner
c) Light Pen
d) Mouse
Ans: Joystick
26. Which is not an edition of MS Word?
a) MS Word 2003
b) B. MS Word 2007
c) C. MS Word 2010
D. MS Word 1020
Ans: MS Word 1020
27. Which of the following is an example of page orientation?
a) Landscape
b) Subscript
c) Superscript
d) A4
Ans: Landscape
28. Formatting is performed on
a) Text
b) Table
c) Menu
d) Both (a) and (b)
Ans: Both (a) and (b)
29. Which of the following software is used for making a resume?
a) MS Excel
b) MS Word
c) Dev C
d) Java
Ans: MS Word
30. Press ____ to open the help window in the MS Word document.
a) F1
b) B. F2
C. F9
D. F11
Ans: F1
31. The ability to combine name and addresses with a standard document is called
A. Document formatting
B. Database management
C. Mail merge
D. Form letters
Ans: Mail merge
32. Which of the following option is provided by Office Button?
a) Print
b) Open
4
c) Save
d) All of the mentioned
Ans: All of the mentioned
33. The name of a word document displays in ____.
a) Ribbon
b) Title bar
c) Status bar
d) Home tab
Ans: Title bar
34. Where footnotes appear in a document
a) Bottom of a Page
b) End of document
c) End of Heading
d) None
Ans: Bottom of a Page
35. which image format is not suppported by MS Word?
a) WEBP
b) JPG
c) JPEG
d) PNG
Ans: WEBP
36. Which one is not a Function in MS Excel ?
a) SUM
b) AVG
c) MAX
d) MIN
Ans: AVG
37. Functions in MS Excel must begin with ___
a) An () sign
b) An Equal Sign
c) A Plus Sign
d) A > Sign
Ans: An Equal Sign
38. In Excel, Rows are labelled as ______
a) A, B, C, etc
b) 1,2,3 etc
c) A1, A2, etc.
d) $A$1, $A$2, etc.
Ans: 1, 2, 3, etc
39. It is a collection of data that is stored electronically as a series of records in a table.
a) spreadsheet
b) presentation
c) database
d) MS Word
Ans: database
40. The short cut key to highlight the entire column:
a) Ctrl+C
5
b) Ctrl + Enter
c) Ctrl + Page Up
d) Ctrl + Spacebar
Ans: Ctrl + Spacebar
41. Which area in an Excel window allows entering values and formulas?
a) Title Bar
b) Menu Bar
c) Formula Bar
d) Standard Tool Bar
Ans: Formula Bar
42. A printer that prints one line at a time and has a predefined set of characters is called _______
a) Laser
b) Drum
c) Inkjet
d) Impact
Ans: Drum
43. What kind of Software is Excel? A. Word Processing Software
B. Spreadsheet Software
C. Data Base Software
D. None of these
Ans: Spreadsheet Software
44. In Execl Rows are labeled by- A. Letters
B. Numbers
C. Rows and Numbers
D. String
Ans: Numbers
45. Which of the following will not cut information?
a) Pressing Ctrl + C
b) Selecting Edit > Cut from the menu
c) Clicking the Cut button on the standard
d) Pressing Ctrl+X
Ans: Pressing Ctrl + C
46. The auto calculate feature
a) Can only add values in a range of cells
b) Provides a quick way to view the result of an arithmetic operation on a range of cells
c) Automatically creates formulas and adds them to a worksheet
d) Both A and C
Ans: Provides a quick way to view the result of an arithmetic operation on a range of cells
47. Excel files have a default extension of
a) Xls
b) Xlw
c) Wk1
d) 123
Ans: Xls
48. Which functionin Excel tells how many numeric entries are there ?
a) CHKNUM
6
b) COUNT
c) NUM
d) SUM
Ans: COUNT
49. Which functionin Excel checks whether a condition is true or not ?
a) COUNT
b) AVERAGE
c) SUM
d) IF
Ans: IF
50. In Word, what does the "Superscript" formatting option allow you to do?
a) Change the font size
b) Apply bold formatting
c) Format text as smaller characters above the baseline
d) Insert hyperlinks
Ans: Format text as smaller characters above the baseline
51. How will you graphically represent expenditure in different departments ? A. Column Chart
B. Line Chart
C. Pie Chart
D. Dot Chart
Ans: Pie Chart
52. The basic unit of a worksheet into which you enter data in Excel is called a
a) Cell
b) Table
c) Box
d) Column
Ans: Cell
53. What type of chart is good for single series of data ?
a) Column Chart
b) Line Chart
c) Cone Chart
d) Pie Chart
Ans: Pie Chart
54. The process of arrenging the items of a column in some sequence or order is known as :
a) Arrenging
b) Autofill
c) Filtering
d) Sorting
Ans: Sorting
55. The Greater Than sign (>) is an example of _____ operator.
a) Arithmatic
b) Conditional
c) Logical
d) Greater
Ans: Conditional
56. Which types of templates provides all the users with a design concept, colour scheme, and
fonts for presentation?
7
a) Content
b) Format
c) Normal
d) Design
Ans: Design
57. Which of the following is not a default document type for a mail merge?
a) Letters
b) Envelopes
c) Memos
d) Directory
Ans: Letters
58. We can insert a page number at
a) Header
b) Footer
c) Both A and B
d) None
Ans: Both A and B
59. Which of the following is the file extension of the PowerPoint application?
a) .ppt
b) .jpg
c) .html
d) .docs
Ans: .ppt
60. Which of the following shortcut key is used to start the slideshow?
a) F1 B. F2 C. F5
D. F9
Ans: F5
61. The shortcut key is used to stop the slide show is
a) Esc key
b) Ctrl+O
c) Ctrl+X
d) Enter
Ans: Esc key
62. In the current presentation, if we want to insert a new slide, we use the key combination:
a) Ctrl + F
b) Ctrl + O
c) Ctrl + M
d) Ctrl + N
Ans: Ctrl + M
63. From which of these menus can we access a Text Box, Picture, Chart etc.?
a) View
b) Insert
c) Edit
d) File
Ans: Insert
64. The default orientation of the slides in PowerPoint is:
a) Landscape
8
b) Portrait
c) Vertical
d) None of the mentioned
Ans: Landscape
65. To start Microsoft PowerPoint application
a) Click on Start > Programs > All Programs > Microsoft PowerPoint
b) Hit Ctrl + R then type ppoint.exe and Enter
c) Click Start > Run then type powerpnt then press Enter
d) Start -> All Programs -> MS Office -> Microsoft Office Powerpoint
Ans: Start -> All Programs -> MS Office -> Microsoft Office Powerpoint
66. new presentation can be created from
a) Blank Presentation
b) From Existing Presentation
c) From Design Template
d) All of mentioned
Ans: Blank Presentation
67. Which is the menu to create a text box on a slide?
a) View -> Text Box
b) Tools -> Text Box
c) Insert -> Text Box
d) Format -> Text Box
Ans: Insert -> Text Box
68. Which of the following section does not exist in a slide layout?
a) Titles
b) Lists
c) Charts
d) Animations
Ans: Animations
69. The File that consists of readymade styles that we can easily use for our presentation is known
as:
a) Pre formatting
b) Template
c) Wizard
d) AutoStyle
Ans: Template
70. What is the max Zoom percentage in MS PowerPoint?
a) 4 B. 3 C. 2
D. 1
Ans: 4
71. A PowerPoint design template is stored in any file with __________ extensions.
a) .pot B. .ptt
C. .dtp
D. .ppt
Ans: .ppt
72. What is the purpose of Word's "Page Break" feature?
a) To end the current page and start a new one
b) To change the page orientation
9
c) To insert a picture into a document
d) To create a hyperlink
Ans: To end the current page and start a new one
73. Which of following are not PowerPoint views?
a) Page View
b) Print View
c) Normal View
d) Outline View
Ans: Outline View
74. The term HTTP stands for?
a) Hyper terminal tracing program
b) Hypertext tracing protocol
c) Hypertext transfer protocol
d) Hypertext transfer program
Ans: Hypertext transfer protocol
75. Which software prevents the external access to a system?
a) Firewall
b) Gateway
c) Router
d) Virus checker
Ans: Firewall
76. The term FTP stands for? A. File transfer program
B. File transmission protocol
C. File transfer protocol
D. File transfer protection
Ans: File transfer protocol
77. Which one of the following is not a network topology?
a) Star
b) Ring
c) Bus
d) Peer to Peer
Ans: Peer to Peer
78. The term LAN stands for?
a) Local Area Net
b) Local Aera Network
c) Local Array Network
d) Local Array Net
Ans: Local Aera Network
79. A computer virus is a
a) Hardware
b) Software
c) Bacteria
d) Freeware
Ans: Software
80. What does a set of rules define?
a) SMTP
b) FTP
10
c) IMAP
d) Protocol
Ans: Protocol
81. www stands for A. World with web
B. World without web
C. World wide web
D. World within web
Ans: World wide web
82. Identify the device used to boost up a weak signal
a) Modem
b) Repeater
c) Switch
d) Router
Ans: Repeater
83. MAC stands for A. Media Access Control
B. Mass Access Control
C. Media Access Carriage
D. None of the mentioned
Ans: Media Access Control
84. choose the full form of ISP A. Internet Server Provider
B. Internet Service Provider
C. Internet Service Protocol
D. None of these
Ans: Internet Service Provider
85. Select which agency the Internet was originally a project of
a) ARPA
b) NFS
c) NSA
d) ISRO Ans: ARPA
11
c) DNS handler
d) DNS user
Ans: DNS resolver
89. Identify Error 404 mean-
a) The server could not find the required URL
b) Requested HTML file is not available
c) The path to the interpreter of the script is not valid
d) The requested HTML file does not have sufficient permissions
Ans: The server could not find the required URL
90. In which of the following a person is constantly followed/chased by another person or group
of several peoples?
a) Phishing
b) Bulling
c) Stalking
d) Identity theft
Ans: Stalking
91. Which one of the following can be considered as the class of computer threats?
a) Dos Attack
b) Phishing
c) Soliciting
d) Both A and C
Ans: Dos Attack
92. What is a Patent?
a) An agreement to the Government
b) Document of the library
c) An agreement between the inventor and the Government
d) An agreement between library and Publisher
Ans: An agreement between the inventor and the Government
93. World of learning is a what source of information
a) Primary source
b) Documentary source
c) Secondary source
d) Tertiary source
Ans: Secondary source
94. Facts of File is weekly digest of
a) Indian events
b) American events
c) World events
d) England events
Ans: World events
95. Order passed by Controller is challengeable before :
a) Cyber Appellate Tribunal
b) Adjudicatory Officer
c) Supreme Court
d) High Court
Ans: Cyber Appellate Tribunal
96. Tampering with Computer Source Documents is ______ offence.
12
a) Bailable
b) Non-bailable
c) Non-cognizable
d) Both (a) and (c)
Ans: Non-bailable
97. Authentication is _________
a) To assure identity of user on a remote system
b) Insertion
c) Modification
d) Integration
Ans: To assure identity of user on a remote system
98. Which section of IT Act deals with the legal recognition of electronic records ?
a) Section 4 B. Section 2 C. Section 5
D. Section 6
Ans: Section 4
99. Which Section deals with cyber terrorism ?
a) 66 C
b) 66 B
c) 66 D
d) 66 F
Ans: 66 F
100. What is the maximum penalty for damage to computer, computer system ?
a) Rs. 50 lakh
b) Rs. 1 crore
c) Rs. 5 crore
d) 5 lakh
Ans: Rs. 1 crore
101. What is the penalty for destroying computer source code ?
a) Three yrs imprisonment or 5 lakh Rs. or both B. Three yrs imprisonment or 1 lakh Rs. or both
C. Three yrs imprisonment or 1 lakh Rs. or both
D. 4Three yrs imprisonment or 2 lakh penalty or both
Ans: 4Three yrs imprisonment or 2 lakh penalty or both
102. Amendment to IT Act 2000 came into effect on _______.
a) 2008 Oct. 2
b) 2009 July 3
c) 2008 June 1
d) 2009 Oct. 27
Ans: 2008 Oct. 2
103. In Word, what does the "Page Color" option allow you to do?
a) To add page numbers to a document
b) To check grammar and spelling
c) To change the background color of a document's pages
d) To insert pictures and shapes
Ans: To change the background color of a document's pages
104. What is a cell in Excel?
a) A mathematical formula
b) A data analysis tool
13
c) The intersection of a row and a column
d) A type of chart
Ans: A type of chart
105. Which ribbon tab in Excel provides options for formatting cells, fonts, and alignment?
a) Data
b) Home
c) Insert
d) Review
Ans: Home
106. What is a computer?
a) A device that performs calculations and logical operations
b) A device that generates electricity
c) A device used for communication
d) A device used for cooking
Ans: A device that performs calculations and logical operations
107. Which of the following is not a function of a computer? A. Storage
B. Processing
C. Communication
D. Maintenance
Ans: Maintenance
108. The first electronic computer was developed during which era? A. Mechanical Era
B. Vacuum Tube Era
C. Transistor Era
D. Microprocessor Era
Ans: Vacuum Tube Era
109. The basic anatomy of a computer consists of
a) Input, processing, output
b) CPU, RAM, ROM
c) Monitor, keyboard, mouse
d) Software, hardware, firmware
Ans: Input, processing, output
110. Which component of a computer is responsible for executing instructions?
a) CPU
b) RAM
c) GPU
d) HDD
Ans: CPU
111. What is the main function of an operating system?
a) Managing hardware resources
b) Creating documents and spreadsheets
c) Connecting to the internet
d) Playing games
Ans: Managing hardware resources
112. MS Office is a suite of:
a) Database software
b) Graphic design software
14
c) Productivity software
d) Web development software
Ans: Productivity software
113. MS Word is a word processing software developed by: A. Microsoft
B. Adobe
C. Apple
D. Google
Ans: Microsoft
114. Which menu option is used to change the font in MS Word?
a) File
b) View
c) Format
d) Insert
Ans: Format
115. Which of the following is used to change the font size in MS Word?
a) Bold
b) Italic
c) Underline
d) Font size drop-down menu
Ans: Font size drop-down menu
116. What is the purpose of paragraph spacing in MS Word?
a) To adjust the space between lines in a paragraph
b) To adjust the space between paragraphs
c) To adjust the space between words in a paragraph
d) To adjust the space between characters in a paragraph
Ans: To adjust the space between paragraphs
117. Which option is used to set the margins in MS Word?
a) Page Setup
b) Page Layout
c) Format Painter
d) Font
Ans: Page Setup
118. The ruler in MS Word is used to:
a) Measure the length of a document
b) Set tab stops and adjust indentation
c) Change the font size
d) Insert tables and graphics
Ans: Set tab stops and adjust indentation
119. Bulleted and numbered lists in MS Word are found under which menu option?
a) File
b) View
c) Format
d) Insert
Ans: Insert
120. Which option is used to insert headers and footers in MS Word? A. Page Setup
B. Page Layout
15
C. Format Painter
D. Insert
Ans: Page Layout
121. Newspaper columns can be used in MS Word to:
a) Insert images into a document
b) Create newspaper-like layouts
c) Sort data in a table
d) Highlight text in a document
Ans: Create newspaper-like layouts
122. What does the term "URL" stand for in the context of the internet?
a) Unified Resource Locator
b) Universal Resource Locator
c) Uniform Resource Link
d) Universal Reference Link
Ans: Universal Resource Locator
123. Which of the following is NOT a commonly used web browser?
a) Google Chrome
b) Mozilla Firefox
c) Adobe Acrobat
d) Microsoft Edge
Ans: Adobe Acrobat
124. Which technology allows data to be transmitted over the internet in small, discrete packets?
a) FTP
b) TCP/IP
c) HTTP
d) Packet Switching
Ans: Packet Switching
125. What does "IoT" stand for in the context of modern business technologies?
a) Internet of Things
b) Information of Technology
c) International Online Transactions
d) Integrated Office Tools
Ans: Internet of Things
126. Which protocol is commonly used for secure data transmission over the internet, such as
during online shopping?
a) HTTP
b) FTP
c) SSL/TLS
d) UDP
Ans: SSL/TLS
127. Which of the following is an example of cloud computing service?
a) Java
b) Linux
c) Amazon Web Services (AWS)
d) Microsoft Word
Ans: Amazon Web Services (AWS)
128. What is the primary purpose of a firewall in the context of network security?
16
a) Filtering incoming and outgoing network traffic
b) Speeding up internet connections
c) Providing physical security to servers
d) Creating backup copies of data
Ans: Filtering incoming and outgoing network traffic
129. Which of the following is a key advantage of using blockchain technology in business?
a) High centralization
b) Fast transaction processing
c) Transparency and immutability of records
d) Limited scalability
Ans: Transparency and immutability of records
130. What is a worksheet in Microsoft Excel
a) A collection of charts
b) A collection of data organized in rows and columns
c) A collection of macros
d) A collection of formulas
Ans: A collection of data organized in rows and columns
131. In Word, what does the "Undo" feature do?
a) Deletes the selected text
b) Reverses the last action performed
c) Cuts the text to the clipboard
d) Changes the font style
Ans: Reverses the last action performed
132. In Word, what does the "Paste Special" option allow you to do?
a) To insert pictures and shapes
b) To check grammar and spelling
c) To paste copied content with specific formatting options
d) To create charts
Ans: To paste copied content with specific formatting options
133. What is the purpose of Word's "Format Painter" tool?
a) To insert pictures and shapes
b) To copy and apply formatting from one text or object to another
c) To check grammar and spelling
d) To create charts
Ans: To copy and apply formatting from one text or object to another
134. What does the function "=COUNT(A1:A10)" do in Excel?
a) Adds the values in cells A1 to A10
b) Divides the values in cells A1 to A10
c) Multiplies the values in cells A1 to A10
d) Counts the number of non-empty cells in the range A1 to A10
Ans: Counts the number of non-empty cells in the range A1 to A10
135. In Excel, what is a cell reference?
a) A label for a worksheet
b) The row and column address of a cell
c) A hyperlink to another workbook
d) A formula that calculates values Ans: The row and column address of a cell
17
136. Which Excel feature allows you to freeze rows and columns so that they remain visible when
scrolling through a large worksheet?
a) Freeze Panes
b) Filter
c) PivotTable
d) Sort
Ans: Freeze Panes
137. What is the purpose of the "Data Validation" feature in Excel?
a) To sort data alphabetically
b) To perform calculations
c) To control the type and values that can be entered into a cell
d) To create charts
Ans: To control the type and values that can be entered into a cell
138. What is the purpose of the "PivotTable" feature in Excel?
a) To create charts
b) To perform calculations
c) To summarize and analyze data from a large dataset
d) To format cells
Ans: To summarize and analyze data from a large dataset
139. In Excel, what does the "Merge & Center" option do?
a) Splits cells into multiple smaller cells
b) Combines and centers the contents of selected cells into one cell
c) Clears the contents of selected cells
d) Applies conditional formatting to cells
Ans: Combines and centers the contents of selected cells into one cell
140. In Excel, what does the "Wrap Text" option do?
a) Inserts a line break within a cell to display text on multiple lines
b) Deletes text from a cell
c) Formats text as bold
d) Converts text to uppercase
Ans: Inserts a line break within a cell to display text on multiple lines
141. In Excel, what does the "Protect Sheet" feature allow you to do?
a) Apply cell formatting
b) Hide rows and columns
c) Restrict editing and formatting changes to a worksheet
d) Sort data alphabetically
Ans: Restrict editing and formatting changes to a worksheet
142. Which function in Excel is used to find the highest value in a range of cells that meet multiple
criteria?
a) MAX
b) SUM
c) IF
d) SUMIFS
Ans: SUMIFS
143. Which function in Excel is used to find the number of cells within a range that do not meet
specific criteria?
a) COUNT
18
b) SUM
c) IF
d) COUNTIF
Ans: COUNTIF
144. In PowerPoint, what is the purpose of the "Slide Number" option?
a) To insert pictures into slides
b) To create animations
c) To display slide numbers on each slide
d) To create speaker notes
Ans: To display slide numbers on each slide
145. What is the purpose of "Transitions" in PowerPoint?
a) To insert pictures into slides
b) To create animations
c) To add visual effects when moving from one slide to another
d) To create speaker notes
Ans: To add visual effects when moving from one slide to another
146. In PowerPoint, what is the purpose of the "Custom Animation" feature?
a) To insert pictures into slides
b) To check spelling and grammar
c) To create and customize animations for objects on a slide
d) To create speaker notes
Ans: To create and customize animations for objects on a slide
147. What is the purpose of the "Slide Show" tab in PowerPoint?
A. To insert pictures into slides
B. To apply slide transitions
C. To start and control slide shows
D. To create speaker notes
Ans: To start and control slide shows
148. What is the purpose of the "Morph" transition in PowerPoint?
A. To insert pictures into slides
B. To create animations that smoothly transform objects from one slide to another
C. To apply visual effects to text
D. To create speaker notes
Ans: To create animations that smoothly transform objects from one slide to another
149. What is the purpose of the "Set as Background" option for images in PowerPoint?
A. To insert pictures into slides
B. To create animations
C. To set an image as the slide background, making it non-editable
D. To create speaker notes
Ans: To set an image as the slide background, making it non-editable
150. In PowerPoint, what is the purpose of the "Slide Layout" feature?
A. To insert pictures into slides
B. To create animations
C. To apply predefined arrangements of placeholders for text and objects on a slide
D. To create speaker notes
Ans: To apply predefined arrangements of placeholders for text and objects on a slide
19
3marks :
20
44. Discuss the concept of CC (Carbon Copy) in email.
45. Compare and contrast the advantages and disadvantages of e-business models.
46. Describe the difference between e-business and traditional business.
47. Define "cybercrime."
48. Describe the difference between copyright and trademark.
49. How do you change the cell format to display currency in Excel?
50. Identify and explain the purpose of the XLSX and CSV file formats.
5marks:
21
37. Identify the difference between a title slide and a content slide layout in PowerPoint.
38. explain the impact of using visuals (e.g., images, charts) in a presentation.
39. Illustrate a custom animation sequence for objects on a slide.
40. Summarize the process of Electronic law reports.
41. Summarize the process ofDelivery of electronic judgments.
42. Explain the difference between the internet and the intranet.
43. Describe the components of a standard email message.
44. Write the differences between various operating systems (e.g., Windows, macOS, Linux).
45. Explain the key components of Windows 10
46. Compare and contrast the characteristics of the first-generation and fifth-generation computers.
47. Tell the purpose of rows, columns, and cells in an Excel spreadsheet.
48. How can you customize the timing of animations and transitions in a presentation?
49. Exaplain some Basic anatomy of Computers.
50. What is a network device, and how does it contribute to network communication?
22