Computer Knowledge Practice Question and Answer
8 Q: Which of the following statements is true?
(I) Primary storage units have faster access time and less storage capacity than secondary storage units.
(II) Primary storage units have sequential access.
(III) Secondary storage units are non-volatile storage.
1429 064a515518ecb104cc62515e1
64a515518ecb104cc62515e1(I) Primary storage units have faster access time and less storage capacity than secondary storage units.
(II) Primary storage units have sequential access.
(III) Secondary storage units are non-volatile storage.
- 1(I) and (II) onlyfalse
- 2(I) and (III) onlytrue
- 3(II) and (III) onlyfalse
- 4All (I), (II) and (III)false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "(I) and (III) only"
Explanation :
All of the following statements are true.
(I) Primary storage units have faster access time and less storage capacity than secondary storage units.
(II) Secondary storage units are non-volatile storage.
Q: Can it be kept in a cell of Microsoft Excel?
1427 064b9327c23047f4c71ce4b3b
64b9327c23047f4c71ce4b3b- 1Numberfalse
- 2Textfalse
- 3Formulafalse
- 4All of the abovetrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "All of the above "
Explanation :
Can be placed in a cell of Microsoft Excel.
- Number
- Text
- Formula
Q: Which of the following supports wireless communication ?
1426 061cedaef67bf5d33914d0a3e
61cedaef67bf5d33914d0a3e- 1GPRStrue
- 2Co-Axial Cablefalse
- 3Optical Fiberfalse
- 4Twisted Pair Wirefalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "GPRS "
Q: SSO is the short form of-
1424 063c93cf81c47ef334be27b90
63c93cf81c47ef334be27b90- 1Single Sight Onfalse
- 2Single sign Ontrue
- 3Service Selection Onfalse
- 4Single Service Onfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 2. "Single sign On"
Q: What are the two types of output devices?
1424 064a517f7b394764d11b0bf1b
64a517f7b394764d11b0bf1b- 1Windows XP 3 Linuxfalse
- 2Floppy and CDfalse
- 3Keyboard and mousefalse
- 4Monitor and Printertrue
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 4. "Monitor and Printer"
Explanation :
An output device is a computer hardware device that displays or reproduces information processed by a computer in human-readable form. Output devices usually receive information from the computer through an input device, such as a mouse or keyboard.
Some examples of output devices include-
1. Monitor: A monitor is a visual output device that displays images generated by a computer.
2. Printer: A printer is a physical output device that prints computer-generated documents on paper.
3. Speaker: A speaker is an audio output device that reproduces the sound produced by the computer.
4. Headphone: A headphone is a personal audio output device that reproduces the sound generated by a computer solely for the user to hear.
5. Projector: A projector is similar to a monitor, but it projects images onto a larger screen.
6. GPS Device: A GPS device is an output device that displays its current location to the user on a map or other view.
7. Braille Reader: A Braille reader is an output device that displays computer-generated information in Braille for visually impaired people.
Q: What is the maximum number of characters in the file name?
1424 064b92cd82dc867f593041aa1
64b92cd82dc867f593041aa1- 1256 characterstrue
- 2156 charactersfalse
- 3356 charactersfalse
- 41024 charactersfalse
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "256 characters"
Explanation :
1. The maximum number of characters a cell can contain in a worksheet is 256.
2. A file is a container in a computer system that stores data, information, settings, or commands, used with a computer program.
3. In graphical user interfaces (GUI), such as Microsoft operating systems, files are represented as icons that are associated with the program that opens the file.
Q: Suppose you are working on a worksheet named “Sheet1″ and you want to sum the value of cell A to A10 in the worksheet named “Sheet3″ then the correct formula in MS Excel 2010 is:
1420 061cee2398067f406dfecea98
61cee2398067f406dfecea98- 1=SUM(Sheet3iAI:A10true
- 2=SUM (AL: A10)false
- 3=Sheet3SAI:A1Ofalse
- 4=SUMSHEET3 (A1: A10)false
- Show AnswerHide Answer
- Workspace
- SingleChoice
Answer : 1. "=SUM(Sheet3iAI:A10"
Q: Cannot insert
...... in mspowerpoint 2010 slide.
1420 061b888cc3dcf35035ce0a471
61b888cc3dcf35035ce0a471- 1Mathematical Equationsfalse
- 2video filefalse
- 3audio filefalse
- 4Modemtrue
- Show AnswerHide Answer
- Workspace
- SingleChoice

