Previous Year Computer MS Office MCQ for SSC and Bank All other Competitive Exam
01. Which of the following statement(s) about Quick Access Toolbar in MS-Word 2010 is/are incorrect? (SSC CGL 2022)
P: The Quick Access Toolbar has save, Undo, and Redo buttons by default.
Q: The Quick Access Toolbar has cut, Undo, and Redo buttons by default.
R: You can place more buttons on the Quick Access toolbar.
S: There is no option on Quick Access toolbar for “show below the Ribbon”.
- Only Q and R
- Only Q and S
- Only P, Q, R
- All P,Q, R, S
Explanation: – The Quick Access Toolbar in MS-Word 2010 has save, undo, and redo buttons by default. You can also place more buttons on the Quick Access toolbar. However, there is no option on Quick Access toolbar for “show below the Ribbon”.
Computer MS Office MCQ for SSC and Bank Exam
02. Consider the following statements regarding line spacing of a paragraph in MS-Word 2010 :-(SSC CGL 2022)
P: Line spacing determines the amount of vertical space between lines of text paragraph.
Q: Line spacing determines the amount of diagonal space between lines of text paragraph.
Which of the following statement(s) is/are correct?
- Only p
- Both p and Q
- Neither P nor Q
- Only Q
Explanation: – Line spacing in MS-Word 2010 determines the amount of vertical space between lines of text in a paragraph. It does not determine the amount of diagonal space between lines of text in a paragraph.
Computer MS Office MCQ for SSC and Bank Exam
03. Which of the following font effects is not available in the MS-Word 2010 font dialog box? (SSC CGL 2022)
- Superscript
- Small Cap
- Double Strikethrough
- Equalize Character Height
Explanation: – The font effects available in the MS-Word 2010 font dialog box are: Bold, Italic, Underline, Strikethrough, Subscript, Superscript, Shadow, Outline, Emboss, Engrave, Small Caps, & All Caps
The Equalize Character Height font effect is not available in the MS-Word 2010 font dialog box. This font effect is available in other Microsoft Office applications, such as PowerPoint and Excel.
Computer MS Office MCQ for SSC and Bank Exam
04. Which of the following buttons are present in the Quick Access Toolbar by default in MS-Word 2010? (SSC CGL 2022)
- Undo, Redo, Name
- Undo, Redo, Cut
- Paste, Redo, Copy
- Save, Undo, Redo
Explanation: – In MS Word 2010, the Quick Access Toolbar, by default, contains three buttons:
Save: This button allows you to quickly save your document.
Undo: This button lets you undo the last action you performed in the document.
Redo: This button allows you to redo an action that you previously undid using the “Undo” button.
Computer MS Office MCQ for SSC and Bank Exam
05. Which among the following keyboard shortcuts is used to insert a hyperlink for the selected text in Microsoft World? (SSC CGL 2022)
- Ctrl + K
- Ctrl + M
- Ctrl + H
- Ctrl + Z
Explanation: –The keyboard shortcut to insert a hyperlink for the selected text in Microsoft Word is Ctrl + K.
Ctrl + M is used to insert a manual page break in Microsoft Word.
Ctrl + H is used to open the Find and Replace dialog box in Microsoft Word.
Ctrl + Z is used to undo the last action in Microsoft Word.
Computer MS Office MCQ for SSC and Bank Exam
06. Which of the following option of print setting is used to choose only specific pages in MS-word 365? (SSC CGL 2022)
- Print All Pages
- Print Current Page
- Print Selection
- Custom Print
Explanation:- In MS Word 365, the option “Custom Print” allows you to specify which pages you want to print from the document. Using this option, you can enter the page range or specific page numbers you wish to print.
Computer MS Office MCQ for SSC and Bank Exam
07. Shading option in Ms-word 365 is used for ____. (SSC CGL 2022)
- Changing the color around the selected text
- Changing the color behind the selected text
- Changing the color of the selected text
- Making the text pop by highlighting it
Explanation: – In MS Word 365, the “Shading” option is used for changing the color behind the selected text. It allows you to add background color or shading to selected text or paragraphs. This feature is often used to highlight important information, create visually appealing documents, or add emphasis to specific sections of the text.
Computer MS Office MCQ for SSC and Bank Exam
08. Which of the following keyboard short cut is used to close a MS-Word 365 document? (SSC CGL 2022)
- Ctrl + F3
- Alt + F3
- Alt + F4
- Shift + F5
Explanation: – The keyboard shortcut Alt + F4 is used to close a MS-Word 365 document. It can also be used to close other Windows applications.
The other options are not used to close MS-Word 365 documents. Ctrl + F3 is used to find the next instance of a word or phrase, Alt + F3 is used to create a macro, and Shift + F5 is used to repeat the last action.
Computer MS Office MCQ for SSC and Bank Exam
09. In MS-Word 365, Ctrl + E is the keyboard shortcut to ____. (SSC CGL 2022)
- Justify the selected text
- Centre align the selected text
- Right align the selected text
- Display the file menu options
Explanation: – In MS-Word 365, the keyboard shortcut “Ctrl + E” is used to center align the selected text. When you have text selected in a document and you press “Ctrl + E,” the selected text will be aligned to the center of the page or text box.
Computer MS Office MCQ for SSC and Bank Exam
10. Consider the following statement about MATCH() function of MS-Excel 2010: (SSC CGL 2022)
P: It searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Q: The MATCH function syntax is MATCH(lookup_value, lookup_array,
R: All the arguments in a MATCH() function are required.
Which of the following statement(s) is/are true
- Only Q
- All P, Q, R
- Only P and R
- Only P and Q
Explanation: – The MATCH function in MS-Excel 2010 searches for a specified item in a range of cells, and then returns the relative position of that item in the range. The MATCH function syntax is MATCH(lookup_value, lookup_array, [match_type]). The match_type argument is optional, and if it is omitted, the MATCH function will return an exact match.
Statements P and Q are both true. Statement R is false, because the match_type argument is optional.
Computer MS Office MCQ for SSC and Bank Exam
11. What will the function given below return in MS-Excel 2010? (SSC CGL 2022)
=MATCH(12,{10,13,30,40,60},1)
- 0
- 1
- #N/A
- 2
Explanation: – The MATCH function returns the position of a value in a range of cells. The first argument is the value you are looking for, the second argument is the range of cells you are searching, and the third argument is the type of match you want. In this case, the type of match is 1, which means an exact match.
The range of cells in this case is {10,13,30,40,60}. The value 12 is found in the first cell of the range, so the MATCH function will return 1.
The other options are incorrect. Option 2, 0, would be returned if the value 12 was not found in the range of cells. Option 3, #N/A, would be returned if the type of match was not specified. Option 4, 2, would be returned if the type of match was 2, which means an approximate match.
Computer MS Office MCQ for SSC and Bank Exam
12. Which of the following is correct option in MS-Excel 365, if a value in a cell column A and row 10 is to be referred in a function or Formula? (SSC CGL 2022)
- A-10
- 10A
- A10
- A : 10
Explanation: – In Excel, cell references are represented by the combination of the column letter and row number. The letter represents the column, and the number represents the row. So, “A10” refers to the cell located in column A and row 10, and you can use this cell reference in formulas to perform calculations or use the value stored in that specific cell.
Computer MS Office MCQ for SSC and Bank Exam
13. Each cell in the worksheet of MS-Excel 365 is identified by a cell ____. (SSC CGL 2022)
- Color
- Size
- Rounding
- Reference
Explanation: – Each cell in the worksheet of MS-Excel 365 is identified by a cell reference. A cell reference is a combination of a column letter and a row number that uniquely identifies a cell in the worksheet. For example, the cell reference A1 refers to the cell at the intersection of column A and row 1.
The other options are not used to identify cells in MS-Excel 365. Color is used to format cells, size is used to set the size of cells, and rounding is used to round the values in cells.
Computer MS Office MCQ for SSC and Bank Exam
14. Which of the following is Math and Trigonometric functions available in MS-Excel 365? (SSC CGL 2022)
- Text function
- ABS function
- Logical function
- Financial function
Explanation: – ABS is a Math and Trigonometric function available in MS-Excel 365. It is used to return the absolute value of a number. The absolute value of a number is its distance from zero, regardless of its sign.
The other options are not Math and Trigonometric functions. Text functions are used to manipulate text, logical functions are used to test conditions, and financial functions are used to calculate financial data.
Computer MS Office MCQ for SSC and Bank Exam
15. In MS-Excel 365 which of the following appears across the top of the screen and below the title bar and contains all the command, formulas and features needed to create data-intense spreadsheets? (SSC CGL 2022)
- Scroll bars
- Status bar
- Ruler
- Ribbon
Explanation: – In MS-Excel 365, the Ribbon appears across the top of the screen and below the title bar. It contains all the commands, formulas, and features needed to create data-intensive spreadsheets. The Ribbon is organized into tabs, and each tab groups related commands together to make it easier for users to access various functionalities while working in Excel.
Computer MS Office MCQ for SSC and Bank Exam
16. Which of the following shortcut key is used to quickly create a new, blank wordbook in MS-Excel 2010? (SSC CGL 2022)
- Ctrl + N
- Alt + Shift + W
- Alt + Shift + N
- Ctrl + W
Explanation: – The shortcut key used to quickly create a new, blank workbook in MS-Excel 2010 is Ctrl + N.
The other options are not used to create a new workbook in MS-Excel 2010. Alt + Shift + W is used to close the current workbook, Alt + Shift + N is not a valid shortcut key, and Ctrl + W is used to close the current window.
Computer MS Office MCQ for SSC and Bank Exam
17. Which of the following shortcut key is used to select all cells of the current row in MS-Excel 2010 worksheet? (SSC CGL 2022)
- Shift + Page down
- Ctrl + Spacebar
- Shift + Page up
- Shift + + Spacebar
Explanation: – In MS Excel 2010, the shortcut key used to select all cells of the current row is “Ctrl + Spacebar.” This key combination selects the entire row where the active cell is located. Similarly, if you want to select all cells of the current column, you can use “Ctrl + Shift + Spacebar.”
Shift + Page down is used to select all cells from the current cell to the bottom of the worksheet.
Shift + Page up is used to select all cells from the current cell to the top of the worksheet.
Shift + + Spacebar is not a valid shortcut key in MS-Excel 2010.
Computer MS Office MCQ for SSC and Bank Exam
18. Which among the following keyboard shortcuts open the properties for the selected item on a Windows 10 home screen? (SSC CGL 2022)
- Alt + Shift + Spacebar
- Ctrl + Shift + Spacebar
- Alt + Enter
- Ctrl + Enter
Explanation: – The keyboard shortcut Alt + Enter opens the properties for the selected item on a Windows 10 home screen. This shortcut works for any item on the home screen, such as a tile, a folder, or a file.
The other options are not used to open the properties for the selected item on a Windows 10 home screen. Alt + Shift + Spacebar is used to open the context menu for the selected item, Ctrl + Shift + Spacebar is used to switch between different input languages, and Ctrl + Enter is used to send a message in a chat app.
Computer MS Office MCQ for SSC and Bank Exam
19. Which among the following keyboard shortcut can be used to open Windows Explorer? (SSC CGL 2022)
- Windows Key + E
- Windows Key + R
- Windows Key + X
- Windows Key + W
Explanation: – The keyboard shortcut Windows Key + E is used to open Windows Explorer.
The other options are not used to open Windows Explorer. Windows Key + R is used to open the Run dialog box, Windows Key + X is used to open the Power User Menu, and Windows Key + W is used to search for apps and settings.
Computer MS Office MCQ for SSC and Bank Exam
20. Which of the following is keyboard shortcut to reload the current page in Google search engine? (SSC CGL 2022)
- F7
- F5
- F1
- F3
Explanation: – The keyboard shortcut to reload the current page in Google search engine is F5.
F7 is used to open the search settings in Google search engine.
F1 is used to open the help menu in Google search engine.
F3 is used to open the find in page dialog box in Google search engine.
Computer MS Office MCQ for SSC and Bank Exam
21. Which among the following keyboard shortcuts is used to bookmark the current webpage on the web browser? (SSC CGL 2022)
- Ctrl + N
- Ctrl + I
- Ctrl + B
- Ctrl + D
Explanation: – The keyboard shortcut used to bookmark the current webpage on the web browser is Ctrl + D.
Ctrl + N opens a new tab, Ctrl + I opens the developer tools, and Ctrl + B toggles the bold text formatting.
Computer MS Office MCQ for SSC and Bank Exam
22. Which of the following is not a LibreOffice Software Suite program? (SSC CGL 2022)
- LibreOffice Writer
- LibreOffice Excel
- LibreOffice Calc
- LibreOffice Impress
Explanation: – LibreOffice Excel is not a program in the LibreOffice Software Suite. “Excel” is a part of Microsoft Office, and it is a spreadsheet program.