1. What will be value returned by MS Excel formula '=convert(102,'in','ft')' ?
JOA-IT 913 *
Correct : C
Explanation: In Microsoft Excel, the CONVERT function is used to convert a measurement from one unit to another. n the formula =CONVERT(102, "in", "ft"), the arguments are as follows:
number: 102 (the value to be converted)
from_unit: "in" (inches)
to_unit: "ft" (feet). The conversion factor from inches to feet is 1 foot = 12 inches. Therefore, to convert inches to feet, you divide the number of inches by 12. (102/12=8.5)
2. Consider the following data in Excel sheet : SnoMarks 16 219 38 42 540 624. What will be the value returned by Excel formula '=MEDIAN(B2:B7)' ?
JOA-IT 913 *
Correct : A
Explanation: In the formula =MEDIAN(B2:B7), the argument is the range of cells from B2 to B7, which contains the data: 16, 219, 38, 42, 540, 624. Since there are six numbers, the median is the average of the two middle numbers, which are 42 and 219 (42+219 divided by 2).
3. In MS Excel, a ___ is a sequence of recorded keystrokes and mouse events that can be replayed as many times as one want.
JOA-IT 913 *
Correct : B
Explanation: In MS Excel, a macro is a sequence of recorded keystrokes and mouse events that can be replayed as many times as one want.
Macros can be used to automate repetitive tasks, such as formatting data, creating charts, and generating reports. They can also be used to create custom functions and tools.
4. Which of the following is not a valid cell address in MS Excel ?
JOA-IT 913 *
Correct : A
Explanation: Excel has three types of cell references: relative, absolute, and mixed.
Absolute references: Used to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. Mixed references: If a dollar sign precedes the column or row (but not both), it's known as a mixed reference.
Relative references: A key element of a formula.
5. How many cells are there in the cell range A10 : D30 in MS Excel ?
JOA-IT 913 *
Correct : C
Explanation: The cell range A10:D30 in MS Excel contains 84 cells. A10, B10, C10, D10 also include in this range.
6. Which of the following is not a type of animation in MS PowerPoint ?
JOA-IT 913 *
Correct : A
Explanation: There are four types of animation effects in PowerPoint – entrance, emphasis, exit and motion paths.
7. How will you create a perferct cicle using oval tool in MS PowerPoint ?
JOA-IT 913 *
Correct : C
Explanation: On the Insert tab, click Shapes. Under Basic Shapes, click Oval. Click where you want the oval to start, and drag to draw the shape. To draw a circle, press Shift while you drag.
8. The _____ view show current slide, the next slide, speaer notes and a timer to help the presenter.
JOA-IT 913 *
Correct : D
Explanation: Outline view in PowerPoint displays a presentation as an outline of the titles and main text from each slide. It can help you focus on your text without graphics.
9. The word processing task associated with changing the appearance of a document is
High Court JOA-IT *
Correct : C
Explanation: Formatting is the process of changing the appearance of the text. Depending on the purpose of the document, altering certain formatting elements like backgrounds, lines, margins, or highlighting may be crucial.
10. What is the shortcut key to open the font dialog box in Micorsoft Word ?
JOA-IT 817 *
Correct : C
Explanation: To open the Font dialog box in Microsoft Word, you can use the keyboard shortcut Ctrl+D. This shortcut will open the Font dialog box with the focus on the Font combo box.
11. Font sizes are generally measured in points which is qual to _____ of an inch.
JOA-IT 817 *
Correct : D
Explanation : Font sizes are measured in points, which is equal to 1/72 of an inch. The point size refers to the height of a character. For example, a 12-point font is 1/6 inch in height.
12. MS-Word has tab stops at every _____ inch by default.
JOA-IT 817 *
Correct : A
Explanation: Microsoft Word has tab stops at every 0.5 (1/2)inches by default. This means that each time you press the Tab key, the insertion point will move ahead by 0.5 inches.
13. Which of the following is not a type of section breaks in MS-Word ?
JOA-IT 817 *
Correct : B
Explanation: The different kinds of section breaks are next page, continuous, even page, and odd page breaks.
14. Which of the following tabs in MS-Word contains the option to insert footnotes ?
JOA-IT 817 *
Correct : C
Explanation: The References tab in Microsoft Word contains :
Table of Contents, Footnotes, Citations & Bibliography, Captions, Index, Table of Authorities.
15. How can you use different page orientations in the same word document ?
JOA-IT 817 *
Correct : A
Explanation: Set different page orientations: Insert a section break to change the orientation of multiple pages:
Open the Layout tab
Click on Breaks on the drop-down arrow
Choose Next Page
On the Layout tab, click on the Orientation drop-down arrow to choose the landscape format
16. What is the shortcut key to set the paragraph line spacing to 1.5 in MS-Word document ?
JOA-IT 817 *
Correct : C
Explanation: Here are some other keyboard shortcuts for changing line spacing in Microsoft Word:
Ctrl+1: Sets single-line spacing
Ctrl+2: Sets double-line spacing
Ctrl+5: Apply 1.5-line spacing to the paragraph.
Ctrl+0: Add or remove space before the paragraph.
17. Which of the following features of MS-Word lets you create personalized letters to a number of recipients with different names and address ?
JOA-IT 817 *
Correct : B
Explanation: A macro in Microsoft Word is a recorded sequence of commands or actions that can be used to automate repetitive tasks. Macros can be used to perform various tasks within a document, such as formatting text, applying styles, and inserting content.
18. What is the key combination used to insert a new line character in the text of a cell in MS-Excel worksheet ?
JOA-IT 817 *
Correct : A
Explanation: To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break.
19. An array formula can be entered in a cell in MS Excel by entering formula and pressing ______
JOA-IT 817 *
Correct : C
Explanation: To enter an array formula in a cell in Microsoft Excel, you need to enter the formula and then press Ctrl+Shift+Enter. This will automatically change the normal formula into an array formula.
20. Which of the following features is not found in MS-Excel ?