1.
Full form of CPU?
Correct Answer
B. Central Processing Unit
Explanation
The correct answer is "Central Processing Unit." The CPU is the primary component of a computer that performs most of the processing inside the computer. It is responsible for executing instructions, performing calculations, and managing data flow between different components of the computer. The term "Central Processing Unit" accurately describes the role and function of this essential component in a computer system.
2.
Which formula is used for Grade ?
Correct Answer
D. IF
Explanation
The IF formula is used for grading because it allows for conditional calculations. This means that the formula can evaluate a certain condition and return different values based on the result. In the context of grading, the IF formula can be used to determine if a student's score meets a certain criteria (e.g. if the score is above a certain threshold) and assign a corresponding grade accordingly. This formula is commonly used in spreadsheet programs like Excel to automate the grading process.
3.
Which MS-DOS Command lists the contents of current directory of a Disk ?
Correct Answer
B. DIR
Explanation
The correct answer is DIR. The DIR command is used in MS-DOS to list the contents of the current directory on a disk. It displays a detailed list of files and directories, including their names, sizes, and attributes. This command is helpful for navigating through directories and finding specific files within a disk.
4.
Which of the following methods cannot be used to edit the content of cell?
Correct Answer
C. Pressing the ALT key
Explanation
Pressing the ALT key is an incorrect method to edit the content of a cell. The ALT key is typically used to access the Excel ribbon shortcuts and keyboard shortcuts, and it does not directly allow for editing the content of a cell. The other options mentioned, such as clicking the formula bar, double-clicking on the cell, and pressing F2, are all valid methods to edit the content of a cell in Excel.
5.
Expect for the ______ Function ,a formula with a logical function shows the word, "TRUE" or "FALSE" as a result.
Correct Answer
A. IF
Explanation
A formula with the IF function shows the word "TRUE" or "FALSE" as a result. The IF function allows you to perform a logical test and return one value if the test is true and another value if the test is false. Therefore, it is the only logical function among the options provided that can produce the "TRUE" or "FALSE" result.
6.
Which system is built directly on hardware?
Correct Answer
C. Operating
Explanation
The operating system is built directly on hardware. It is the software that manages the computer hardware and provides services for other software applications. It directly interacts with the hardware components of the computer, such as the processor, memory, and input/output devices. The operating system is responsible for controlling and coordinating the activities of the computer system and ensuring that all software and hardware components work together smoothly.
7.
What run on computer hardware and serve as platform for other software to run on?
Correct Answer
C. Operating System
Explanation
An operating system is software that runs on computer hardware and provides a platform for other software to run on. It manages the computer's resources, such as the processor, memory, and input/output devices, and provides services that allow applications to interact with the hardware. The operating system also controls the execution of programs and provides a user interface for users to interact with the computer. Therefore, the operating system is the correct answer to the question.
8.
1 MB Equals to?
Correct Answer
D. 1024 KB
Explanation
The correct answer is 1024 KB because in computer storage, 1 MB (megabyte) is equal to 1024 KB (kilobytes). This is because computers use binary system for storage where each unit is a power of 2. Therefore, 1 MB is equal to 1024 KB and not 1000 KB.
9.
Which key is mapped to Right & Left hand thumb?
Correct Answer
D. Space Bar
Explanation
The space bar is the key that is mapped to both the right and left hand thumb. This key is commonly used to insert a space between words or to scroll down a webpage. It is positioned in the middle of the keyboard, making it easily accessible for both thumbs.
10.
Which of the following , runs on booting on computer?
Correct Answer
D. None of these
Explanation
None of the options mentioned (Virus, Trap door, Trojan Horse) run on booting a computer. Viruses, trap doors, and Trojan horses are all types of malicious software that can be executed on a computer, but they do not automatically run on booting. They typically require some form of user interaction or execution to be activated. Therefore, the correct answer is None of these.
11.
To switch between open windows , use the following keyboard combination.
Correct Answer
C. ALT+ TAB
Explanation
To switch between open windows, the correct keyboard combination is ALT+TAB. This combination allows the user to cycle through all open windows and select the desired window to bring it to the front. The ALT key is held down while pressing the TAB key to navigate through the open windows. This is a commonly used shortcut in operating systems like Windows to quickly switch between different applications or documents without using the mouse.
12.
Which of the following method could not be used to enter data in a cell?
Correct Answer
B. Pressing the ESC Key
Explanation
Pressing the ESC key cannot be used to enter data in a cell. The ESC key is used to cancel or exit out of an action or operation. It is commonly used to cancel an ongoing edit in a cell without making any changes. Therefore, it does not have the function of entering data into a cell.
13.
What is the Extension of MS- Excel 2003 file?
Correct Answer
C. XLS
Explanation
The extension of MS-Excel 2003 file is XLS. This file extension is used to identify files created with Microsoft Excel 2003 or earlier versions. XLS files contain spreadsheet data, including tables, formulas, charts, and macros. The XLS format is widely used for data analysis, financial modeling, and other spreadsheet-related tasks.
14.
Which of the following Displays the contents of the active cell?
Correct Answer
A. Formula Bar
Explanation
The formula bar is the correct answer because it displays the contents of the active cell. It is located just above the worksheet and shows the formula or value entered in the selected cell. This allows users to easily view and edit the content of the cell without directly modifying it in the cell itself.
15.
To add to cells (A1 and A2) together you use which of the following formula?
Correct Answer
C. =A1+A2
Explanation
The correct formula to add the values in cells A1 and A2 together is "=A1+A2". This formula uses the plus symbol (+) to indicate addition and combines the values in A1 and A2 to give the sum.
16.
Background color or effects applied on a document is not visible in?
Correct Answer
C. Print Preview
Explanation
Print Preview is a feature in word processing software that allows users to see how a document will look when printed. It displays the document as it would appear on paper, including page breaks, margins, and other formatting elements. However, it does not show background colors or effects applied to the document. Therefore, when using Print Preview, users will not be able to see any background color or effects that have been applied to the document.
17.
To get to the "symbol" dialog box , click on the _________ menu and choose "symbol"
Correct Answer
C. Insert
Explanation
To access the "symbol" dialog box, you need to click on the "Insert" menu. This menu contains various options for inserting different elements into your document, such as symbols, pictures, tables, and more. By selecting the "Insert" menu, you can easily find and choose the "symbol" option to open the symbol dialog box and insert the desired symbol into your document.
18.
The keystrokes "CTRL+U" is used to
Correct Answer
C. Applies Underline format to selected text
Explanation
The keystrokes "CTRL+U" is used to apply underline format to selected text.
19.
If the operator has any confusion while entering the customer's personal details, what should be the first step to be taken by the operator?
Correct Answer
A. Inform the supervisor
Explanation
If the operator has any confusion while entering the customer's personal details, the first step to be taken by the operator should be to inform the supervisor. This is important because the supervisor is a higher authority who can provide guidance and assistance in resolving the confusion. By informing the supervisor, the operator can ensure that the issue is addressed appropriately and that any potential errors or mistakes are minimized.
20.
An operator takes 2.5 hours to enter data from 50 forms. How many forms will he be able to complete, if he works for 10 hours?
Correct Answer
B. 200
Explanation
If the operator takes 2.5 hours to enter data from 50 forms, it means that he can complete 20 forms in one hour (50 forms divided by 2.5 hours). Therefore, if he works for 10 hours, he will be able to complete 200 forms (20 forms per hour multiplied by 10 hours).