Top 250+ Solved Office Automation Tools MCQ Questions Answer
Q. If a computer on the network shares resources for others to use, it is called ____.
a. server.
b. client.
c. mainframe.
d. super.
Q. Who is the father of internet?
a. charles babbage
b. tim burners lee
c. winton serf
d. simur cray
Q. ............. is a word processing application from Microsoft
a. Ms Office
b. Ms Access
c. Ms Excel
d. None of the above
Q. A ____________ is a small program that helps to automate a frequently used seriesof commands in most productivity software tools.
a. Macro
b. Utility
c. Template
d. Wizard
Q. Which of the following button will allow you to add, delete, or change records inyour Data Source?
a. ‘Edit’ button
b. ‘Data editing’ button
c. ‘Data Source’ button
d. ‘Edit Data Source’ button
Q. Which function will you use to enter current time in a worksheet cell?
a. =today()
b. =now()
c. =time()
d. =current Time()
Q. 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
Q. 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
Q. 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
Q. 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
Q. 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
Q. 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
Q. Which menu provides you options like Animation Scheme, custom Animation, SlideTransition?
a. Insert Menu
b. Format Menu
c. Tools Menu
d. Slide Show Menu
Q. 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
Q. Which of the following font effect is not available in PowerPoint Font dialog box?
a. Underline
b. Shadow
c. Emboss
d. Strikethrough