Nielit Data Entry Test Exam
-
Full form of CPU?
-
Central Process unit
-
Central Processing Unit
-
Central Processor unit
-
None of the above
-
This quiz tests knowledge on basic computer operations, MS-DOS commands, and logical functions in data entry, suitable for preparing for the NIELIT data entry exams.
Quiz Preview
- 2.
Which formula is used for Grade ?
-
SUM
-
MAX
-
AUTOSUM
-
IF
Correct Answer
A. IFExplanation
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.Rate this question:
-
- 3.
Which MS-DOS Command lists the contents of current directory of a Disk ?
-
CD
-
DIR
-
COPY
-
TREE
Correct Answer
A. DIRExplanation
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.Rate this question:
-
- 4.
Which of the following methods cannot be used to edit the content of cell?
-
Clicking the formula bar
-
Double clicking on the cell
-
Pressing the ALT key
-
Pressing F2
Correct Answer
A. Pressing the ALT keyExplanation
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.Rate this question:
-
- 5.
Expect for the ______ Function ,a formula with a logical function shows the word, "TRUE" or "FALSE" as a result.
-
IF
-
AND
-
NOT
-
OR
Correct Answer
A. IFExplanation
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.Rate this question:
-
- 6.
Which system is built directly on hardware?
-
System
-
Environment
-
Operating
-
None
Correct Answer
A. OperatingExplanation
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.Rate this question:
-
- 7.
What run on computer hardware and serve as platform for other software to run on?
-
System software
-
All
-
Operating System
-
Operating environment
Correct Answer
A. Operating SystemExplanation
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.Rate this question:
-
- 8.
1 MB Equals to?
-
1000 KB
-
1024 GB
-
1024 BYTES
-
1024 KB
Correct Answer
A. 1024 KBExplanation
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.Rate this question:
-
- 9.
Which key is mapped to Right & Left hand thumb?
-
Enter Key
-
5 Key
-
P Key
-
Space Bar
Correct Answer
A. Space BarExplanation
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.Rate this question:
-
- 10.
Which of the following , runs on booting on computer?
-
Virus
-
Trap door
-
Trojan Horse
-
None of these
Correct Answer
A. None of theseExplanation
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.Rate this question:
-
- 11.
To switch between open windows , use the following keyboard combination.
-
CTRL+ TAB
-
SHIFT+ TAB
-
ALT+ TAB
-
ENTER+ TAB
Correct Answer
A. ALT+ TABExplanation
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.Rate this question:
-
- 12.
Which of the following method could not be used to enter data in a cell?
-
Pressing an arrow key
-
Pressing the ESC Key
-
Clicking the enter button to the formula bar
-
Pressing the tab key
Correct Answer
A. Pressing the ESC KeyExplanation
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.Rate this question:
-
- 13.
What is the Extension of MS- Excel 2003 file?
-
TXT
-
XLSX
-
XLS
-
PPT
Correct Answer
A. XLSExplanation
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.Rate this question:
-
- 14.
Which of the following Displays the contents of the active cell?
-
Formula Bar
-
Menu Bar
-
Name Box
-
Active cell
Correct Answer
A. Formula BarExplanation
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.Rate this question:
-
- 15.
To add to cells (A1 and A2) together you use which of the following formula?
-
=together(A1:A2)
-
A1 plus A2
-
=A1+A2
-
=add (A1+A2)
Correct Answer
A. =A1+A2Explanation
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.Rate this question:
-
- 16.
Background color or effects applied on a document is not visible in?
-
Print Layout view
-
Web Layout view
-
Print Preview
-
Reading View
Correct Answer
A. Print PreviewExplanation
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.Rate this question:
-
- 17.
To get to the "symbol" dialog box , click on the _________ menu and choose "symbol"
-
Tools
-
Home
-
Insert
-
Format
Correct Answer
A. InsertExplanation
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.Rate this question:
-
- 18.
The keystrokes "CTRL+U" is used to
-
Insert a Line Break
-
Increase font size
-
Applies Underline format to selected text
-
Indicate the text should be bold
Correct Answer
A. Applies Underline format to selected textExplanation
The keystrokes "CTRL+U" is used to apply underline format to selected text.Rate this question:
-
- 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?
-
Inform the supervisor
-
Ask help from colleagues
-
Interrogate the customer
-
Do what he thinks it's right
Correct Answer
A. Inform the supervisorExplanation
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.Rate this question:
-
- 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?
-
125
-
200
-
250
-
500
Correct Answer
A. 200Explanation
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).Rate this question:
-
Quiz Review Timeline (Updated): Mar 14, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 14, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 21, 2018Quiz Created by
Subhankar
Back to top