Office Automation Tools Multiple Choice Questions
Part-6
 |
| Office Automation Tools |
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 condition to look for Bold and apply Italics on them.
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if
Answer:
C.You can apply Font, border and pattern formats that meets the specified conditions
254. By default Excel provides 3 worksheets. You need only two of them, how will youdelete the third one?
A. Right click on Sheet Tab of 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 third sheet and choose Delete from the context menu
255. While finding and replacing some data in Excel, which of the following statement isvalid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for 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 aslide?
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 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 first and second slide and then click on New Slide buttonon toolbar?
A. A new slide is inserted as first slide in presentation
B. A new slide is inserted as second slide in presentation
C. A new slide is inserted as third slide in presentation
D. None of above
Answer:
C.A new slide is inserted as third slide in presentation
260. Which of the following font effect is not available in 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 slide in the presentation tohave 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 anotherperson 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 cell by adjusting the value of anothercell.
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 enforcesthe 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 asPDA 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 theweb site’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 messageswhich 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.