Blog, News, Views, Events, Information, Knowledge, Vlog, Lok Sewa Aayog, Public Service Commission (PSC), Questions & Answers (QS), Old is god, Question Bank
Computer related technical terms and abbreviations: (Short form : Full Form)
ACER - Acquisition Collaboration Experimentation Reflection. ADSL - Asymmetric Digital Subscribe Line. AMOLED - Active-matrix organic light-emitting diode. AMR- Adaptive Multi-Rate. APK - Authenticated public key. APN - Access Point Name. ATM - Automated Teller machine. CDMA - Code Division Multiple Access. CMOS - Complementary Metal Oxide Semiconductor COM - Computer Output Microfilm COMPUTER - Common Oriented Machine Particularly United and used under Technical and Educational Research. DAT - Digital Audio Tape DELL - Digital electronic link library. DIVX - Digital internet video access. DLNA - Digital Living Network Alliance. DNSE - Digital natural sound engine. DTP - Desk top publishing. DVD - Digital Versitle Disk. EDGE - Enhanced Data Rates for Globa Evolution. ESN - Electronic Serial Number. FSSAI(Fssai) - Food Safety & Standards Authority of India. GOOGLE - Global Organization Of Oriented Group Language Of Earth. GPRS - General Packet Radio Service. GPS - Global Positioning System. GSM - Global System for Mobile Communications. HDMI - High-Definition Multimedia Interface. HP - Hewlett Packard. HS - HOTSPOT. HSDPA - High speed down-link packet access. HSPA - High Speed Packet Access. HSUPA - High-Speed Uplink Packet Access. IFSC - Indian Financial System Code. IMEI - International Mobile Equipment Identity. ISP - Internet Service Provider. IVRS - Interactive Voice Response System. J2ME - Java 2 micro edition. LCD - Liquid Crystal Display. LED - Light emitting diode. MMS - Multimedia Message Service. MODEM - Modulator-Demodulator. MPEG - moving pictures experts group. NFC - Near field communication. OLED - Organic light-emitting diode. OS - Operating system. OTG - On-the-go. OVI - Ohio Video Intranet. P.O.I - Point of interest. PAN - permanent account number. PDF - portable document format. PPI - Pixels Per Inch. QVGA - Quarter Video Graphics Array. RAM - Random access memory. ROM - Read only memory. RSS - Really simple syndication. SIM - Subscriber Identity Module. SIS - Installation source. S-LCD - Super Liquid Crystal Display. SMS - Short Message Service SNS - Social network service. STD - Subscriber Trunk dialling. TAX - Trunk Automatic Exchange TFT - Thin film transistor. UMTS - Universal Mobile Telecommunicati ons System. UPS - Uninterruptible power supply. USB - Universal serial Bus. VGA - Video Graphics Array. VIRUS - Vital Information Resources Under Siege. VPN - Virtual private network. WCDMA - Wide-band Code Division Multiple Access. Wi-Fi - Wireless fidelity. WINDOW - Wide Interactive Network Development for Office work Solution. WLAN - Wireless Local Area Network. WVGA - Wide video graphics array. WXGA - Widescreen Extended Graphics Array. XML - Extensible Markup Language YAHOO - Yet Another Hierarchical Officious Oracle.
Full form of some words News paper = _North East West South past and present events report._ Chess = _Chariot, Horse, Elephant, Soldiers._ Cold = _Chronic Obstructive Lung Disease._ Joke = _Joy of Kids Entertainment._ Aim = _Ambition in Mind._ Date = _Day and Time Evolution._ Eat = _Energy and Taste._ Tea = _Taste and Energy Admitted._ Pen = _Power Enriched in Nib._ Smile = _Sweet Memories in Lips Expression._ etc. =_End of Thinking Capacity_ OK =_Objection Killed_ Or =_Orl Korec (Greek Word)_ Bye = Be with you Everytime.
1. Which of the following is not valid version of MS Office?
A) Office XP
B) Office Vista
C) Office 2007
D) None of above
➤ Answer:
2. You cannot close MS Word application by
A) Choosing File menu then Exit submenu
B) Press Alt+F4
C) Click X button on title bar
D) From File menu choose Close submenu
➤ Answer:
3. The key F12 opens a
A) Save As dialog box
B) Open dialog box
C) Save dialog box
D) Close dialog box
➤ Answer:
4. What is the short cut key to open the Open dialog box?
A) F12
B) Shift F12
C) Alt + F12
D) Ctrl + F12
➤ Answer:
5. A feature of MS Word that saves the document automatically after certain interval is available on
A) Save tab on Options dialog box
B) Save As dialog box
C) Both of above
D) None of above
➤ Answer:
6. Where can you find the horizontal split bar on MS Word screen?
A) On the left of horizontal scroll bar
B) On the right of horizontal scroll bar
C) On the top of vertical scroll bar
D) On the bottom of vertical scroll bar
➤ Answer:
7. Which of the following is not available on the Ruler of MS Word screen?
A) Tab stop box
B) Left Indent
C) Right Indent
D) Center Indent
E) All of them are available on ruler
➤ Answer:
8. What is place to the left of horizontal scroll bar?
A) Tab stop buttons
B) View buttons
C) Split buttons
D) Indicators
E) None of above
➤ Answer:
9. Which file starts MS Word?
A) Winword.exe
B) Word.exe
C) Msword.exe
D) Word2003.exe
➤ Answer:
10. How many ways you can save a document?
A) 3
B) 4
C) 5
D) 6
➤ Answer:
11. If you want to keep track of different editions of a document which features will you use?
A) Editions
B) Versions
C) Track Change
D) All of above
➤ Answer:
12. Background color or effects applied on a document is not visible in
A) Web layout view
B) Print Layout view
C) Reading View
D) Print Preview
➤ Answer:
13. What is a portion of a document in which you set certain page formatting options?
A) Page
B) Document
C) Section
D) Page Setup
➤ Answer:
14. Borders can be applied to
A) Cells
B) Paragraph
C) Text
D) All of above
➤ Answer:
15. Which of the following is not a type of page margin?
A) Left
B) Right
C) Center
D) Top
➤ Answer:
16. What is the default left margin in Word 2003 document?
A) 1"
B) 1.25"
C) 1.5"
D) 2"
➤ Answer:
17. What is gutter margin?
A) Margin that is added to the left margin when printing
B) Margin that is added to right margin when printing
C) Margin that is added to the binding side of page when printing
D) Margin that is added to the outside of the page when printing
➤ Answer:
18. Portrait and Landscape are
A) Page Orientation
B) Paper Size
C) Page Layout
D) All of above
➤ Answer:
19. If you need to change the typeface of a document, which menu will you choose?
A) Edit
B) View
C) Format
D) Tools
➤ Answer:
20. Which of the following is not a font style?
A) Bold
B) Italics
C) Regular
D) Superscript
➤ Answer:
1. What Are The Different Views To Display A Table A) Datasheet View B) Design View C) Pivote Table & Pivot Chart View D) All Of Above ➤ Answer :
2. Which Of The Following Creates A Drop Down List Of Values To Choose From? A) Ole Object B) Hyperlink C) Memo D) Lookup Wizard ➤ Answer :
3. The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File. A) Database Window B) Query Window C) Design View Window D) Switchboard ➤ Answer :
4. The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables A) Relationship B) Join C) Query D) None Of These ➤ Answer :
5. In A Database Table, The Category Of Information Is Called __________ A) Tuple B) Field C) Record D) All Of Above ➤ Answer :
6. This Key Uniquely Identifies Each Record A) Primary Key B) Key Record C) Unique Key D) Field Name ➤ Answer :
7. It Is An Association Established Between Common A) Line B) Relationship C) Primary Key D) Records ➤ Answer :
8. This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project. A) Data Definition B) Data Refinement C) Establishing Relationship D) None Of The Above ➤ Answer :
9. A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________ A) DCL B) DML C) DDL D) All Of Above ➤ Answer :
10. Which Of The Field Has Width 8 Bytes? A) Memo B) Number C) Date/time D) Hyperlink ➤ Answer :
11. Which Of The Following Statement Is True? A) Foreign Key Fields Don\'t Allow Duplicate Values B) In Primary Key Field You Can Enter Duplicate Value C) In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting D) All Statements Are True ➤ Answer :
12. Following Is Not A Database Model A) Network Database Model B) Relational Database Model C) Object Oriented Database Model D) None ➤ Answer :
13. Microsoft Access Is A A) RDBMS B) OODBMS C) ORDBMS D) Network Database Model ➤ Answer :
14. DCL Provides Commands To Perform Actions Like A) Change The Structure Of Tables B) Insert, Update Or Delete Records And Data Values C) Authorizing Access And Other Control Over Database D) None Of Above ➤ Answer :
15. The Database Language That Allows You To Access Or Maintain Data In A Database A) DCL B) DML C) DDL D) None Of Above ➤ Answer :
16. What Is The Maximum Length A Text Field Can Be? A) 120 B) 255 C) 265 D) 75 ➤ Answer :
17. Which Of The Following Is Not A Database Object? A) Tables B) Queries C) Relationships D) Reports ➤ Answer :
18. A __________ Enables You To View Data From A Table Based On A Specific Criterion A) Form B) Query C) Macro D) Report ➤ Answer :
19. What Are The Columns In A Microsoft Access Table Called? A) Rows B) Records C) Fields D) Columns ➤ Answer :
20. Which Of The Following Is Not A Type Of Microsoft Access Database Object? A) Table B) Form C) Worksheets D) Modules ➤ Answer :
1. Which of the following term describes explanatory text attached to a cell?
A. Context B. Callout C. Comment D. Dialog E. None of these
➤ Answer:
2. Which of the following function displays row data in a column or column data in a row?
A. Hyperlink B. Index C. Transpose D. Sum E. None of these
➤ Answer:
3. Macros can be executed from the ____ menu.
A. Insert B. Tools C. Edit D. Data E. None of these
➤ Answer:
4. A function inside another function is called a _____ function.
A. Nested B. Round C. Sum D. Text E. None of these
➤ Answer:
5. Which of the following function is used to enter current time in a worksheet cell?
A. =today() B. =now() C. =time() D. =currentTime() E. None of these
➤ Answer:
6. Which of the following is the keyboard shortcut for creating a chart from the selected cells?
A. F3 B. F5 C. F7 D. F12 E. F11
➤ Answer:
7. Which of the following keyboard shortcut is used to edit existing Excel data?
A. F2 B. F3 C. F1 D. F4 E. F5
➤ Answer:
8. A value used in a formula that does not change is called a _______
A. Static B. Cell C. Variable D. Constant E. Dynamic
➤ Answer:
9. Which of the following is used to convert existing Excel worksheet data and charts to HTML document?
A. External Wizard
B. Intranet Wizard
C. Import Wizard
D. Export Wizard
E. Internet Assistant Wizard
➤ Answer:
10. Which of the following term refers to a set of values that Excel saves and can substitute automatically on your worksheet?
A. Range B. Scenario C. Nested D. What-if analysis E. None of these
➤ Answer:
11. In Excel, a typical worksheet has _____ number of columns.
A. 12,384 B. 15,684 C. 16,384 D. 13,484 E. None of these
➤ Answer:
12. In Excel, a typical worksheet has _____ number of rows.
A. 1,048,576 B. 1,015,684 C. 1,016,384 D. 1,013,484 E. None of these
➤ Answer:
13. Which of the following symbol is used before a number to make it a label?
A. ” (quote) B. = (equal) C. _ (underscore) D. ‘ (apostrophe) E. None of these
➤ Answer:
14. In Excel, a typical worksheet has _______ column width
A. 250 Characters
B. 512 Characters
C. 255 Characters
D. 612 Characters
E. None of these
➤ Answer:
15. Which of the following is the maximum limit of the height of a row in an Excel Sheet?
A. 209 points B. 309 points C. 509 points D. 409 points E. None of these
➤ Answer:
16. What is the maximum number of line feeds per cell in an Excel Sheet?
A. 253 B. 250 C. 257 D. 212 E. 211
➤ Answer:
17. What is the maximum limit of characters in a header or footer in an Excel Sheet?
A. 253 B. 255 C. 257 D. 212 E. 211
➤ Answer:
18. What is the minimum Zoom range in an Excel Sheet?
A. 8% B. 10% C. 12% D. 20% E. None of these
➤ Answer:
19. What is the maximum Zoom range in an Excel Sheet?
A. 100% B. 200% C. 300% D. 400% E. None of these
➤ Answer:
20. What is the maximum limit of available worksheet functions?
A. 141 B. 231 C. 341 D. 421 E. None of these
➤ Answer:
Competitive Written Examination Date: 2073-07-28 Time: 2 hr 30 mins Full Marks: 100
Section “A”: Multiple Choice 25 x 2 = 50
1. Objects on the slide that hold text are called a) Placeholders b) Object holders c) Auto layout d) Text holder ➤ Answer: 2. Which of the following should be used when you want to add a slide to an existing presentation? a) File, add a new slide b) Insert, New Slide c) File Open d) File New ➤ Answer: 3. The PowerPoint view that displays only text (title and bullets) is a) Slide show b) Slide sorter view c) Notes page view d) Outline view ➤ Answer: 4. …….. value change the color of text into red. a) FF0000 b) 00FF00 c) 0000FF d) None of the above ➤ Answer: 5. Which HTML tag produces the biggest heading? a) <h7> b) <h9> c) <h4> d) <h1> ➤ Answer: 6. The ALU of a computer normally contains a number of high speed storage element called a) Semiconductor memory b) Registers c. Hard disks d) Magnetic disk ➤ Answer: 7. Communication between a computer and a keyboard involves _______ transmission. a) Automatic b) Half-duplex c) Full-duplex d) Simplex ➤ Answer: 8. DNS database contains a) name server records b) hostname-to-address records c. hostname aliases d) all of the above ➤ Answer: 9. _______ command is used to create a file a) Create b) Create con c) Copy d) Copy Con ➤ Answer: 10. Which of the following class uses 8 bits for network and 24 bits for hosts of the IP address? a) Class A b) Class B c) Class C d) Class D ➤ Answer: 11. Which of the following memories need refreshing? a) SRAM b) DRAM c) ROM d) All of the above ➤ Answer: 12. Pressing the combination of _______ keys is called warm booting a) Ctrl+Alt+Del b) Ctrl+Shift+Del c) Ctrl+Tab+Del d) Ctrl+Caps+Del ➤ Answer: 13. _______ combination of keys are used for column break. a) Ctrl+Shift+Enter b) Ctrl+Alt+Del c) Ctrl+Shift+Home d) None of the above ➤ Answer: 14. Which of the following is not of the merge process? a) Sort the data records b) Format a main document c. Edit a data source d) Merge the two files to print or create new document ➤ Answer: 15. In Microsoft Word the key F12 opens a a) Open dialog box b) Save as dialog box c) Save dialog box d) Close dialog box ➤ Answer: 16. To print current page of a document only a) Press Ctrl+P and select current page b. Click MS Office button >> Print >> Print Preview >> Print and select current page c. Click MS Office button >> Print >> Quick Print d. Both A and B ➤ Answer: 17. The A4 default paper size of width/height is a) 8.17”/11.59” b) 8.27”/11.69” c) 8.3”/11.79” d) None of above ➤ Answer: 18. The formula in cell B5 is =A4+C3. This is copied to the cell D8. What will be the formula in D8? a) A4+C3 b) C7+E6 c) C4+E3 d) E7+C5 ➤ Answer: 19. Which of the following is correct syntax in Excel? a) =IF(LogicalText, TrueResult, FalseResult) b. =IF(LogicalTest, (TrueResult, FalseResult)) c. =IF(LogicalTest, TrueResult)(LogicalTest, FalseResult)) d. =IF(LogicalTest, TrueResult, IF(LogicalTest, FalseResult)) ➤ Answer: 20. Which is an example of a function? a) Add(A1:A2) b) =A1+A c) =Sum(A1:A2) d) A1+A2
21. To start data on a new line within a cell, enter a line break by pressing a) Alt+Enter b) Shift+Enter c) Ctrl+Enter d) None of the above ➤ Answer: 22. A form can be used as a a) Data entry b) Switchboard c) Custom dialog box d) All of the above ➤ Answer: 23. _______ is the default field size of auto number a) Short Integer b) Long Integer c) Float d) Double ➤ Answer: 24. …. Uniquely identifies each record a) Primary key b) key record c) Unique key d) Field name ➤ Answer: 25. Function key …. is used to display the Slides show a) F4 b) F5 c) F6 d) F7 ➤ Answer:
Solved Question Paper of PSC Assistant Computer Operator Exam Date: 2073-02-32 Time: 45 minutes FM: 50 Objective Questions (50 x 1 = 50 marks)
1. Which command is used to display all the files having (.exe) extension but the different file name? A) dir *.exe B) dir filename.* C) dir filename.ext D) dir *.sys ➤ Answer: 2. CHKDSK command is used to: A) Report the status of files on disk B) Analyze the hard disk error C) Diagnose the hard disk error D) all of the above. ➤ Answer: 3. Which command is used to change the file name? A) ren B) rename C) both of above D) none of above ➤ Answer: 4. Which among the following are the best tools for fixing errors on disk? A) Fixdsk B) Fdisk C) Scandisk D) Chkdsk ➤ Answer: 5. The key F12 opens a: A) close dialog box B) save as dialog box C) open dialog box D) save dialog box ➤ Answer: 6. Which file starts MS Word? A) word2003.exe B) word.exe C) winword.exe D) msword.exe ➤ Answer: 7. To invoke help in MS window one has to use: A) F4 B) F1 C) F2 D) F3 ➤ Answer: 8. Key combination used for UNDO in MS word is: A) Ctrl+U B) Ctrl+Z C) Ctrl+Y D) Ctrl+V ➤ Answer: 9. Which of the following is not a valid view type in MS-word? A) Print layout B) Web layout C) Outline layout D) Inline layout ➤ Answer: 10. What is the short cut to justify text to center? A) Ctrl+E B) Ctrl+S C) Ctrl+L D) Ctrl+C ➤ Answer: 11. Which of the following is an example for automatic text formatting? A) replacing two -‘s with an hyphen B) underlining hyperlink C) adjusting extra space D) all of the above ➤ Answer: 12. Feature that enables several people to work to create and update a document: A) document protection B) document sharing C) document locking D) document collaboration ➤ Answer: 13. If you want to keep track of different editions of a document which features will you use? A) Track change B) Editions C) Versions D) All of above ➤ Answer: 14. To underline selected text in one can use: A) tab+U B) alt+U C) ctrl+U D) shift+U ➤ Answer: 15. What is a portion of a document in which you set certain page formatting options as default? A) page setup B) page C) document D) section ➤ Answer: 16. Which of the following is not a type of page margin? A) top B) left C) right D) center ➤ Answer: 17. You can break the column by: A) pressing alt+enter B) pressing ctrl+shift+enter C) pressing ctrl+enter D) pressing shift+enter ➤ Answer: 18. A feature of MS Word that saves the document automatically after certain interval is available on: A) pressing ctrl+s B) save tab on options dialog box C) save as dialog box D) none of above ➤ Answer: 19. Excel uniquely identifies cells within a worksheet with a cell name which is a: A) Number B) cell names C) column numbers and row letters D) Column letters and row numbers ➤ Answer: 20. Which symbol must all formula begin with? A) @ B) = C) + D) ( ➤ Answer: 21. Getting data from cell located in a different sheet is called A) Functioning B) Accessing C) Referencing D) Updating ➤ Answer: 22. To auto fit the width of column: A) Double click the column header B) Double click the right border of column C) Double click the left border of column D) all of above ➤ Answer: 23. A circular reference is: A) A formula that either directly or indirectly depends on itself B) Geometric modeling tool C) A cell that points to a drawing object D) Always erroneous ➤ Answer: 24. To add the number of cell A2 and A9: A) =sum(A2,A9) B) = add(A2:A9) C) =sum(A2 and A9) D) =sum(A2 to A9) ➤ Answer: 25. Absolute reference to cell A3 is expressed as: A) @A$3 B) @A3 C) A$3 D) $A$3 ➤ Answer: 26. You want to track the progress of the stock market on a daily basis. Which type of chart should you use? A) column chart B) pie chart C) row chart D) line chart ➤ Answer: 27. MS-Excel files have a default extension of: A) .xsl B) .xls C) .doc D) .xlw ➤ Answer: 28. Which of the following formulas is not entered correctly? A) 10+50 B) =10+50 C) =B7*B1 D) =B7+14 ➤ Answer: 29. If you press………. , the cell accepts your typing as its contents. A) insert B) enter C) ctrl+enter D) tab ➤ Answer: 30. You can print: A) a single worksheet B) a range of cell by range name C) an entire worksheet D) all of the above ➤ Answer: 31. …….. is a collection of data stored in a standardized format, designed to be shared by multiple users. A) relation B) database C) record D) database management system. ➤ Answer: 32. The sql query: SELECT * FROM employee A) displays structure of employee table B) displays all field names from employee table C) displays all records from employee table D) all of the above ➤ Answer: 33. A field or group of fields that uniquely identifies every row of a table is ….. A) access key B) primary key C) foreign key D) hot key ➤ Answer: 34. Which of the following should you use if you want all the slide in the presentation to have the same “look”? A) a presentation design template B) tie slide layout option C) add a slide option D) outline view ➤ Answer: 35. Which file format can be added to a Power Point show? A) .wav B) .jpg C) .gif D) all of the above ➤ Answer: 36. IBM 1401 was brought to prepare the census report of ….. A) 2048 BS B) 2018 BS C) 2028 BS D) 2038 BS ➤ Answer: 37. Transistor is related to ……… generation computers. A) fifth B) second C) third D) fourth ➤ Answer: 38. Which of the following is the type of computer on the basis of size? A) hybrid B) analog C) micro D) digital ➤ Answer: 39. Component of computer system A) Processing unit B) input unit C) output unit D) all of the above ➤ Answer: 40. Which of the following storage is fastest? A) blue-ray disc B) RAM C) ROM D) Register ➤ Answer: 41. Unicode standard is A) keyboard layout B) software C) font D) character encoding system ➤ Answer: 42. If any person publishes illegal materials in electronic form, he shall be liable to the punishment with: A) fine not exceeding two thousand rupees and with imprisonment not exceeding five years or with both B) fine not exceeding one hundred thousand rupees or with the imprisonment not exceeding five years or with both C) fine not exceeding two thousand rupees and with imprisonment not exceeding three years D) fine not exceeding two thousand rupees or with imprisonment not exceeding three years or with both ➤ Answer: 43. Program developed according to the requirement specific to an office is ….. A) packaged software B) tailored software C) utility software D) all of the above ➤ Answer: 44. C Language was developed by ….. A) Steve Jobs B) Linus Torvalds C) Bill Gates D) Dennis Ritche ➤ Answer: 45. Cache memory ….. A) stores data permanently B) helps to store more data in hard disk C) placed between main memory and microprocessor, D) holds last time visited web site only ➤ Answer: 46. GIF images can have only upto ….. colors A) 1024 B) 128 C) 256 D) 512 ➤ Answer: 47. A protocol is- – — – A) an operating system B) interconnection pattern of computers C) set of rules for communication D) a device for internet ➤ Answer: 48. A dot matrix printer: A) input device B) is output device C) cannot print alphabet D) cannot print number ➤ Answer: 49. File with which extension is not executable? A) exe B) com C) sys D) bat ➤ ➤ Answer: 50. The batch file uses the extension: A) .DOS B) .BAT C) .DOC D) .PRG ➤ Answer:
1. What happens when you click on insert >> picture>> clip art?
A. It inserts a clipart picture into document
B. It lets you choose clipart to insert into document
C. It opens clip art task bar
D. None of the above
➤ Answer:
2. In word, the mailing list is known as the ____.
A. Data sheet
B. Source
C. Data source
D. Sheet
➤ Answer:
3. From which menu you can insert header and footer?
A. Insert menu
B. View menu
C. Format menu
D. Tools menu
➤ Answer:
4. Which of the following line spacing is invalid?
A. Single
B. Double
C. Triple
D. Multiple
➤ Answer:
5. Which operation you will perform if you need to move a block of text?
A. Copy and paste
B. Cut and paste
C. Paste and delete
D. Paste and cut
➤ Answer:
6. MS Office provides help in many ways, which of these is one of them?
A. What is this?
B. Office Assistant
C. Help menu
D. All of the above
➤ Answer:
7. Which of the following is NOT available in spread sheet?
A. Statistical Function
B. Mail merge facility
C. What-if analysis
D. Pivot table
➤ Answer:
8. Which of the following is NOT a logical operator?
A. >
B. =
C. +
D. <
➤ Answer:
9. Which of the following is an absolute cell reference?
A. $C$1
B. &C1$
C. #C$1
D. #C1#
➤ Answer:
10. Getting data from a cell located in a different sheet is called:
A. Accessing
B. Referencing
C. Updating
D. Functioning
➤ Answer:
11. Conditional count can be performed using:
A. Countiff()
B. Countif()
C. Ifcount()
D. Iffcount()
➤ Answer:
12. Multiple calculations can be made in a single formula using:
A. Standard Formula
B. Complex Formula
C. Smart Formula
D. Array Formula
➤ Answer:
13. Chart in worksheet itself is known as:
A. Embedded Chart
B. Implied Chart
C. Inserted Chart
D. Overlapping Chart
➤ Answer:
14. When a formatted number does not fit within a cell, it displays:
A. ####
B. )DIV/0
C. #DIV@
D. None of the above
➤ Answer:
15. Red triangle at top right corner of a cell indicates:
A. There is an error in the cell
B. The font color of the text in cell is red
C. There is a comment associated with the cell
D. The cell can’t accept formula
➤ Answer:
16. To select multiple non-adjacent cells in a worksheet you will click them holding:
A. Ctrl key
B. Alt key
C. Shift key
D. Ctrl+Shift key
➤ Answer:
17. Formatting a cell in currency, you can specify:
A. Decimal places
B. Currency Symbol
C. Both of above
D. None of the above
➤ Answer:
18. To insert three columns between columns D and E you would:
A. Select Column D
B. Select Column E
C. Select columns E,F and G
D. Select columns D,E and F
➤ Answer:
19. This key uniquely identifies each record in a table of a database is a:
A. Primary key
B. Key Record
C. Unique key
D. Field name
➤ Answer:
20. What do you mean by one-to-many relationship between student and class table?
A. One student can have many classes
B. One class may have many students
C. Many classes may have many students
D. Many students may have many classes
➤ Answer:
21. Queries in Access can be used as:
A. View, change and analyze data in different ways
B. A source of records for forms and report
C. Only A
D. Both A and B
➤ Answer:
22. Good design determines:
A. Credibility
B. Readability
C. First impression
D. All of the above
➤ Answer:
23. Objects on the slide that hold text are called:
A. Placeholders
B. Object holders
C. Auto layout
D. Text holders
➤ Answer:
24. Drag and drop feature allows you to….
A. Switch from insert to over type mode
B. Move and copy text using the mouse
C. Move and copy text using the clipboard
D. Open a new document and drop it into the active document
➤ Answer:
25. When inserting page number in footer it appeared 1 but you wish to show a how can you do that?
A. From format menu choose bullets and numbering and configure necessary setting
B. From insert menu choose page number and specify necessary setting
C. Click on page number format tool and specify required setting
D. All of the above
➤ Answer:
26. Access method in Hard disk is:
A. Random
B. Serial
C. Sequential
D. All of the above
➤ Answer:
27. Back up of the data files will help to prevent:
A. Loss of confidentiality
B. Duplication of data
C. Virus infection
D. Loss of data
➤ Answer:
28. Which of the following retains the information it’s storing when the power to the system is turned off?
A. CPU
B. ROM
C. DRAM
D. DIMM
➤ Answer:
29. Which of the connector is used to plug a telephone line into a modem?
A. COM1
B. RJ-45
C. RJ-11
D. RJ-10
➤ Answer:
30. ____ has the shortest access times.
A. Cache memory
B. Virtual memory
C. Secondary memory
D. All of the above
➤ Answer:
31. What is BIOS an acronym for?
A. Bootstrap initial operation system
B. Basic input output startup
C. Boot initial operating startup
D. Basic input output system
➤ Answer:
32. What do you call a single point on a computer screen?
A. Cell
B. Element
C. Pixel
D. Bit
➤ Answer:
33. ASCII code of ‘A’ in decimal is:
A. 34
B. 98
C. 95
D. 65
➤ Answer:
34. Computers virus:
A. Can destroy files
B. Can effect installed program
C. Can destroy boot sector
D. All of the above
➤ Answer:
35. The output quality of a printer is generally measured by:
A. Dot per inch
B. Dot per meter
C. Dots printed per unit time
D. All of the above
➤ Answer:
36. Which of the following is the programming language?
A. MS-Word
B. Java
C. Ms-Access
D. VISIO
➤ Answer:
37. RJ-45 UTP cable has ____ cables.
A. 2 pair
B. 3 pair
C. 4 pair
D. 5 pair
➤ Answer:
38. Which one of the following printers is suitable for printing carbon copies?
A. Laser
B. Dot matrix Printer
C. Ink-jet
D. Drum
➤ Answer:
39. A row or number used to identify storage location is called:
A. A byte
B. A record
C. An address
D. All of the above
➤ Answer:
40. Which of the following is a file attribute?
A. Hidden
B. Archive
C. Read only
D. All of the above
➤ Answer:
41. Which of the following is not an operating system?
A. Linux
B. Windows
C. Oracle
D. Dos
➤ Answer:
42. Which of the following is not a component of control panel?
A. Keyboard
B. mouse
C. Monitor
D. Printer
➤ Answer:
43. Short-cut key combination for closing windows is______
A. Ctrl +S
B. Alt + F4
C. Ctrl +V
D. F1
➤ Answer:
44. _____tool helps to reduce file access time from disk.
A. Scandisk
B. Disk Defragmenter
C. Backup
D. Format
➤ Answer:
45. Which of the following is not type of page margin?
A. Left
B. Right
C. Center
D. Top
➤ Answer:
46. Portrait and landscape are:
A. Page Orientation
B. Paper size
C. Page layout
D. All of the above
➤ Answer:
47. Which of the following is not a font style?
A. Bold
B. Italics
C. Regular
D. Superscript
➤ Answer:
48. A bookmark is an item or location in document that you identify as a name for future reference.
A. To add anchor in web page
B. To mark the ending of a paragraph of document
C. To quickly jump to specific location in document
D. To add hyperlinks in webpage
➤ Answer:
49. Thesaurus tool in MS Word is used for:
A. Spelling suggestions
B. Grammar options
C. Synonyms and antonyms words
D. All of the above
➤ Answer:
50. What is the purpose of inserting header and footer in document?
A. To enhance the overall appearance of the document
B. To mark the starting and ending of page
C. To make large document more readable
D. To allow page headers and footers appear on document when printed
➤ Answer:
1. Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004 ?
A) Workday B) Date C) Networkdays D) All of the above
➤ Answer:
2. Which button do you click to add up a series of numbers?
A) The autosum button
B) The formula button
C) The quicktotal button
D) The total button
➤ Answer:
3. Which command will you choose to convert a column of data into row?
A) Cut and Paste
B) Edit>Paste Special> Transpose
C) Both of above
D) None of above
➤ Answer:
4. Which of the following is an example of relative cell address?
A) B9 B) D$9 C) $F5 D) $M$2
➤ Answer:
5. …….. is a collection of data stored in a standardized format, designed to be shared bymultiple users.
A) Database
B) Record
C) Database Management System
D) Relation
➤ Answer:
6. The Column of a table is referred to as the …….
A) Tuple B) Attribute C) EntityD) Degree
➤ Answer:
7. A Field or group of fields that uniquely identifies every roe of a table is…….
A) Primary KeyB) Foreign KeyC) Hot Key D) Access key
➤ Answer:
8. Which is the best file organization when data is frequently added or deleted from a file?
A) Sequential
B) Direct
C) Index sequential
D) None of Above
➤ Answer:
9. …….. operator is used to compare a value to a list of literals values that have been specified.
A) LikeB) CompareC) Between D) In
➤ Answer:
10. What is the default extension of PowerPoint Presentation?
A) prnB) docC) docx D) ppt
➤ Answer:
11. Which key is used to view slide show?
A) F1 B) F2 C) F5D) F1
➤ Answer:
12. Which file format can be added to a powerpoint show?
A) .jpg B) .gif C) .wav D) All of the above
➤ Answer:
13. Full form of HTML is …..
A) Hypertext Markup Language
B) HoTMail
C) Hyoertext Mail Language
D) All of the Above
➤ Answer:
14. ….. is a standalone tag (i.e. does not have closing tag) .
A) <font>B) <hr>C) <b>D) <table>
➤ Answer:
15. To set the background color we use:
A) <Body text=”Color”>
B) <Body=”color”>
C) <Body bgcolor=”color”>
D) All of the above
➤ Answer:
16. Numbers are stored and transmitted inside a computer in …..
A) Binary form
B) ASCII Code form
C) Decimal form
D) Alphanumeric form
➤ Answer:
17. Each IP packet must contain
A) Only source address
B) Only destination address
C) Source and destination address
D) Source or destination address
➤ Answer:
18. How many bits are there in the Ethernet address?
A) 64 bits B) 48 bitsC) 32 bitsD) 16 bits
➤ Answer:
19. A central computer surrounded by one of more satellite computers is called a
A) bus network.
B) ring network
C) star network
D) All of the above
➤ Answer:
20. The two types of record access methods are:
A) Sequential and random
B) Sequential and indexed
C) Direct and immediate
D) Online and real time
➤ Answer:
21. The least significant bit of the binary number, which is equivalent to any odd decimal number is:
A) 0 B) 1C) 1 or 0D) 3
➤ Answer:
22. Laptop computers use:
A) CRT Display
B) LCD display
C) SSGA displays
D) None of the previous
➤ Answer:
23. A hard copy would be prepared on a
A) Line printer
B) dot matrix printer
C) Typewriter terminal
D) All of the above
➤ Answer:
24. Fifth generation computer is also known as
A) Knowledge information processing system
B) Very large scale integration (VLSI)
C) Both of above
D) None of above
➤ Answer:
25. Reading data is performed in magnetic disk by
A) Read/write heads
B) Sectors
C) Track
D) Lower surface
➤ Answer:
26. Which of the following is not a type of software?
A) System software
B) Application Software
C) Utility Software
D) Entertainment software
➤ Answer:
27. An approach that permits the computer to work on several programs instead of one is
A) On-line thesaurus
B) Multiprogramming
C) Overlapped processing
D) Outline processor
➤ Answer:
28. A Hybrid computer
A) Resembles digital computer
B) Resembles analog computer
C) Resembles both a digital and analog computer
D) None of the above
➤ Answer:
29. The personal computer industry was started by
A) IBMB) Apple C) Compaq D) HCL
➤ Answer:
30. Which is the operating system program?
A) WindowsB) Ms-wordC) MS-excelD) Ms-PowerPoint
➤ Answer:
31. Format command is used to
A) Prepare a blank disk
B) Create a new blank disk from a used one
C) Both of above
D) None of the above.
➤ Answer:
32. Function of operating system
A) Memory Management
B) Document preparation
C) web page designing
D) All of above
➤ Answer:
33. Full form of MS-DOS is
A) Micro System disk Operating System
B) Micro Simple Disk Operating System
C) Microsoft Disk Operating System
D) Micro Sort Disk Operating System
➤ Answer:
34. In Windows system, if the displayed system time and date system is wrong you can Reset it using
A) Write
B) Calendar
C) Card file
D) Control Panel
➤ Answer:
35. Page formatting which is used frequently in future is saved as ….
A) Master document
B) Theme
C) Cross-reference
D) Template
➤ Answer:
36. Shortcut key for manual column break in ms word .
A) Ctrl + EnterB) Shift + spacebarC) Ctrl + Shift+ EnterD) Alt + Enter
➤ Answer:
37. Ctrl + Shift + D
A) Double Paragraph Spacing
B) Delete Current word
C) Dotted Underline
D) Double Underline
➤ Answer:
38. Which of the following is feature of MS-word?
A) Drag and Drop B) Text Wrap C) Find and replace D) All of the above.
➤ Answer:
39. ….. increases the readability of text
A) Save B) Bullet and numbering C) Thesaurus D) Help
➤ Answer:
40. Which is not the type of indent available in ms-word?
A) Right Indent B) Left Indent C) Center IndentD) Hanging indent
➤ Answer:
41. Page numbering is inserted as……
A) FootnoteB) Endnote C) Footer D) none of above
➤ Answer:
42. Leader character is associated with
A) Bullet & numbering B) GutterC) Indent D) Tab
➤ Answer:
43. Pressing F8 key for three times selects
A) A word B) A sentence C) A Paragraph D) Entire document.
➤ Answer:
44. Which of the following is graphics solution for word processors?
A) Clipart B) WordArt C) Drop Cap D) All of the above
➤ Answer:
45. Which of the following options is not available to remove arrows of formula Auditing?
A) Remove precedent arrows
B) Remove dependent arrows
C) Remove all Arrows
D) Remove all arrows for this cell
➤ Answer:
46. The minimum and maximum value you can set for save Auto Recovery Info in electronic spreadsheet are
A) 1 and 120 minutes
B) 0 and 120 minutes
C) 2 and 60 minutes
D) 1 and 10 minutes
➤ Answer:
47. Formatting a cell in Currency, you can specify
A) Decimal places
B) Currency Symbol
C) Both of above
D) None of above
➤ Answer:
48. What term refers to a specific set of values saved with the workbook?
A) Range B) ScenarioC) Trend lineD) What-if-analysis
➤ Answer:
49. To insert three columns between columns D and E you would
A) Select column D
B) select column E
C) Select Columns E,F and G.
D) Select columns D, E and F
➤ Answer:
50. You can add an image to a template by clicking the insert picture from file button on the…….. toolbar
A) Standard B) FormattingC) Drawing D) Picture
➤ Answer:
