Office Automation MCQ With Answers

44 Questions | By Intranetcomputr | Updated: Sep 5, 2022 | Attempts: 12806

Questions

Settings

Office Automation MCQ With Answers - Quiz

Do you know how to use Microsoft Office? If yes, then it's time that you should test your skills with the office automation MCQ quiz that is given below. This quiz consists of questions that are based on the applications and tools used in the Microsoft office software. You should try your hands on this quiz and see how well you understand this popular software. So, are you ready to try it? Let's start then.

Questions and Answers

1.

Which of the following is not a font style ?
- A.
  
  Bold
- B.
  
  Italic
- C.
  
  Superscript
- D.
  
  None of the above
2.

What is name box used for?
- A.
  
  To name a cell
- B.
  
  To create a new sheet in the workbook
- C.
  
  To jump to a cell
- D.
  
  To rearrange the names of the cells automatically after adjustments
3.

In MS-Word, for what does ruler help?
- A.
  
  To set indents
- B.
  
  To set tabs
- C.
  
  To change page margins
- D.
  
  All of the above
4.

You can detect spelling and grammar error by
- A.
  
  Press Shift+F7
- B.
  
  Press F7
- C.
  
  Press Ctrl+F7
- D.
  
  Press Alt+F7
5.

What is meant by Drop Cap ?
- A.
  
  Small Cap
- B.
  
  All Caps
- C.
  
  Title case
- D.
  
  None of the above
6.

Border can be applied to
- A.
  
  Cell
- B.
  
  Paragraph
- C.
  
  Text
- D.
  
  All of the Above
7.

Which two tabs will appear on the ribbon bar when you are editing the (contents of) a table in Word 2010?
- A.
  
  Compatibility and Drawing
- B.
  
  Drawing and Preview
- C.
  
  Design and Layout
- D.
  
  Design and Compatibility
8.

You do not like the style which Word 2010 uses as default. Is it possible to change it?
- A.
  
  Yes
- B.
  
  No
- C.
  
  Only on Windows 7
- D.
  
  Depends on the Edition
9.

Which of the following is not a document types which the mail merge wizard will work with?
- A.
  
  Letter
- B.
  
  Directory Email Message
- C.
  
  Catalogue
- D.
  
  Insert Merge Field
10.

___________is called as Brain of Computer.
- A.
  
  Hard Disk
- B.
  
  Central Processing Unit
- C.
  
  Random Access Memory
- D.
  
  DVD
11.

How do you resize a 'shape'?
- A.
  
  Drag the shape
- B.
  
  Select the shape and drag the boundary / corner
- C.
  
  Select the shape and drag the 'green' dot which appears linked above the shape.
- D.
  
  Right click the shape and select 'move'.
12.

Which of the following can be inserted into a Word 2010 document as a table directly?
- A.
  
  Impress presentation
- B.
  
  Calc Spreadsheet
- C.
  
  Excel Spreadsheet
- D.
  
  Assembly source file
13.

1 GB =bytes ?
- A.
  
  1042 tera Bytes
- B.
  
  1024 mega bytes
- C.
  
  1024 kilo byte
- D.
  
  8 bit
14.

Which menu in MSWord can be used to change page size & typeface?
- A.
  
  View
- B.
  
  Format
- C.
  
  Tools
- D.
  
  Data
15.

Which bar is usually located below that Title Bar that provides categorized options?
- A.
  
  Status Bar
- B.
  
  Menu bar
- C.
  
  Tool bar
- D.
  
  Scroll bar
16.

With which chart type(s) is the "Depth Gridlines" option available?
- A.
  
  Bubble chart
- B.
  
  Line chart
- C.
  
  True 3D chart
- D.
  
  All of the above
17.

What will the "New Window" button on the 'View' Ribbon do?
- A.
  
  Create a new window with the default starting template for Word 2010
- B.
  
  Create a new window with the same content as the present window which can be used for 'side by side' view
- C.
  
  Create a new window with a new blank document
- D.
  
  Save the current document and open its read-only version again
18.

An Excel Workbook is a collection of?
- A.
  
  Worksheets
- B.
  
  Worksheets and Charts
- C.
  
  Charts
- D.
  
  Workbooks
19.

In H2O the figure 2 is appeared lower Which effect has been applied?
- A.
  
  Lowered
- B.
  
  Superscript
- C.
  
  Subscript
- D.
  
  Laid down
20.

What is the purpose of using headers and footers in a document?
- A.
  
  They enhance the overall appearance of the document
- B.
  
  To make large document more readable.
- C.
  
  They allow page headers and footers to appear on document when it is printed
- D.
  
  To mark the starting and ending of a page.
21.

Data can be arranged in ascending or descending order by using?
- A.
  
  Sort command from Table menu
- B.
  
  Sort command from Data menu
- C.
  
  Sort command from Tools menu
- D.
  
  None of these
22.

Which among the following chart types do not have axes?
- A.
  
  Doughnut charts
- B.
  
  XY (Scatter) charts
- C.
  
  Bar charts
- D.
  
  Area charts
23.

To select multiple non-adjacent cells in a worksheet you will click them holding?
- A.
  
  Ctrl+Shift key
- B.
  
  Shift Key
- C.
  
  CTRL key
- D.
  
  ALT key
24.

Which of the following component displays the contents of active cell?
- A.
  
  Name box
- B.
  
  Formula bar
- C.
  
  Menu bar
- D.
  
  Status bar
25.

Short cut to insert current date in word?
- A.
  
  Ctrl+d
- B.
  
  Alt+shift+d
- C.
  
  Ctrl+shift+d
- D.
  
  Shift+d