Office Automation Tools Set 11

Bachelor of Commerce (B Com)

Practice Mode Previous
On This Page

This set of Office Automation Tools Multiple Choice Questions & Answers (MCQs) focuses on Office Automation Tools Set 11

Q1 | Which function will you use to enter current time in a worksheet cell?
  • 44711
  • 44711.89343
  • 0
  • 0
Answer: 0
Q2 | Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can beapplied from
  • from Format >> Cells
  • from Format >> Auto format
  • from Table >> Auto format
  • All of above
Answer: from Format >> Auto format
Q3 | Which of the following is not true regarding Conditional Formatting?
  • You can add more than one condition to check
  • You can set condition to look for Bold and apply Italics on them.
  • You can apply Font, border and pattern formats that meets the specified conditions
  • You can delete any condition from Conditional Formatting dialog box if
Answer: You can apply Font, border and pattern formats that meets the specified conditions
Q4 | By default Excel provides 3 worksheets. You need only two of them, how will youdelete the third one?
  • Right click on Sheet Tab of third sheet and choose Delete from the context menu
  • Click on Sheet 3 and from Edit menu choose Delete
  • Both of above
  • None of above
Answer: Right click on Sheet Tab of third sheet and choose Delete from the context menu
Q5 | While finding and replacing some data in Excel, which of the following statement isvalid?
  • You can Find and Replace within the sheet or workbook
  • Excel does not have option to match case for find
  • Both are valid
  • None are valid
Answer: You can Find and Replace within the sheet or workbook
Q6 | What PowerPoint feature will you use to apply motion effects to different objects of aslide?
  • Slide Transition
  • Slide Design
  • Animation Objects
  • Animation Scheme
Answer: Animation Scheme
Q7 | The difference between Slide Design and Auto Content Wizard is
  • Both are same
  • Auto content Wizard is just the wizard version of Slide Design
  • Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
  • Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices
Answer: Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
Q8 | Which menu provides you options like Animation Scheme, custom Animation, SlideTransition?
  • Insert Menu
  • Format Menu
  • Tools Menu
  • Slide Show Menu
Answer: Slide Show Menu
Q9 | What happens if you select first and second slide and then click on New Slide buttonon toolbar?
  • A new slide is inserted as first slide in presentation
  • A new slide is inserted as second slide in presentation
  • A new slide is inserted as third slide in presentation
  • None of above
Answer: A new slide is inserted as third slide in presentation
Q10 | Which of the following font effect is not available in PowerPoint Font dialog box?
  • Underline
  • Shadow
  • Emboss
  • Strikethrough
Answer: Strikethrough
Q11 | Material consisting of text and numbers is best presented as
  • A table slide
  • A bullet slide
  • A title slide
  • none
Answer: A table slide
Q12 | Which of the following should you use if you want all the slide in the presentation tohave the same “look”?
  • the slide layout option
  • add a slide option
  • outline view
  • a presentation design template
Answer: a presentation design template
Q13 | 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)
  • Inclusion
  • Attachment
  • Reply
  • Forward
Answer: Attachment
Q14 | Which of the following toolbars provide different options in various master views?
  • Common tasks toolbar
  • Drawing toolbar
  • Formatting toolbar
  • Standard toolbar
Answer: Common tasks toolbar
Q15 | ---------- is a method to find a specific value of cell by adjusting the value of anothercell.
  • Goal seek
  • Scenario manager
  • Data table
  • Macro
Answer: Goal seek
Q16 | Discussion groups may have a __________ who monitors the postings and enforcesthe site’s rules.
  • judge
  • sysop
  • narrator
  • censor
Answer: sysop
Q17 | _______ 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.
  • Personal computing
  • Digital computing.
  • Network computing.
  • Mobile computing.
Answer: Mobile computing.
Q18 | A___________ identifies a user’s personal preferences and settings and allows theweb site's server to retrieve your information from its database.
  • Cookie.
  • View history.
  • Prototype.
  • Profile.
Answer: Cookie.
Q19 | A_____ room or online forum allows users to communicate through typed messageswhich are displayed almost instantly.
  • Mail.
  • Buddy.
  • Chat.
  • Message.
Answer: Chat.
Q20 | DSA stands for______________.
  • Digital Signature Algorithm.
  • Digital System architecture.
  • Digital system analysis.
  • Digital Signature Authentication.
Answer: Digital Signature Algorithm.
Q21 | ISDN stands for ____.
  • Integrated Standard Digital Network.
  • Integrated Service Digital Networking
  • Integrated Service Digital Network.
  • Independent Standard Digital Network.
Answer: Integrated Service Digital Network.
Q22 | ATM is a service that can run over____.
  • SONET.
  • SDH.
  • B-ISDN.
  • ISDN.
Answer: B-ISDN.
Previous