MCQ of Microsoft Word - Set 2nd

Multiple Choice Questions of Microsoft Word - Set 2nd

This is the 2nd set of Multiple Choice Questions in the category of Microsoft Word. In this set there are 10 MCQ Questions related to Microsoft Word and four options for each questions but only one options is the correct answer. Correct answers of these Questions are BOLDED.

After learning all the Answers Please try to attempt a FREE Online Exam on it.

IBPS-1-1.Single spacing in MS-WORD document causes ____ point line spacing? 

A. 10 

B. 12 

C. 14 

D. 16 

IBPS-2-2. What would you choose to display the statistics about a document? 

A. tools, word count 

B. insert, statistics 

C. tools, spelling and grammar 

D. tools, statistics 

IBPS-2-3. Which feature do you use to create a newspaper like document? 

A. Bullets & numbering 

B. Tables 

C. Columns

D. Tab stops 

IBPS-2-4. Which would you choose to list Synonyms & Antonyms of a selected word? 

A. Tools, Spelling & Grammar 

B. Tools, Language 

C. Tools, Options 

D. Insert, Cross-reference 

IBPS-2-5. Which language does MS-Word use to create Macros? 

A. Visual C++ 

B. Visual Basic 

C. FoxPro 

D. Access 

IBPS-2-6. What do you call ‘a collection of character and paragraph formatting commands’?

A. the defaults 

B. a template 

C. a style 

D. a boilerplate 

IBPS-2-7. In MS Word, Ctrl+S is for ….. 

A. Scenarios 

B. Size 

C. Save 

D. Spelling Check 

IBPS-2-8. Which key is used to increase left indent? 

A. Ctrl+I 

B. Ctrl+M 

C. Alt+I 

D. F10 

IBPS-2-9. Which key is used to select all the text in the document? 

A. Ctrl+T 

B. Ctrl+A 

C. Ctrl+F 

D. Ctrl+N 

IBPS-2-10. To undo the last work, press ….. 

A. Ctrl+U 

B. Ctrl+Y 

C. Ctrl+Z 

D. Ctrl+W 

IBPS-2-11. To Redo the last work, press ….. 

A. Ctrl+U 

B. Ctrl+Y 

C. Ctrl+Z 

D. Ctrl+W 

After learning all the Answers Please try to attempt a FREE Online Exam on it.

MCQ of Microsoft Excel Set-1st

Multiple Choice Questions of Microsoft Excel - Set 1st

 This is 1st set of Multiple Choice Questions in the category of Microsoft Excel. In this set there are 10 MCQ Questions related to Microsoft Excel and four options for each questions but only one options is the correct answer. Correct answers of these Questions are BOLDEN.

 

IBPS-1-1. Which of the following is correct syntax in Excel?

A. =IF(LogicalTest, TrueResult, FalseResult)

B. =IF(LogicalTest, (TrueResult, FalseResult))

C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

 

IBPS-1-2. Which of the following is correct?

A. =POWER(2^3)

B. =POWER(2,3)

 C. =POWER(2#3)

D. =POWER(2*3)

 

IBPS-1-3. Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?

A. 2 Rows will be inserted after Row 4

B. 2 Rows will be inserted after Row 5

C. 2 Rows will be inserted after Row 6

D. 2 Rows will be inserted after Row 7

 

IBPS-1-4. If 4/6 entered in a cell without applying any formats, Excel will treat this as

A. Fraction

B. Number

C. Text

 D. Date

 

IBPS-1-5. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?

 A. =A1 + “@” + B1

B. =A1 # “@” # B1

C. =A1 & “@” & B1

D. =A1 $ “@” $ B1

IBPS-1-6. How to fit long texts in a single cell with multiple lines?

A. Start typing in the cell and press the Enter key to start another line

B. Use the Wrap Text option in the Format -> Alignment menu

C. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu

D. All of above

 

IBPS-1-7. If particular workbook have to open each time Excel started, where that workbook should be placed?

A. AUTOEXEC Folder

B. AUTOSTART Folder

C. EXCELSTART Folder

D. XLSTART Folder

 

IBPS-1-8. If the cell B1 contains the formula = $A$1, which of the following statements is true

A. There is a relative reference to cell A1

B. There is an absolute reference to cell A1

C. Further changes in value of A1 will not affect the value of B1

D. Further changes in value of B1 will affect the value of A1

 

IBPS-1-9. Worksheet can be renamed by

A. Adding ? symbol at the end of filename while saving workbook

B. Click on Worksheet tab by Holding CTRL Key and type new name

C. Double Click on the Worksheet tab and type new name

D. Worksheet cannot renamed

 

IBPS-1-10. What is the shortcut key to hide entire row?

 A. CTRL + H

B. CTRL + R

C. CTRL + 9

D. CTRL + -