To view Complete range of questions Register today.
|
Subject : Computer Knowledge
|
| |
|
| Q :1. |
ARPANET stands for _______
|
| (a) |
Advanced Recheck Projects Agency Internet |
| (b) |
Advanced Recheck Projects Agency Network |
| (c) |
Advanced Research Projects Agency Network |
| (d) |
Advanced Research Projects Agency Internet |
|
|
Ans:
(c) Advanced Research Projects Agency Network |
|
|
| Q :2. |
EDI stands for ____
|
| (a) |
Electronic Data Interchange |
| (b) |
Electronic Digital Internet |
| (c) |
Electronic Digital Interchange |
| (d) |
Electronic Data Internet |
|
|
Ans:
(a) Electronic Data Interchange |
|
|
| Q :3. |
SONET stands for ______________
|
| (a) |
Signal Operation Network |
| (b) |
Synchronous Optical Network |
| (c) |
System Optical Network |
| (d) |
Signal Optical Network |
|
|
Ans:
(b) Synchronous Optical Network |
|
|
| Q :4. |
The term LAN stands for?
|
| (a) |
Local Area Net |
| (b) |
Local Aera Network |
| (c) |
Local Array Network |
| (d) |
Local Array Net |
|
|
Ans:
(b) Local Aera Network |
|
|
| Q :5. |
The term IPv4 stands for?
|
| (a) |
Internet Protocol Version 4 |
| (b) |
Internet Programming Version 4 |
| (c) |
International Programming Version 4 |
| (d) |
None of these |
|
|
Ans:
(a) Internet Protocol Version 4 |
|
|
| Q :6. |
The term IANA stands for?
|
| (a) |
Internet Assigned Numbers Authority |
| (b) |
Internal Assigned Numbers Authority |
| (c) |
Internet Associative Numbers Authoritative |
| (d) |
Internal Associative Numbers Authority |
|
|
Ans:
(a) Internet Assigned Numbers Authority |
|
|
| Q :7. |
The term HTTP stands for?
|
| (a) |
Hyper terminal tracing program |
| (b) |
Hypertext tracing protocol |
| (c) |
Hypertext transfer protocol |
| (d) |
Hypertext transfer program |
|
|
Ans:
(c) Hypertext transfer protocol |
|
|
| Q :8. |
The term FTP stands for?
|
| (a) |
File transfer program |
| (b) |
File transmission protocol |
| (c) |
File transfer protocol |
| (d) |
File transfer protection |
|
|
Ans:
(c) File transfer protocol |
|
|
| Q :9. |
CAD stands for
|
| (a) |
Computer aided design |
| (b) |
Computer algorithm for design |
| (c) |
Computer application in design |
| (d) |
All of the above |
|
|
Ans:
(a) Computer aided design |
|
|
| Q :10. |
The BIOS is the abbreviation of ________
|
| (a) |
Basic Input Output System |
| (b) |
Best Input Output System |
| (c) |
Basic Input Output Symbol |
| (d) |
Base Input Output System |
|
|
Ans:
(a) Basic Input Output System |
|
|
| Q :11. |
Bit stands for
|
| (a) |
Binary digits |
| (b) |
bit of system |
| (c) |
a part of byte |
| (d) |
All of above |
|
|
Ans:
(a) Binary digits |
|
|
| Q :12. |
The full form of ALU is
|
| (a) |
Arithmetic Logic Unit |
| (b) |
Array Logic Unit |
| (c) |
Application Logic Unit |
| (d) |
None of above |
|
|
Ans:
(a) Arithmetic Logic Unit |
|
|
| Q :13. |
What does DMA stand for?
|
| (a) |
Distinct Memory Access |
| (b) |
Direct Memory Access |
| (c) |
Direct Module Access |
| (d) |
Direct Memory Allocation |
|
|
Ans:
(b) Direct Memory Access |
|
|
| Q :14. |
RATS stand for
|
| (a) |
Regression Analysis Time Series |
| (b) |
Regression Analysis Time Sharing |
| (c) |
Real Analysis Series |
| (d) |
All of above |
|
|
Ans:
(a) Regression Analysis Time Series |
|
|
| Q :15. |
The full form of EEPROM is
|
| (a) |
Electrically Erasable Programmable Read Only Memory |
| (b) |
Easily Erasable Programmable Read Only Memory |
| (c) |
Electronic Erasable Programmable Read Only Memory |
| (d) |
None of the above |
|
|
Ans:
(a) Electrically Erasable Programmable Read Only Memory |
|
|
| Q :16. |
FORTRAN is
|
| (a) |
File Translation |
| (b) |
Format Translation |
| (c) |
Formula Translation |
| (d) |
Floppy Translation |
|
|
Ans:
(c) Formula Translation |
|
|
| Q :17. |
ASCII stands for
|
| (a) |
American Stable Code for International Interchange |
| (b) |
American Standard Case for Institutional Interchange |
| (c) |
American Standard Code for Information Interchange |
| (d) |
American Standard Code for Interchange Information |
|
|
Ans:
(c) American Standard Code for Information Interchange |
|
|
| Q :18. |
Which of the following is correct full form of BCD?
|
| (a) |
Binary Coded Decimal |
| (b) |
Bit Coded Decimal |
| (c) |
Binary Coded Digit |
| (d) |
Bit Coded Digit |
|
|
Ans:
(a) Binary Coded Decimal |
|
|
| Q :19. |
EBCDIC stands for
|
| (a) |
Extended Binary Coded Decimal Interchange Code |
| (b) |
Extended Bit Code Decimal Interchange Code |
| (c) |
Extended Bit Case Decimal Interchange Code |
| (d) |
Extended Binary Case Decimal Interchange Code |
|
|
Ans:
(a) Extended Binary Coded Decimal Interchange Code |
|
|
| Q :20. |
Mark I is also known as
|
| (a) |
American Sequence Controlled Calculator |
| (b) |
Automatic Sequence Calculating Controller |
| (c) |
American Sequence Controlled Computer |
| (d) |
Automatic Sequence Controlled Calculator |
|
|
Ans:
(d) Automatic Sequence Controlled Calculator |
|
|
| Q :21. |
When we can create a chart on a separate sheet in the same workbook, it is called a
|
| (a) |
Chart sheet |
| (b) |
Embedded chart |
| (c) |
View sheet |
| (d) |
View chart |
|
|
Ans:
(a) Chart sheet |
|
|
| Q :22. |
To display the save as dialog box, press
|
| (a) |
F2 |
| (b) |
F3 |
| (c) |
F5 |
| (d) |
F12 |
|
|
Ans:
(d) F12 |
|
|
| Q :23. |
____ is the intersection of a row with a column.
|
| (a) |
Cell |
| (b) |
Row |
| (c) |
Column |
| (d) |
All of these |
|
|
Ans:
(a) Cell |
|
|
| Q :24. |
The result of a formula in a cell is the
|
| (a) |
Displayed value |
| (b) |
Range |
| (c) |
Value |
| (d) |
Label |
|
|
Ans:
(c) Value |
|
|
| Q :25. |
The worksheet names appear on tabs at the ____ of the workbook window.
|
| (a) |
Bottom right |
| (b) |
Bottom left |
| (c) |
Top left |
| (d) |
Top right |
|
|
Ans:
(b) Bottom left |
|
|
| Q :26. |
Workbook is a collection of
|
| (a) |
Worksheets |
| (b) |
Page set-up |
| (c) |
Buttons |
| (d) |
Diagrams |
|
|
Ans:
(a) Worksheets |
|
|
| Q :27. |
____ is a powerful tool used to create and format spreadsheets.
|
| (a) |
Adobe Photoshop CS |
| (b) |
Mozilla Firefox |
| (c) |
Microsoft Office PowerPoint |
| (d) |
Microsoft Office Excel |
|
|
Ans:
(d) Microsoft Office Excel |
|
|
| Q :28. |
What refers to the horizontal cells which can contain information?
|
| (a) |
Ribbon |
| (b) |
Rows |
| (c) |
Columns |
| (d) |
Horizontal scrollbar |
|
|
Ans:
(b) Rows |
|
|
| Q :29. |
Excel documents are stored as files called
|
| (a) |
Workgroups |
| (b) |
Worktables |
| (c) |
Worksheets |
| (d) |
Workforce |
|
|
Ans:
(c) Worksheets |
|
|
| Q :30. |
____ sign is used to create an absolute cell reference.
|
| (a) |
$ |
| (b) |
@ |
| (c) |
& |
| (d) |
% |
|
|
Ans:
(a) $ |
|
|
| Q :31. |
When a chart is placed on this, it is much larger and there is no other data on it.
|
| (a) |
Reference sheet |
| (b) |
Primary sheet |
| (c) |
Exclusive sheet |
| (d) |
Chart sheet |
|
|
Ans:
(d) Chart sheet |
|
|
| Q :32. |
# VALUE! Refers to ___
|
| (a) |
Font value |
| (b) |
Error in value |
| (c) |
Subscript of the number value |
| (d) |
Addition of value |
|
|
Ans:
(b) Error in value |
|
|
| Q :33. |
Press ______ to displays the Print dialog box in MS Excel.
|
| (a) |
Alt + P |
| (b) |
Ctrl + P |
| (c) |
Esc + P |
| (d) |
Tab + P |
|
|
Ans:
(b) Ctrl + P |
|
|
| Q :34. |
You can undo and redo up to ____ action in Microsoft Office Excel, even after a worksheet is saved.
|
| (a) |
50 |
| (b) |
99 |
| (c) |
100 |
| (d) |
500 |
|
|
Ans:
(a) 50 |
|
|
| Q :35. |
What is the default row height of MS Excel?
|
| (a) |
10 |
| (b) |
12 |
| (c) |
13 |
| (d) |
15 |
|
|
Ans:
(d) 15 |
|
|
| Q :36. |
Typed text showed in active cell and also in ___
|
| (a) |
Formula bar |
| (b) |
Ribbon |
| (c) |
Title bar |
| (d) |
Scroll bar |
|
|
Ans:
(a) Formula bar |
|
|
| Q :37. |
Which bar show the used formula of selected active cell?
|
| (a) |
Formula bar |
| (b) |
Ribbon |
| (c) |
Menu bar |
| (d) |
Scroll bar |
|
|
Ans:
(a) Formula bar |
|
|
| Q :38. |
How many columns are there in old version of MS Excel?
|
| (a) |
250 |
| (b) |
256 |
| (c) |
265 |
| (d) |
269 |
|
|
Ans:
(b) 256 |
|
|
| Q :39. |
This is not a function category in Excel.
|
| (a) |
Logical |
| (b) |
Text |
| (c) |
Financial |
| (d) |
Data series |
|
|
Ans:
(d) Data series |
|
|
| Q :40. |
____ returns the least common multiple.
|
| (a) |
LCCM() |
| (b) |
LCM() |
| (c) |
TLCM() |
| (d) |
RTLCM() |
|
|
Ans:
(b) LCM() |
|
|
| Q :41. |
In a spreadsheet, a ____ is a number you will use in a calculation.
|
| (a) |
Value |
| (b) |
Cell |
| (c) |
Field |
| (d) |
Label |
|
|
Ans:
(a) Value |
|
|
| Q :42. |
Which sign indicate to multiplication?
|
| (a) |
Asterisk |
| (b) |
Caret |
| (c) |
Percent sign |
| (d) |
Forward slash |
|
|
Ans:
(a) Asterisk |
|
|
| Q :43. |
The ____ helps to identify various plotted data series.
|
| (a) |
X-axis |
| (b) |
Y-axis |
| (c) |
Gridlines |
| (d) |
Legend |
|
|
Ans:
(d) Legend |
|
|
| Q :44. |
The letter and number of the intersecting column and row is the
|
| (a) |
Cell location |
| (b) |
Cell position |
| (c) |
Cell address |
| (d) |
Cell coordinates |
|
|
Ans:
(c) Cell address |
|
|
| Q :45. |
On an Excel sheet, the active cell is indicated by
|
| (a) |
A dark wide border |
| (b) |
A dotted border |
| (c) |
A blinking border |
| (d) |
None of the above |
|
|
Ans:
(a) A dark wide border |
|
|
| Q :46. |
Which of the following is the comparison operator?
|
| (a) |
* |
| (b) |
^ |
| (c) |
= |
| (d) |
+ |
|
|
Ans:
(c) = |
|
|
| Q :47. |
The result is a ___ value either TRUE or FALSE.
|
| (a) |
Logical |
| (b) |
Arithmetic |
| (c) |
Algorithm |
| (d) |
Logarithm |
|
|
Ans:
(a) Logical |
|
|
| Q :48. |
Formulas in Excel are made up of ___
|
| (a) |
Arithmetical operators and functions |
| (b) |
Only arithmetic operators |
| (c) |
Only symbols |
| (d) |
Only functions |
|
|
Ans:
(a) Arithmetical operators and functions |
|
|
| Q :49. |
Which of the following is the default numbers of worksheet in MS Excel?
|
| (a) |
2 |
| (b) |
3 |
| (c) |
4 |
| (d) |
5 |
|
|
Ans:
(b) 3 |
|
|
| Q :50. |
To maximize the currently selected window, press
|
| (a) |
Ctrl+ F9 |
| (b) |
Ctrl+ F10 |
| (c) |
Ctrl+ F11 |
| (d) |
Ctrl+ F12 |
|
|
Ans:
(b) Ctrl+ F10 |
|
|
|
|
To view more Questions click on Register Now
|
