Table of Contents
MS WORD AND MS EXCEL QUESTIONS
Computer program to create, edit, and format text documents, you are performing a task known as Word Processing. Part of the Microsoft Office 2013 suite of programs, Microsoft Word 2013 is one of the most sophisticated word processing programs available. By using Word, it is easy to efficiently create a wide range of business and personal documents, from the simplest letter to the most complex report. Word includes many desktop publishing features that you can use to enhance the appearance of documents so that they are visually appealing and easy to read.
Microsoft Word
You can use Word to:
· Create professional-looking documents that incorporate impressive graphics.
· Give documents a consistent look by applying styles and themes that control the font, size, color, and effects of text and the page background.
· Store and reuse pre-formatted elements such as cover pages and sidebars.
· Create personalized mailings to multiple recipients without repetitive typing.
· Make information in long documents accessible by compiling tables of contents, indexes, and bibliographies.
· Coauthor documents with team members.
· Safeguard documents by controlling who can make changes and the types of changes that can be made, as well as by removing personal and confidential information.
Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.
A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers.
MS WORD AND MS EXCEL QUESTIONS – IMPORTANT MCQs
1. What is the common technique to select the entire document by using mouse click.
A. Single click in the selection bar
B. Double click in the selection bar
C. Triple click in the selection bar
D. Double click anywhere on the document
Answer :- C
2. How can you select a sentence by mouse click?
A. Double click on any word
B Single click on the particular sentence
C. Double click on the particular sentence
D. Triple click on the particular sentence
Answer :- B
3. If you want to select a paragraph by mouse click technique, then __________.
A. Click three times in the paragraph/ double click in the select on bar adjacent to the paragraph.
B. Click double times in the paragraph/ three-time click in the selection bar adjacent to the paragraph
C. Click one time in the paragraph/double click in the selection bar adjacent to the paragraph.
D. All of the above
Answer :- A
4. What does the tool tip mean?
A. it is the button name
B. it is the tool name
C. it is the menu name
D. it is the another name of toolbar
Answer :- A
5. Which one of the following is not the measuring unit of the font size?
A. Pica
B. Unit
C. Both A & B
D. None of the above
Answer :- C
6. The key feature of for mating text in MS Word is
A. Table
B. Style
C. Font
D. None of the above
Answer :- B
7. There are four kinds of tabs that control the alignment of the text within a document. Find out which one is not a name of the tab
A. Bar tab
B. Center tab
C. Decimal tab
D. Binary tab
Answer :- D
8. What does the ‘L’ symbol indicates to the left of the ruler?
A. the ‘L’ Symbol denotes a center tab
B. the L’ Symbol denotes start point of text
C. the ‘L’ Symbol denotes a flush left-tab
D. the L’ Symbol denotes a flush right-tab
Answer :- B
9. What would be the symbol if you want to use the center tab?
A. Bakward ‘L’ symbol
B. ‘L’ Symbol
C. Inverted ‘T’ symbol
D. None of the above
Answer :- C
10. If we use inverted T with a dot on the right side, what kind of tab does this represent?
A. a standard tab
B. a flush right tab
C. a decimial tab
D. a flush left tab
ALSO WATCH : MS WORD AND MS EXCEL questions
Answer :- C
11. As text editor are used at the MS-word and are used in MS-Excel.
A. work space
B work sheet
C. work area
D. none of the above
Answer :- B
12. Which of the following is not a toggle key?
A. Num lock key
B. Caps lock key
C. Both (A) & (B)
D. Ctrl key
Answer :- D
13. What is the total number of rows in MS Excel?
A. 65536
B. More than 7000
C. 63536
D. 65556
Answer :- B
14. Starting letter of the column is ‘A’, What would be the end letter?
A. Z
B. VI
C. XFD
D. IV
Answer :- C
15. What location would be described by the cell E12?
A column E on row 12
B. column 12 on row E
C. column E
D. All of the above
Answer :- A
16. What is the function of fill handle in MS Excel?
A. used to fill data automatically in cell
B. used to set up entry key directive
C. used to make numeric entry
D. used to create shortcut key
Answer :- A
17. One important function of MS-excels over MS-word is
A. Formating numerals
B. Decimal alignment
C. Mathematical calculation
D. Font Selection
Answer :- B
18. Ms-excel record cell addresses in formula. in three different ways, they are and mixed.
A. Column, Row
B. Module, Relative
C. Absolute, Module
D. Absolute, Relative
Answer :- D
19. Charts can be of two types. They are _____ and _______
A. Embedded chart, Chart sheet
B. Embedded chart, Chart area
C. Both A & B
D. None of the above
Answer :- A
20. MS-Excel offers ______ different chart types.
A. 11
B. 15
C. 20
D. 25
Answer :- A
ALSO WATCH : MS WORD AND MS EXCEL questions
ALSO VISIT: COMPUTER AWARENESS MCQs