Important MS Office MCQs with Answers for competitive exams preparation.
MS Office MCQs
___________ is used to create layout or formatting changes in a portion of a document.
- Section Break
- Page Break
- Next Page Break
- Text Wrapping
Which shortcut key is used for Justify?
- Ctrl+J
- Ctrl +I
- Shift + J
- None
A ___ is a collection of predefined design elements and color schemes
- Feature
- Hyperlink
- Theme
- None of these
Which option is used to copy formatting from one place and apply it to another?
- Copy
- Copy formatter
- Format painter
- Formatting
Which is not provided in Microsoft package ?
- MS Word
- MS Excel
- MS Team
- None
Which of following you can paste selectively using paste special command______?
- Formats
- Validation
- Formulas
- All of above
In a computer processed data is known as
- Information
- Output
- Information or output
- None
Color and pattern used to fill a closed shape is called?
- Shape
- WordArt
- Fill Style
- Fill Back
What is a Presentation?
- oral communication
- shares factual information
- verbal communication
- All of these
Ctrl + L Shortcut key is used for ______?
- Left Indent
- Left Align
- Increase Left Margin
- Decrease Left Margin
Which of following is not the part of standard office suite?
- Word processor
- data base
- image editor
- file manager
What is the minimum Zoom Percentage in PowerPoint?
- 5%
- 10%
- 400%
- None of these
COR Corel Draw is an example of___________?
- Negative films
- Vector graphics
- Raster graphics or bitmaps
- Color graphics
- None of these
Which short keys are used to “cut selected items” in file menu?
- CTRL+X
- CTRL+A
- CTRL+U
- CTRL+B
Which items are placed at the end of a document
- Footer
- Foot Note
- End Note
- Header
The paste special command lets you copy and paste:
- Multiply the selection by a copied value
- Cell comments
- Formatting options
- The resulting values of a formula instead of the actual formula
A combinational circuit consists of
- Input variables
- Logic gates
- Output variables
- All of these
In MS-Word, for what does ruler help?
- to change page margin
- to set indents
- to set tabs
- All
Member functions in C++ are called:
- Member object
- Method
- Functions
- Interaction
In C++, ‘b’ escape sequence is used for:
- Bold
- Backspace
- Format
- New Line
In C++, ‘f’ escape sequence is used for:
- Return
- Backspace
- Formfeeding
- Cell
There are _____ kinds of casts in standard C++.
- Three
- Four
- Two
- Five
Once a structure variable has been defined, its members can be accessed using something called the:
- Operator
- Dot operator
- Semi colon operator
- Colon operator
The software that contains the core components of the operating system is called:
- Middle
- Function
- Component
- Kernel
Short cut key to saving any document in MS office is ?
- Ctrl+S.
- Ctrl+V.
- Ctrl+C.
- None
Microsoft Office is an example of—–?
- Horizontal market software
- Open source software
- Vertical market software
- Closed source software
If the file saved earlier is edited then
- The name will be needed to be changed
- the length is more than a page; the file will be needed to be saved
- the change will automatically be saved in the file
- it is essential to save the file again to store the change
What is the extension of MS Access?
- .pptx
- accdb
- docx
- xlsx
______ are the horizontal divisions of a worksheet that are identified by numbers:
- Rows
- Columns
- Tables
- Cells
In Windows operating system ——–is known as a file manager
- Windows Explorer
- MS Word
- Device drive
- MS Excel
Press _ for moving text in MS office.
- Ctrl + X
- Ctrl + C
- Ctrl + V
- Ctrl + Y
Page number is inserted in
- Header and footer
- Animation
- Word Art
- None
What are the basic rectangular building blocks of a spreadsheet?
- cells
- zoom slider
- help button
- all
Which of the following is not a term pertaining to spreadsheets?
- cell
- character
- browser
- formula
The default page size for word documents is also used in offices
- A4
- Legal
- Letter
- None
the command used to apply look of one piece of text to other parts of text documents.
- Copy
- Past
- Format Painter
- None of these
Which one cannot be used to enter data in a cell in MS Excel?
- Pressing tab key
- Pressing arrow key
- Pressing Esc key
- clicking the enter button to the formula bar
What is the purpose of inserting header and footer in the document?
- To mark the starting of a page
- To enhance the overall appearance of the document
- To allow page headers and footers to appear on document when it is printed
- To make large document more readable
Which would you choose to move selected text from one place to another?
- copy and paste
- delete and paste
- move and paste
- cut and paste
In which menu can you find features like Slide Design, Slide Layout, etc.?
- Insert Menu
- Format Menu
- Tools Menu
- Slide Show Menu
If you press ____, the cell accepts your typing as its continent?
- tab
- ctrl+enter
- enter
- None
In MS Word 2010, commands are organized into _____ on the Ribbon.
- Groups
- Tabs
- Menus
- Toolbars
Which of the following keys displays the hidden task bar___?
- Ctrl + F2
- Ctrl + Esc
- Ctrl + alt
- Ctrl + F7
- None None of these
What is active cell in MS-Excel ______?
- Rectangular box
- Pointer
- Nearing point of view
- None of the above
MS Word is related to?
- Microsoft
- Hard ware
- Internet
- None
Does MS Office save the Outlook file with an extension?
- .pps
- .ppt
- .pst
- none
In MS Office a feature that saves the document automatically after certain intervals is called :
- Save
- Save As
- Auto save
- None of the above
MS office is ____?
- Application Software
- Compiler
- programming
- none
What is the maximum number of lines you can set for a drop cap?
- 5
- 10
- 15
- 20
Drop Cap option found in which menu?
- Format
- Insert
- Edit
- Tool
- None of these
Why Drop Caps are used in documents in Ms Word?
- To begin a paragraph with a large dropped initial capital letter
- To drop all the capital letters
- To automatically begin each paragraph with capital letter
- None of above
Short cut key for center align
- Shift +v
- Ctrl+a
- Both
- Ctrl+E
What is the shortcut key for spelling to check in document ________ ?
- F1
- F2
- F5
- F7
Hardware performance continues to improve exponentially in the:
- 1970s
- 1980s
- 1990s
- 2000s
Select the correct shortcut key mentioned below which is used to “bold” a written paragraph
- CTRL + T
- CTRL + B
- CTRL + C
- CTRL + P
In MS Word, the ‘watermark’ option is available in ______.
- Design
- Layout
- Insert
- View
Minim and maximum font size in MS Word :
- 8-72
- 6-60
- 12-50
- 8-96
What is the maximum font size you can apply for any character in Ms Word?
- 1638
- 1636
- 1645
- 1600
The ________ option is used to refine the search results ?
- Advanced research
- Research
- Both
- None
Which of these is not shown in Spelling Dialogue Box?
- Change
- Edit
- Ignore
- Ignore All
Which Version of the Microsoft office is not valid?
- office Vista
- Office XP
- Office 2007
- None of these
The amount of vertical space between lines of text in a document is called ____?
- Double-space
- Line spacing
- Single space
- Vertical spacing
Short cut key Ctrl+k is used for ____ .
- Insert link
- Insert hyperlink
- Formate latters
- None of these
The bar at the top of the window that contains the name of Application Software is called __?
- Task bar
- Title bar
- Status bar
- scroll bar
- None of these
Which of these is the page setup orientation by default in the slides in the power point
- Landscape
- Portrait
- Vertical
- None of these
Select the correct shortcut key which is used to underline a written paragraph?
- CTRL + T
- CTRL + U
- CTRL + Z
- CTRL + B
The file extension of Microsoft Word 97 – 2003 is ____ .
- .doc
- .docs
- .docx
- None of the above
What is the smallest and largest font size available in Font Size tool on formatting toolbar?
- Smallest 8 & largest 70
- Smallest 8 & largest 71
- Smallest 8 & largest 72
- Smallest 6 & largest 72
- None of these
In MS Word 2007 which shortcut key is used to insert a comment?
- Alt+Ctrl+M
- Alt+Ctrl+C
- Shift+Ctrl+M
- Shift+Ctrl+C
- None of these
What is the default page orientation in MS-Word?
- Long sides
- Portrait
- Landscape
- Double Long side
Which is not included in a Font Style in MS-Word?
- Bold
- Italic
- Regular
- Superscript
- All of these
In MS-Word, Thesaurus option is available in?
- Reference Tab
- Review Tab
- View Tab
- None of these
Which is the Text Styling feature in MS-Word?
- Word style
- Word design
- Word art
- Design
In MS-Excel ‘cells’ can be uniquely identified by:
- Colum letters and row numbers
- Column numbers and row letters
- Numbers only
- Rows only
Name the application under MS Office software bundle, that we use to create audio visual presentation .
- MS Word
- MS Excel
- MS PowerPoint
- MS Access
Which database object is ideal to view, change and analyze data in different ways?
- Table
- Form
- Query
- Report
By default, footers are printed on ___
- First Page
- Last Page
- All Pages
- Even Pages
In one-to-many relationship, the table in ‘one’ side is called _______
- Child
- Parent
- Brother
- Father
Which data type allows alphanumeric characters and special symbols in ms-access
- Text
- Number
- Auto Number
- Date/ Time
It is used to establish an association between related tables.
- Line
- Relationship
- Primary Key
- Records
Which key uniquely identifies each record in a table
- Foreign key
- Composite key
- Alternate key
- Primary key
The third stage in designing a database is when we analyze our tables more closely and create a ___ between tables?
- Query
- Relationship
- Join
- None of these
In a database table, the category of information is called ______
- Tuple
- Field
- Record
- All of above
Which of the Field has a Width of 8 Bytes?
- Memo
- Number
- Date/time
- Hyperlink
MS Word standard page size which is used in offices is ________
- Legal
- B4
- A4
- None of these
Famous Application Microsoft Office
- PowerPoint
- Excel
- OneDrive
- all of these
Which option is used to copy formatting from one place and apply it to another?
- Copy
- Copy formatter
- Format painter
- Formatting
A ___ is a collection of predefined design elements and color schemes
- Feature
- Hyperlink
- Theme
- None of these
All these MS Office MCQs were taken from past papers of PPSC, FPSC, SPSC, KPPSC, AJKPSC, BPSC, UPSC, PMS, NTS, CSS and other one paper mcqs test preparation.
Read More: Computer MCQs