1. Which toolbar in MS-Word 2013 by default contains three commands - Save, Undo and Redo ?
JOA-IT 913 *
Correct : B
Explanation : The Quick Access toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Redo commands.
2. How wil you select the outline color of a shape in Microsoft Paint ?
JOA-IT 913 *
Correct : B
Explanation: On the Drawing Tools Format tab, click Shape Outline and, under Theme Colors, pick the color you want. Select the shape or text box. On the Drawing Tools Format tab, click Shape Outline, and then click More Outline Colors.
3. What is the shortcut key to Redo the undone the changes in MS Word ?
JOA-IT 913 *
Correct : D
Explanation: To redo the most recent action that you undid in Microsoft Word, you can press CTRL+Y. The Redo button only appears after you've undone an action.
4. Pressing ____ removes character-level formatting from the selected text in MS-Word document.
JOA-IT 913 *
Correct : B
Explanation: To remove character-level formatting from selected text in a Microsoft Word document, you can press Ctrl + Spacebar. This removes manually applied formatting, but not styles.
5. Which tab in MS Word provides options for table of contents, footnotes and citations ?
JOA-IT 913 *
Correct : A
Explanation: The References tab also allows you to:
Create a table of contents, footnotes, citations, and cross-references.
Select MLA, APA, or ISO formats.
Turn your Works Cited into a collection of records for future use.
Add references to a document and create a bibliography at the end of the text.
Store references in a master list for use in other documents.
Insert a caption below a picture or graphic.
Add a list of captioned objects and their page numbers.
6. APA, Chicago and MLA are Standard
JOA-IT 913 *
Correct : A
Explanation: APA, Chicago, and MLA are three common citation styles.
APA :
The American Psychological Association's (APA) official style is commonly used for citing sources in education, psychology, and the social sciences.
Chicago :
The Chicago Manual of Style is a style guide for American English published by the University of Chicago Press since 1906. MLA :
The Modern Language Association's (MLA) academic style is the standard format for academic papers in the arts and humanities.
7. What is the shortcut key to set line spacing of 1.5 in a MS Word paragraph ?
JOA-IT 913 *
Correct : B
Explanation: To set 1.5 line spacing in Microsoft Word, you can press Ctrl+5. Here are some other keyboard shortcuts for line spacing in Microsoft Word:
Ctrl+2: Sets double line spacing.
Ctrl+1: Sets single line spacing.
Ctrl+Q: Remove paragraph formatting.
8. What is the shortcut key to show 'Replace' dialog in MS Word ?
JOA-IT 913 *
Correct : D
Explanation: Use the shortcut Ctrl+H or navigate to Home>Editing>Replace to reach the Find and Replace dialog box.
9. Which of the following language is used for programming a macro in MS Excel ?
JOA-IT 913 *
Correct : A
Explanation: Visual Basic for Applications (VBA) is the programming language used to create and deploy macros in Excel. VBA is a common programming language used in Microsoft Office applications, including Excel, Word, and PowerPoint.
10. Which is a software tool included with MS Word that provides synonyms for selected words ?
JOA-IT 913 *
Correct : B
Explanation: Thesaurus is a software tool in Microsoft Word that provides synonyms and antonyms for selected words. Thesaurus is generally used when writing emails, letters, project reports, or research papers.
11. By using ___ option while printing more than one copy of a multi-page document, th printer will print all the pages of each copy before printing the next copy ?
JOA-IT 913 *
Correct : B
Explanation : In printing, collate means to arrange printed pages in a specific order or sequence. Collating creates consistent, logical sets from multiple parts. For example, if you need 10 copies of an 8-page booklet, choosing to print collated will give you the 10 copies with the 8 pages already in order.
12. Entering the number 0 in a cell in Excel sheet and formatting it as date will show
JOA-IT 913 *
Correct : D
Explanation: If you enter the number 0 in a cell in an Excel sheet and format it as a date, it will show as January 1st of the current year. By default, Microsoft Excel for Windows uses the 1900 date system, which means the first date is January 1, 1900.
13. Which of the following is not a valid type for a table field in MS Access 2013 ?
JOA-IT 913 *
Correct : A
Explanation: Here are some valid data types for table fields in MS Access: Large number, Date/time, Date/time extended, Currency. The Hyperlink data type in Microsoft Access is a composite data type that can link websites, email addresses, and files on a computer.
14. Two type of table views in MS Access are ____ and Design View.
JOA-IT 913 *
Correct : C
Explanation: The two table views in Microsoft Access are Design View and Datasheet View. To open a table in Datasheet View, locate the table in the Navigation Pane and double click, or right click and choose Open. To open a table in Design View, locate the table in the Navigation pane and right click then choose Design View.
15. How will you find the data fields beginning with letters 'A' and 'B' by using "Find and Replace" dialog box in the datasheet view of a table in MS Access ?
JOA-IT 913 *
Correct : D
Explanation:
16. Which of the following field types in an MS Access table is readonly ?
JOA-IT 913 *
Correct : D
Explanation: A read-only field in Microsoft Access is a form control that is non-editable.
17. A ____ is a powerful tool in Excel to calculate, summarize, and analyze data to find out patterns and trends.
JOA-IT 913 *
Correct : A
Explanation: A PivotTable is a tool in Excel that can calculate, summarize, and analyze data to find patterns and trends. PivotTables are interactive and can summarize large amounts of data quickly. They can also help users answer questions about their data. To use Pivot option - Go to Insert > PivotTable.
18. In an Excel sheet, the cell A2 contains a data value of 10-Dec-2021, then what will be the value returned by the formula '=text(A2,'dddd')' ?
JOA-IT 913 *
Correct : B
Explanation: In Excel, dddd is a custom format that displays the full name of the day of the week. The formula =TEXT(A2, "dddd") in Excel is used to extract the day (Which is friday) of the week from a date.
19. The cell A1 in a certain MS Excel sheet contains the value 212, what will be value returned by formaula =ceiling(A1,5) ?
JOA-IT 913 *
Correct : D
Explanation: The Excel CEILING function rounds a number up to a given multiple. It's a built-in function in Excel that's categorized as a Math/Trig Function. It has the same syntax as the FLOOR function, but the FLOOR function is used to round down the number, whereas the CEILING function rounds up the number.
20. What will be value returned by MS Excel formula ''=BASE(212,2,8)' ?
JOA-IT 913 *
Correct : D
Explanation: In Microsoft Excel, the BASE function is used to convert a number into a text representation with a specified base. In the formula =BASE(212, 2, 8), the arguments are as follows: number: 212, radix: 2 (binary), minimum_length: 8