1. Assume that you have full names of the employees in one column of MS-Excel sheet. The option ____ lets you split the full names into columns first names and last names.
JOA-IT 817 *
Correct : A
Explanation: The option Text to Columns lets you split the full names into columns first names and last names in an MS-Excel sheet.
To split the full names into separate columns, follow these steps:
Select the column of full names that you want to split.
In the Data tab, click the Text to Columns button.
In the Convert Text to Columns Wizard, select Delimited and then click Next.
Select the delimiter that separates the first and last names. For example, if the full names are separated by a space, select Space.
Click Next.
Select the data format for each column. For example, you can select Text for the first and last name columns.
Click Finish.
2. Which of the following options in MS Excel lets you restrict the value of a cell from a list of values ?
JOA-IT 817 *
Correct : D
Explanation: Data validation is a feature in Microsoft Excel that allows you to restrict the type of data that users can enter into a cell or range of cells. To restrict the value of a cell in Excel:
Select the cells where you want to restrict data entry.
On the Data tab, click Data Validation > Data Validation.
In the Allow box, select the type of data you want to allow and fill in the limiting criteria and values.
In the Allow dropdown select List.
In the Source text box enter Yes,No.
3. Assume that in an MS-Excel sheet, cell A1 contains the value of 10% and the cell A2 contains the value of 5%, then what will be the value of formula =A1*A2 ?
JOA-IT 817 *
Correct : B
Explanation: Here A1 is 10% = 10/100 = 0.1 and A2 is 5% = 5/100 = 0.05. Now A1*A2 = 0.1*0.05 = 0.005
4. Which of the following is correct formula in MS-Excel to round a number in the cell A1 to nearest multiple of 10 ?
JOA-IT 817 *
Correct : D
Explanation: The ROUND function in Excel rounds a number to a specified number of places. The number of places is determined by the number of digits in the second argument. Syntax : =ROUND(number, num_digits). Example : =ROUND(5.86,1) returns 5.9
5. Which of the following features of MS Excel can be used to highlight the marks obtained by the students if the marks are below 10 ?
JOA-IT 817 *
Correct : D
Explanation: To highlight marks in MS Excel that are below 10, you can use the Conditional Formatting feature. Conditional Formatting allows you to apply formatting to cells based on specific criteria. For example, you can use Conditional Formatting to highlight cells that meet certain criteria, such as cells that are greater than or less than a certain value.
6. Which of the following is not a valid cell address in MS Excel ?
JOA-IT 817 *
Correct : C
Explanation: All three ( $A$1, $A1, A$1) are type of Mixed cell reference.
7. which of the following is the correct cell format to display only the month name of the date entered in a cell ?
JOA-IT 817 *
Correct : C
Explanation: In Excel, we can use the "MMMM" or "MMM" format to get the month name from a date.
8. Which of the following funcitons in MS Excel is used to search a value in the leftmost column of a table and returns the corresponding value from another columns in the same row ?
JOA-IT 817 *
Correct : B
Explanation: VLOOKUP stands for "Vertical Lookup". VLOOKUP is commonly used for data retrieval and analysis tasks. It can be used to find data in a sorted or unsorted table.
9. A ----- is a tool in MS Excel to calculate, summarize and analyze data to study patterns and trends in the data.
JOA-IT 817 *
Correct : D
Explanation: A pivot table is a data summarization tool in Microsoft Excel that allows users to analyze large amounts of data by summarizing and reorganizing it. Pivot tables can be used to group data, calculate totals, and generate summary reports. They are often used to analyze sales data, financial data, and customer data. Pivot Table is available in Insert Tab menu.
10. Which feature in MS-Excel lets you quickle insert consecutinve odd numbers in a column of the sheet ?
JOA-IT 817 *
Correct : B
Explanation: Fill Series : Automatically enters valid data into rows using Excel's predefined and intelligent prediction functionalities. Put the mouse pointer over the bottom right-hand corner of the cell until it's a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.
11. Assume that in an MS-Excel sheet cell A1 and A2 contain values 5 and 5% respectively, then what will be the value of the formula = A1+A2 entered in cell A3 of that sheet ?
JOA-IT 817 *
Correct : C
Explanation : Here A1 = 5 and A2 = 5% = 5/100 = 0.05. Now A1+A2 = 5++0.05 = 5.05. Now convert it into percentage which is 505%.
12. Which of the following charts in MS-Excel shows numerical data as slices of a single circle ?
JOA-IT 817 *
Correct : D
Explanation: Click Insert > Chart > Pie, and then pick the pie chart you want to add to your slide. A pie chart is a circular representation of the data which is given by user.
13. Which of the following features in MS-Excel lets you record a sequence of keystrokes and play them again when required ?
JOA-IT 817 *
Correct : B
Explanation: Macros are small programs that record a user's actions as they perform a task in Excel. When the macro is run, it repeats the user's keystrokes and actions. This makes macros ideal for automating repetitive tasks.
14. The text color in a presentation should contrast with the colour of:
High Court JOA-IT *
Correct : A
Explanation: The text color in a presentation should contrast with the background color. The basic rule is to use a light font over a dark background or a dark font over a light background. This makes the text or graphic appear to float above the background instead of blending into it.
15. The short cut to Add multiple rows/Columns above/below of a row in a Microsoft Word Document is :
High Court JOA-IT *
Correct : A
Explanation: To insert more than one row (or column) at the same time, select as many rows or columns as you want to add before you click the insert control. For example, to insert two rows above a row, first select two rows in your table and then click Insert Above.
16. Which word processor came first ?
H.P. Agri. Uni. *
Correct : A
Explanation: WordStar was the first microcomputer word processor which is introduce in 1979 and offer mail merge and textual WYSIWYG.
17. What is the shortcut key to close the active document in Microsoft Word ?
H.P. Agri. Uni. *
Correct : D
Explanation: Shortcut keys of MS Word :
Open a document → Ctrl+O Create a new document → Ctrl+N Save the document → Ctrl+S Close the document → Ctrl+W
18. In MS Excel, which two keys must be pressed to enter multiples lines of text in one cell ?
H.P. Agri. Uni. *
Correct : C
Explanation: Click on the cell where you want to enter multiple lines of text. Fill the first line. Press Alt + Enter to add another line to the cell.
19. Which is not in MS Word ?
H.P. Agri. Uni. *
Correct : D
Explanation: Microsoft Word is a word processing program that allows for the creation of both simple and complex documents.
20. Press ..... to open the help window in MS Document ?
H.P. Agri. Uni. *
Correct : B
Explanation: F1 is known as universal help key.