 |
| Office Automation Tools |
151. In a PowerPoint presentation
A. sound clips can be inserted but not movie clips
B. movie clips can be inserted but not sound clips
C. both cannot be inserted
D. both can be inserted
Answer:
D.both can be inserted
152. To insert a hyperlink in a slide
A. choose insert >> hyperlink
B. press ctrl + k
C. hyperlinks can’t be inserted in slides
D. both a & b
Answer:
D.both a & b
153. List Box and Text box
A. are some other than that in a list box the bullets are enabled
B. are different. list boxes are used to present lists and can’t be created with text boxes.
C. both of above
D. none of above
Answer:
A.are some other than that in a list box the bullets are enabled
154. Which of the following statement is true
A. you can insert text boxes from drawing toolbar in PowerPoint
B. you cannot insert text boxes from drawing toolbar in PowerPoint
C. text boxes are provided when you choose a layout and can’t be inserted afterward
D. none of above
Answer:
A.you can insert text boxes from drawing toolbar in PowerPoint
155. When you delete a text box object from a slide in PowerPoint Presentation
A. the object is deleted but text box and the text inside is left on the slide
B. the text box is deleted and the text is pasted on the slide
C. the text box and text both are deleted
D. none of above
Answer:
B.the text box is deleted and the text is pasted on the slide
156. Which of the following font effect is not available in PowerPoint Font dialogbox?
A. underline
B. shadow
C. emboss
D. strikethrough
Answer:
D.strikethrough
157. What happens if you edited an image inserted in Power Point?
A. the original file that was inserted is not changed
B. the original file that was inserted is changed
C. the original file is changed when you save presentation
D. none of above
Answer:
A.the original file that was inserted is not changed
158. If you select Insert >> Picture >> From File
A. you can insert pictures and clipart
B. you can insert clipart only
C. you can insert pictures only
D. none of above
Answer:
C.you can insert pictures only
159. The effect applied to display when slides changes in slide show view is
A. slide animation
B. custom animation
C. custom transition
D. slide transition
Answer:
D.slide transition
160. To start slide show of a presentation
A. hit f5 key
B. from slide show menu choose view show option
C. from slide show menu choose rehearse timing
D. both a & b
Answer:
D.both a & b
161. Which file format can be added to a PowerPoint show?
A. .jpg
B. .giv
C. .wav
D. all of the above
Answer:
D.all of the above
162. In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are
A. .wav files and .mid files
B. .wav files and .gif files
C. .wav files and .jpg files
D. .jpg files and .gif files
Answer:
A..wav files and .mid files
163. What is a motion path?
A. a type of animation entrance effect
B. a method of advancing slides
C. a method of moving items on a slide
D. all of the above
Answer:
C.a method of moving items on a slide
164. What is a slide-title master pair?
A. the title area and text area of a specific slide
B. a slide master and title master merged into a single slide
C. a slide master and title master for a specific design template
D. all of above
Answer:
C.a slide master and title master for a specific design template
165. Which of the following should you use if you want all the slide in the presentation to have the same “look”?
A. the slide layout option
B. add a slide option
C. outline view
D. a presentation design template
Answer:
D.a presentation design template
166. In the context of animations, what is a trigger?
A. an action button that advances to the next slide
B. an item on the slide that performs an action when clicked
C. the name of a motion path
D. all of above
Answer:
B.an item on the slide that performs an action when clicked
167. If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)
A. inclusion
B. attachment
C. reply
D. forward
Answer:
B.attachment
168. In order to edit a chart, you can
A. triple-click the chart object
B. click and drag the chart object
C. double click the chart object
D. click the chart object
Answer:
C.double click the chart object
169. To exit the PowerPoint
A. click the application minimize button
B. click the document close button
C. double click the applications control menu icon
D. double click the document control menu icon
Answer:
C.double click the applications control menu icon
170. special effects used to introduce slides in a presentation are called
A. effects
B. custom animations
C. transitions
D. present animations
Answer:
C.transitions
171. What is the term used when you press and hold the left mouse key and more the mouse around the slide?
A. highlighting
B. dragging
C. selecting
D. moving
Answer:
B.dragging
172. Which of the following toolbars provide different options in various master views?
A. common tasks toolbar
B. drawing toolbar
C. formatting toolbar
D. standard toolbar
Answer:
A.common tasks toolbar
173. In Ms Excel ————– are text entries
A. labels
B. tupple
C. attributes
D. character
Answer:
A.labels
174. Which of the following is not a financial function in Excel?
A. pv
B. count
C. pmt
D. rate
Answer:
B.count
175. Which of the following is not a database function in excel?
A. dmax
B. dmin
C. dcount
D. ddb
Answer:
D.ddb
176. In Excel, we can use ——— function to calculate EMI of loan.
A. ipmt
B. pmt
C. goal seek
D. correl
Answer:
B.pmt
177. Which of the following is not a statistical function in excel?
A. average
B. correl
C. stdev
D. sum
Answer:
D.sum
178. Which of the following coming under “What-If –Analysis” in excel?
A. goal seek
B. scenario manager
C. data table
D. all the above
Answer:
D.all the above
179. ———- is a method to find a specific value of cell by adjusting the value of another cell.
A. goal seek
B. scenario manager
C. data table
D. macro
Answer:
A.goal seek
180. Which of the following is not a logical function in excel?
A. and
B. false
C. or
D. none of these
Answer:
D.none of these
181. By default an excel work book displays——— work sheets
A. 1
B. 2
C. 3
D. 5
Answer:
C.3
182. “Auto fill” is a unique feature of:
A. ms word
B. ms excel
C. ms PowerPoint
D. all of these
Answer:
B.ms excel
183. Which of the following is not a basic mathematical function in Excel?
A. addition
B. division
C. exponential
D. none of these
Answer:
D.none of these
184. In Excel row’s heading is known as
A. field
B. tupple
C. domain
D. attributes
Answer:
B.tupple
185. In email, addresses separate the user name from the ISP using the __________symbol.
A. &
B. @
C. %
D. $
Answer:
B.@
186. The mail server as defined in the text uses the __________ protocol.
A. http
B. ftp
C. pop
D. smtp
Answer:
C.pop
187. News servers utilize __________ to distribute documents to readers.
A. nntp
B. news
C. http
D. ftp
Answer:
A.nntp
188. To search FTP archives for a file, you should use the __________ tool.
A. gopher
B. jughead
C. archie
D. jalopy
Answer:
B.jughead
189. __________ is often referred to as “the CB of the Internet.”
A. irc
B. ftp
C. e-mail
D. http
Answer:
A.irc
190. Answer: groups may have a __________ who monitors the postings and enforces the site’s rules.
A. judge
B. sysop
C. narrator
D. censor
Answer:
B.sysop
191. A message with replies on a newsgroup is often called a __________.
A. post
B. list
C. thread
D. comment
Answer:
C.thread
192. Internet is governed by_____________.
A. Microsoft corporation.
B. Adobe.
C. dish net.
D. none of these.
Answer:
D.none of these.
193. Which of the following is not a web browser?
A. Internet browser
B. Netscape communicator.
C. Netscape navigator
D. Adobe PageMaker.
Answer:
D.adobe pagemaker.
194. HTML means_______.
A. hyper text mark-up language.
B. hyper testing mark-up language.
C. hardware text mark-up language.
D. hyper testing mapping language.
Answer:
A.hyper text mark-up language.
195. URL stands for____________.
A. uniform resource locator.
B. uniform resource ladder.
C. uniform resource locator.
D. uniform reserved locator.
Answer:
C.uniform resource locator.
196. WWW means_______________.
A. world wide wan.
B. world wide web.
C. world wan web.
D. world wan web.
Answer:
B.world wide web.
197. WWW uses the following protocol?
A. http.
B. ftp
C. wwwc
D. smtp.
Answer:
A.http
201. In the mda.edu, the component .edu signifies that_____________________.
A. mda is an educational institute.
B. mda is a commercial organization.
C. mda is a non profit organization.
D. mda is a government organization.
Answer:
A.mda is an educational institute.
202. Internet can be used for____________.
A. uploading.
B. downloading.
C. chatting.
D. all of these.
Answer:
D.all of these.
203. In an e-mail address @ is used. It represents________________.
A. domain name.
B. senders name.
C. recipients name.
D. network name
Answer:
A.domain name.
204. Real time textual talk is called___________.
A. chatting.
B. browsing.
C. surfing.
D. www.
Answer:
A.chatting.
205. Which of the following is a requirement for e-commerce?
A. Paper.
B. Internet connectivity.
C. USB.
D. Digital signature.
Answer:
B.Internet connectivity.
206. The segment in which business directly sells to the end consumer iscalled____________.
A. c2c.
B. p2p.
C. b2c.
D. g2g.
Answer:
C.b2c.
207. The payment on Internet is generally made through_________________.
A. cash card.
B. debit card.
C. credit card.
Answer:
C.credit card
208. _____________ governs cyber practices in India.
A. uncitral 1996.
B. it act 2000.
C. transfer of property law.
D. microsoft corporation.
Answer:
B.it act 2000.
209. ___________ monitors all the traffic that flows between the two networks but block certain traffic completely which may be intruder.
A. firewall.
B. anti-virus.
C. software.
D. hardware.
Answer:
A.firewall.
210. WAN stands for________.
A. wire and network.
B. wire accessible network.
C. widely accessible network.
D. wide area network
Answer:
D.wide area network
211. In which network the ends are not connected?
A. bus.
B. star.
C. ring.
D. token ring.
Answer:
A.bus.
212. Using any host computer on the internet as if you were directly connected iscalled__________.
A. ftp.
B. telnet.
C. e mail.
D. ppp.
Answer:
A.ftp.
213. GPRS refers to ___________.
A. global packet radio service
B. global potential radio service
C. global powerful radio service
D. global physical radio service
Answer:
A.global packet radio service
214. HTTP refers to________.
A. Hypertext transfer protocols
B. Hypertext transfer procedure.
C. Home text translating process.
D. Hypertext translating process.
Answer:
A.Hypertext transfer protocols
215. The internet means__________.
A. network of computers.
B. network through links.
C. network of electronic devices.
D. network of electrical devices.
Answer:
A.network of computers.
216. In internet terminologies, “IP” stands for_________.
A. intranet protocol.
B. internet protocol
C. individual protocol.
D. industrial protocol.
Answer:
B.internet protocol
217. The web page means___________.
A. plain page.
B. hyperlink.
C. designed page.
D. pictures.
Answer:
C.designed page.
218. The HTML programming uses__________.
A. tags.
B. numbers.
C. pictures.
D. tables.
Answer:
A.tags.
219. The Hyperlink means_________________.
A. text connected to page.
B. plain text.
C. graphic text.
D. none of these.
Answer:
A.text connected to page.
220. The use of integrated services digital network is____________.
A. more faster
B. slower.
C. free service.
D. constant access.
Answer:
C.free service.
221. E-commerce means________________.
A. business through the internet.
B. commercial activities through electronic media.
C. electrical commerce.
D. commercial transaction.
Answer:
B.commercial activities through electronic media.
222. ______ provides the continuous access to wireless network services and flexible communication between the people.
A. network.
B. laptop.
C. mobile computing.
D. personal computing.
Answer:
C.mobile computing.
223. _______ refers to using the small portable and handheld computing devices such as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless-enabled network.
A. personal computing
B. digital computing.
C. network computing.
D. mobile computing.
Answer:
D.mobile computing.
224. A___________ identifies a user’s personal preferences and settings and allows the website’s server to retrieve your information from its database.
A. cookie.
B. view history.
C. prototype.
D. profile.
Answer:
A.cookie.
225. The area that contains the URL or web address of the active web page is called the___________ bar.
A. address
B. menu.
C. link.
D. browser.
Answer:
A.address
226. A_________ engine is a software program used by a search site to retrieve webpages from a search database that match certain criteria.
A. multimedia.
B. virtual.
C. serf.
D. search.
Answer:
D.search.
227. _________ is a software program that secretly collects information and monitors your actions without your knowledge.
A. ad ware.
B. freeware.
C. spy ware.
D. hidden ware
Answer:
C.spy ware.
228. Electronic mail cannot be used for______________.
A. scanning pictures.
B. sending documents.
C. sending attachments.
D. sending messages
Answer:
A.scanning pictures.
229. ___________ is a type of Internet connection in which the PC must connect to a service provider using standard telephone lines.
A. HTTP.
B. wireless.
C. DSL.
D. dial-up.
Answer:
D.dial-up.
230. The Internet began as an experimental network called as_______________.
A. extranet
B. ARPANET.
C. milnet.
D. infranet.
Answer:
B.arpanet.
231. A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
A. mail.
B. buddy.
C. chat.
D. message.
Answer:
C.chat.
232. A_________ is a software program used for viewing various kinds of Internet resources found on the World Wide Web.
A. bookmark.
B. intranet.
C. domain.
D. browser.
Answer:
D.browser.
233. . Where is the Internet's central hub and control center located?
A. near Washington d.c.
B. near the Microsoft campus in Redmond Washington.
C. in a top-secret location.
D. in silicon valley.
Answer:
B.near the Microsoft campus in Redmond Washington.
234. Which of these domains is restricted to qualified organizations?
A. .com
B. .org
C. .net
D. .edu
Answer:
C..net
235. Which of these services would you probably not be able to get from a typical internet service provider (ISP)?
A. an email address.
B. access to a web server.
C. a connection to the internet.
D. technical help.
Answer:
D.technical help.
236. The first Web pages were____________.
A. strictly hypertext with no multimedia content.
B. designed to simulate printed pages using html table tools.
C. the first true multimedia documents to be published on the internet.
D. viewable only with proprietary microsoft software.
Answer:
B.designed to simulate printed pages using html table tools.
237. What do you call software that prevents certain Web pages from being displayed?
A. child-safe software.
B. dutch dike software.
C. filtering software.
D. spam blockers.
Answer:
D.spam blockers.
238. ____________ ensures the privacy and confidentiality in electronic messages.
A. client-server security.
B. data and transaction security.
C. software security holes.
D. physical security holes.
Answer:
B.data and transaction security.
239. One major threat to data security is unauthorized network monitoring is alsocalled as_____________.
A. packet sniffing.
B. message security.
C. message confidentiality.
D. system integrity.
Answer:
A.packet sniffing.
240. DES stands for____________.
A. data encryption standard.
B. data encryption system.
C. data enabling system.
D. data enabled system.
Answer:
A.data encryption standard.
241. DSA stands for______________.
A. digital signature algorithm.
B. digital system architecture.
C. digital system analysis.
D. digital signature
Answer:
A.digital signature algorithm.
242. MAN stands for……………
A. metropolitan area network
B. mass area network
C. middle area network
D. maximum area network
Answer:
A.metropolitan area network
243. Trojan Horse is a—————
A. accounting software
B. search engine
C. portal
D. none of these
Answer:
D.none of these
244. ISDN stands for ____.
A. integrated standard digital network.
B. integrated service digital networking
C. integrated service digital network.
D. independent standard digital
Answer:
C.integrated service digital network.
245. ATM is a service that can run over____.
A. sonet.
B. sdh.
C. b-ISDN.
D. isdn
Answer:
C.b-ISDN.
246. If a computer on the network shares resources for others to use, it is called ____.
A. server.
B. client.
C. mainframe.
D. super.
Answer:
A.server.
247. Who is the father of the internet?
A. Charles Babbage
B. Tim Burners lee
C. Winton Serf
D. Simur Cray
Answer:
C.Winton Serf
248. …………. is a word processing application from Microsoft
A. MS Office
B. MS Access
C. MS Excel
D. None of the above
Answer:
D.None of the above
249. A ____________ is a small program that helps to automate a frequently used series of commands in most productivity software tools.
A. Macro
B. Utility
C. Template
D. Wizard
Answer:
A.Macro
250. Which of the following button will allow you to add, delete, or change records in your Data Source?
A. ‘Edit’ button
B. ‘Data editing’ button
C. ‘Data Source’ button
D. ‘Edit Data Source’ button
Answer:
D.‘Edit Data Source’ button
251. Which function will you use to enter current time in a worksheet cell?
A. =today()
B. =now()
C. =time()
D. =current Time()
Answer:
C.=time()
252. Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can beapplied from
A. from Format >> Cells
B. from Format >> Auto format
C. from Table >> Auto format
D. All of above
Answer:
B.from Format >> Auto format
253. Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set conditions to look for Bold and apply Italics on them.
C. You can apply Font, border, and pattern formats that meet the specified conditions
D. You can delete any condition from the Conditional Formatting dialog box if
Answer:
C.You can apply Font, border, and pattern formats that meet the specified conditions.
254. By default, Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A. Right-click on Sheet Tab of the third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
Answer:
A.Right click on Sheet Tab of the third sheet and choose Delete from the context menu
255. While finding and replacing some data in Excel, which of the following statement is valid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have the option to match cases to find
C. Both are valid
D. None are valid
Answer:
A.You can Find and Replace within the sheet or workbook
256. What PowerPoint feature will you use to apply motion effects to different objects of a slide?
A. Slide Transition
B. Slide Design
C. Animation Objects
D. Animation Scheme
Answer:
D.Animation Scheme
257. The difference between Slide Design and Auto Content Wizard is
A. Both are the same
B. Auto content Wizard is just the wizard version of Slide Design
C. Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
D. Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices
Answer:
C.Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
258. Which menu provides you options like Animation Scheme, custom Animation, SlideTransition?
A. Insert Menu
B. Format Menu
C. Tools Menu
D. Slide Show Menu
Answer:
D.Slide Show Menu
259. What happens if you select the first and second slide and then click on the New Slide button on the toolbar?
A. A new slide is inserted as the first slide in the presentation
B. A new slide is inserted as a second slide in the presentation
C. A new slide is inserted as the third slide in the presentation
D. None of above
Answer:
C.A new slide is inserted as the third slide in the presentation
260. Which of the following font effect is not available in the PowerPoint Font dialog box?
A. Underline
B. Shadow
C. Emboss
D. Strikethrough
Answer:
D.Strikethrough
261. Material consisting of text and numbers is best presented as
A. A table slide
B. A bullet slide
C. A title slide
D. none
Answer:
A.A table slide
262. Which of the following should you use if you want all the slides in the presentation to have the same “look”?
A. the slide layout option
B. add a slide option
C. outline view
D. a presentation design template
Answer:
D.a presentation design template
263. If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an)
A. Inclusion
B. Attachment
C. Reply
D. Forward
Answer:
B.Attachment
264. Which of the following toolbars provide different options in various master views?
A. Common tasks toolbar
B. Drawing toolbar
C. Formatting toolbar
D. Standard toolbar
Answer:
A.Common tasks toolbar
265. ———- is a method to find a specific value of a cell by adjusting the value of another cell.
A. Goal seek
B. Scenario manager
C. Data table
D. Macro
Answer:
A.Goal seek
266. Answer: groups may have a __________ who monitors the postings and enforces the site’s rules.
A. judge
B. sysop
C. narrator
D. censor
Answer:
B.sysop
267. _______ refers to using the small portable and hand held computing devices such as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless-enabled network.
A. Personal computing
B. Digital computing.
C. Network computing.
D. Mobile computing.
Answer:
D.Mobile computing.
268. A___________ identifies a user’s personal preferences and settings and allows the website’s server to retrieve your information from its database.
A. Cookie.
B. View history.
C. Prototype.
D. Profile.
Answer:
A.Cookie.
269. A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
A. Mail.
B. Buddy.
C. Chat.
D. Message.
Answer:
C.Chat.
270. DSA stands for______________.
A. Digital Signature Algorithm.
B. Digital System architecture.
C. Digital system analysis.
D. Digital Signature Authentication.
Answer:
A.Digital Signature Algorithm.
271. ISDN stands for ____.
A. Integrated Standard Digital Network.
B. Integrated Service Digital Networking
C. Integrated Service Digital Network.
D. Independent Standard Digital Network.
Answer:
C.Integrated Service Digital Network.
272. ATM is a service that can run over____.
A. SONET.
B. SDH.
C. B-ISDN.
D. ISDN.
Answer:
C.B-ISDN.