Solved Question Paper of Computer Technician Exam 2016

Public Service Commission

Computer Technician Exam  2073

Competitive Written Exam Held on 2073-02-06

Time: 45 minutes
FM: 50
Key: C
Objective Questions (50 x 1 = 50 marks)
Correct Answers are Marked as Bold

1. Feature that enables several people to work to create and update a document
   A) Document sharing     B) Document locking     C) Document collaboration    D) Document protection
2. You can Break column by pressing
   A) Ctrl+Shift+Enter     B) Ctrl+Enter    C)Alt+enter    D) Alt+ Enter
3. The shortcut key to copy format is:
   A) Ctrl+Shift+C     B) Alt+Ctrl+C    C)Alt+Shift+C    D) None of above
4. Which of the following is NOT valid page margin
   A) Mirrored     B) Narrow   C)English    D) wide
5. What function displays row data in a column or column data in row?
   A) Hyperlink     B) Index    C)Transpose    D) Rows
6. Each excel file is called a workbook because
   A) It can contain text and data     B) It can be modified    C)It can contain many sheets including worksheets and chart sheets    D) You have to work hard to create it
7. A Typical spreadsheet software allows at least
   A) 64 Columns     B) 128 columns    C) 256 columns    D) 52 columns
8. Which of the following methods cannot be used to edit the content of cell?
   A) Pressing the Alt Key     B) Clicking the formula bar    C) Pressing F2     D) Double clicking the cell
9. How should you print a selected area of a worksheet, if you'll want to print a different area next time?
   A) On the file menu, Pint to print area, and then click set Print area.
   B) On the file menu, Click print and then click selection under print area.
   C) On the view menu, Click custom views, then click add
   D) All of the above
10. In MS Power Point,....... is readymade styles that can be used for a presentation
    A) Auto Style    B) Template    C) Wizard    D) Preformatting
11. Which view in Power Point can be used to enter Speaker Comment?
    A) Notes Page view   B) Slide sorter    C) Normal   D) Slide Show
12. The values GET, POST,HEAD etc are specified in ....... of HTTP message.
    A) Request Line    B) Header Line    C) Status Line    D) Entity Body
13. A Web Cookie is a small piece of data
    A) Sent from a website and stored in user's web browser while a user is browsing a website
    B) Sent from user and stored in a server while a user is browsing a website
    C) Sent from root server to all servers
    D) None of the mentioned
14. How can you make a bulleted list ?
    A) <list>    B) <NL>    C) <ul>    D) <ol>
15. Text within <EM>…..</EM> tag displays text in ……. Format.
    A) Bold    B) Italic    C) List    D) indented
16. Software that defines a database, stores the data, supports a query language produces reports and creates data entry screens is a
    A) Data Dictionary    B) Database Management System (DBMS)   C) Decision Support System    D) Relational Database
17. When building database, the data dealing with an entity is modeled as a:
    A) Attribute    B) Class   C) Object    D) Table
18. Student and course enrolled is an example of
    A) One-to-one relationship    B) One-to-many Relationship   C) Many-to-one  Relationship    D) Many-to-many Relationship
19. Given the following relation
    Student(roll no, name, course no, course max. marks, year of study, address)
    The corresponding 3 NF relations are
    A) Student(roll no, name, year of study, address) Course (Course no, course Max marks
    B) Student( roll no, name year of study, address) Student( roll no, course no)Course( Course no, course max. marks)
    C) Student(roll no, name, address) Year(roll no, year of study) Course(Course no, course max. marks)
    D) None of the above
20. Which of the following term describes testing?
    A) Finding Broken code    B) Evaluating deliverable to find errors   C) Stage of all projects    D) None of above
21. Which of the following manuals is not a user documentation?
    A) Beginner’s guide    B) Installation guide   C) Reference guide    D) SRS
    (SRS provides information on exact requirements of system as agreed between user and developers.)
    
22. Data flow diagram is related to
    A) Data Design    B) Process Design   C) UI design    D) Database Schema
23. “Digital Signature” issued by
    A) Controller    B) Certifying Authority   C) Subscriber    D) Department of Information Technology
24. For Digital signature key pair is generated by
    A) Asymmetric crypto system    B) Symmetric crypto system   C) RSA    D) None of the above
25. License of certifying authority is issued by
    A) Nepal Government    B) Controller   C) Department of IT    D) Ministry of Science and Technology
26. An area of a computer that temporarily holds data waiting to be processed is ……
    A) CPU    B) Memory   C) Storage    D) File
27. Hard disk can be used as……
    A) Input Device    B) Output device   C) Storage Device    D) All of the above
28. Unicode standard is ……..
    A) Software    B) Font   C) Character Encoding System    D) Keyboard Layout
29. A fault in a computer program which prevents it from working correctly is known as
    A) Boot   B) Bug   C) Biff    D) Strap
30. The difference between people with access to computers and the internet and those without this access is known as the:
    A) Digital Divide    B) Internet divide   C) web divide    D) E-illiteracy
31. Cache Memory…….
    A) Helps to store more data in hard disk    B) Place between main memory and microprocessor   C) stores data permanently    D) Holds late time visited web site only
32. Which one of the following printers is suitable for printing sprocket fed carbon copies?
    A) Laser    B) Dot Matrix   C) Ink-jet    D) Drum
33. HDMI Stands for
    A) High Definition Machine Interface    B) High Definition Machine Interconnection    C) High Definition Multimedia Interface    D) High Definition  Manual Interface
34. When RJ 45 jack is clamped with UTP-4 pair cable, it is understood that following PIN are responsible for reception and transmission
    A) 1,2 3,4    B) 1,2 3,6   C) 1,2 7,8    D) 5,6 7,8
35. If a computer presentation is required to be displayed in local monitor and LCD projector simultaneously, the setup chosen in windows display setting is
    A) Split Screen    B) Projector only   C) LCD mode   D) Duplicate Screen
36. What command can be used to find out network route/path for internet connection
    A) tracert    B) ping   C) nslookup   D) net use
37. Computer not booting at all, beeping endlessly is symptom of
    A) BAD RAM    B) BAD Network Card   C) Network Cable Fault   D) HDD bad sector
38. Bridge works in which layer of OSI model?
    A) Application Layer    B) Transport layer   C) Network Layer    D) Datalink layer

See Full Question Here

Read More

Solved Question Paper of Computer Operator Exam 2073

Public Service Commission

Computer Operator Exam  2073

Competitive Written Exam Held on 2073-01-29

Time: 45 minutes

FM: 50

Key: A

Objective Questions (50 x 1 = 50 marks)

Correct Answers are Marked as Bold

1. IBM 1401 was brought to prepare the census report of ...
   A) 2018 BS        B) 2028 BS        c)2038 BS           D) 2048 BS
2. Transistor is related to ….. generation computers
   A)  Second       B) Third        C) Fourth          D) Fifth
3. The ability to recover and read deleted or damaged files from a criminal’s computer is an example of an enforcement specially called
   A) Robotics       B) Simulation       C) Computer forensics        D) Animation
4. An area of a computer that temporarily holds data waiting to be processed is
   A) CPU        B) Memory       C) Storage       D) File

5. For reproducing sound, a CD (compact disk) audio player uses a …..
   A) Quartz crystal   B) Titanium needle  C) Laser beam  D)Barium Titanium Ceramic

6. Unicode Standard is ….
   A) Software      B) Font  C) Character encoding system     D)Keyboard layout
7. A fault in a computer program which prevents it from working correctly is known as
   A) Boot      B) Bug     C) Biff      D) Strap

8. Program developed according to the requirement specific to an office is …
   A) Tailored software    B) Utility software  C) Packaged software    D) All of above
9. The difference between people with access to computers and the internet and those without these access is known as the
   A) Digital divide    B) Internet divide    C) Web divide       D) E-Illiteracy
10. Cache memory …..
    A) Helps to store more data in hard disk     B) Placed between main memory and microprocessor      C) Stores data permanently     D) Holds last time visited data only

11. Which one of the following printers is suitable for printing sprocket fed carbon copies?
    A) Laser    B) Dot matrix     C) Ink jet       D) Drum
12. …… are set of rules and procedures to control the data transmission over the internet
    A) IP address     B) Domains    C) Protocol    D) Gateway

13. Which of the following is a file attribute?
    A) Hidden     B) Achieve     C) Read only    D) All of above
14. …… are used to identify a user who returns to a website?
    A) Cookies     B) Plug-ins    C) Scripts   D) Session
15. Windows 7 supports which of the following file system?
    A) NTFS     B) FAT  C) EXIT   D) UNIX
16. Which among the following are the best tools for fixing errors in disk
    A) Fdisk      B) Scandisk     C) Chkdisk  D) Fixdisk
17. …… runs on computer hardware and serve as platform for other software to run on
    A) Operating system    B) Application software    C) System software D) All of above
18. The operating system creates ….. from the physical computer
    A) Virtual space     B) Virtual computers    C) Virtual device    D) None of above

19. The primary function of an operating system is
    A) To make the most efficient use of the computer hardware
    B) To allow people to use the computer
    C) To keep system programs employed
    D) To make computers easier to use
20. Thesaurus tool in MS Word is used for
    A) Spelling suggestions      B) Grammar options
    C) Synonyms and antonyms word     D) All of above
21. Which tab in Font dialog box contains options to apply font effects?
    A) Font tab     B) Character spacing    C) Text effects    D) Standard toolbar
22. Which of the following is not of the merge process?
    A) Sort the data source records       B) Format the main document
    C) Edit the data source       D) Merge the two files to print or create a new document
23. A screen element of MS Word that is usually located below the title bar that provides categorized options is.....
    A)  Menu bar    B) Tool bar   C) Status bar   D) All of above
24. A word processor would most likely be used to do
    A) Keep an account of money spent
    B) Do a computer search in media center
    C) Maintain an inventory
     D) Type a biography
25. If you need to change the typeface of a document, which menu will you choose?
    A) Edit    B) View   C) Format    D) Tools
26. ….. is a tool in Word which apply same format to different character/paragraphs?
    A) Format repeater B) Format applier    C) Format painter   D) Format generator
27. …. Switch the page between portrait and landscape layout
    A) Margins    B) Size     C) Columns   D) Orientation
28. …. Enables several people to work to create and update a document
    A) Document sharing     B) Document locking     C) Document collaboration    D) Document protection
29. When a hyperlink is created, Word formats the web address as …..
    A) Italicized and colored red      B) Italicized and colored blue
    C) Underlined and colored red   D) Underlined and colored blue

30. Workbook is collection of
    A) Cells    B) Worksheets   C) Workspaces    D) Projects
31. Shortcut key to bring format cells dialog box is:
    A) Ctrl+F    B) Ctrl+E     C) Ctrl+1    D) Ctrl+D

32. The cell reference $A$5 is a …..
    A) Relative cell reference       B) Absolute cell reference    
    C) Mixed cell reference          D) None of above
33. Function to get some of the contents of the cells A1, A2, B1, B2 is ….
    A) =sum(A1+A2+B1+B2)      B) =sum(A1:B2)
    C) =total(A1..B2)                   D) =sum(A1,B2)
34. To edit the contents of cell
    A) Press F2           B) Double click on cell
    C) Click on Formula bar      D) All of above
35. Graphical representation of worksheet data
    A) Pivote table        B) Goal seek         C) Graph      D) Scenario
36. Filter option is used to ….
    A) Arrange data in alphabetical order
    B) Arrange data in numeric order
    C) Arrange data in chronological order
    D) Extract the records that meet given criteria

37. The formula =if(A1>B1, A1-B1, B1-A1) gives
    A) Larger one from cell A1 & B1
    B) Positive difference of A1 & B1
    C) Contents of A1
    D) Contents of B1
38. How do you display updatable current date in MS Excel?
    A) DATE()     B) TODAY()    C) NOW()   D) Ctrl+;
39. A function inside another function is called
    A) Nested function      B) Round function
    C) Sum function           D) Text function
40. What are the different views to display a table?
    A) Datasheet view             B) Design view
    C) Pivot table and pivot chart view     D) All of above
41. In a database table, the category of information is called
    A) Tuple     B) Field    C) Record      D) All of above
42. This key uniquely identify each record
    A) Primary key   B) Key record    C) Unique key   D) Field name
43. ….. enables you to view data from a table based on a specific criterion
    A) Form   B) Query    C) Macro    D)  Report
44. 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
45. In Microsoft PowerPoint in order to see all the slides on one screen you use
    A) View, slide sorter     B) View, slide    C) View, master    D) View, slide show

46. What are the three options available in Insert >> Picture menu
    A) Clipart, Pictures, Shapes        B) Clipart, From file, Shapes
    C) Clipart, From file, Autoshapes    D) Clipart, Pictures, Autoshapes
47. Which of the following font effect is not available in PowerPoint font dialog box?
    A) Underline    B) Shadow    C) Emboss    D) Strikethrough
    Note:-  Strickethrough is not available in 2003 version But Emboss is available and  Emboss is  not available but strickethrough is available in 2007 or above version.
    
    
48. Full form of HTML is
    A) Hypertext Markup Language      B)  Hotmail
    C) Hypertext Mail Language          D) All of above

49. In HTML ….. tag is used for linking an external document
    A) <src>     B) <anchor>    C) <a>   D) <include>
50. To set the background color we use
    A) <body text=“color”>      B) <body=“color”>   C) <body bgcolor=“color”>    D) All of above

Note:- Answers are Based on different websites.

The End

Read More

Solved Question Paper of Karmachari Sanchaye Kosh 2072

Karmachari Sanchaya Kosh
Computer Operator

Open Competition Written Examination

Time: 45 Minutes                                        Level: 5                                                                FM: 50

Select the correct answer and write in answer sheet. (50 x 1 = 50)

Correct Answers are marked as BOLD text.

1. Sped of Printer is measured in
   a. FPM
   b. PPM
   c. CPI
   d. MPI
2. Joystick is …. Kind of device
   a. input
   b. output
   c. processing
   d. storage
3. Abbreviation CAD stands for
   a. Computer Aided Definition
   b. Calculator Aided Design
   c. Computerized At Destruction
   d. Computer Aided Design
4. In display unit the ratio 1024 x 800 is known as
   a. Aspect Ratio
   b. PPM
   c. DPI
   d. BIT
5. ASCI value of character ‘a’ is
   a. 95
   b. 96
   c. 97
   d. 98
6. Which of the following is not the part of the CPU?
   a. Arithmetic Logical Unit
   b. Control Unit
   c. Hard Disk
   d. Cache Memory
7. Which of the following is fastest memory?
   a. DVD
   b. Hard Disk
   c. RAM
   d. Cache
8. 10 Seconds is equal to
   a. 100 milli-sec
   b. 0.001 milli-sec
   c. 1000 milli-sec
   d. 10000 milli-sec
9. POST stands for
   a. Public Outlay Software Test
   b. Power Outage Survival tool
   c. Peripheral Output Standard Terminal
   d. Power on Self Test
10. Highest Speed Network Media is?
    a. Satellite
    b. Microwave
    c. Optical Fiber
    d. CAT6e
11. An IP address in IP v4 is of
    a. 2 bytes
    b. 3 bytes
    c. 4 bytes
    d. 6 bytes
12. Which of the following statement regarding the optical fiber is false
    a. It is less prone to interference than copper wires
    b. It can transmit data to a longer distance than copper wires
    c. It is cheaper than copper wire
    d. It can support more band-width than copper wire
13. The default subnet mask for the Class 3 networks
    a. 255.255.0.0
    b. 255.0.0.0
    c. 255.255.255.128
    d. 255.255.255.0
14. Which command is used to copy files?
    a. copy
    b. type
    c. ren
    d. diskcopy
15. To copy the hidden system files of DOS to another disk, you can use the command
    a. Copy
    b. Sys
    c. Ren
    d. Diskcopy
16. Which command is used to confirm before deleting the directory?
    a. Deltree
    b. Del *.*/p
    c. Deltree/f
    d. Erase *.*
17. Which is the best tool for fixing errors on disk?
    a. fdisk
    b. chkdsk
    c. scandisk
    d. fixdisk
18. What is the name of the batch file that automatically runs when MSDOS is booted?
    a. run.bat
    b. config.bat
    c. config.sys
    d. autoexec.bat
19. Which command is used to display a list of deleted files that DOS can undelete
    a. Undelete *.*
    b. Undelete/list
    c. Undelete/all
    d. None of the above
20. Which feature of MS Word enables to send the same letter to different persons?
    a. macros
    b. mail merge
    c. template
    d. none
21. Which of the following is not a font style?
    a. bold
    b. regular
    c. italics
    d. superscript
22. Which of the following is used to change margins?
    a. Formatting toolbar
    b. standard toolbar
    c. page setup dialog box
    d. paragraph dialog box
23. What is the shortcut key to display field codes?
    a. Alt+F9
    b. Shift+F9
    c. Ctrl+F9
    d. Space+F9
24. What is placed to the left of horizontal scroll bar
    a. Tab stop buttons
    b. Split buttons
    c. View buttons
    d. indicators
25. What is the maximum number of lines set for “lines to drop box”?
    a. 3
    b. 10
    c. 5
    d. 15
26. What is the shortcut key for “Find and Replace” dialog box?
    a. Ctrl + F
    b. Ctrl + R
    c. Ctrl + H
    d. Ctrl+Shift+F
27. What is the shortcut key to “Superscript” the selected text?
    a. Ctrl + =
    b. Ctrl + Shift + =
    c. Ctrl + –
    d. Ctrl + shift + –
28. By default, document in MS Word prints with
    a. 1 inch top margin
    b. 1. Inch bottom margins
    c. A portrait orientation
    d. All of above
29. What is the shortcut key for spelling check in documents?
    a. F7
    b. Ctrl+F7
    c. Shift+F7
    d. Alt+F7
30. What is gutter margin?
    a. Margin that is added to the left margin when printing
    b. Margin that is added to the binding side of page when printing
    c. Margin that is added to the right margin when printing
    d. Margin that is added to the outside of the page when printing
31. Which of the following is not available in Font spacing?
    a. Normal
    b. Condensed
    c. Loosely
    d. Expanded
32. Which feature is used to create a newspaper like document?
    a. Bullets & Numbering
    b. Columns
    c. Tables
    d. Tap Stops
33. Which of the following is an absolute cell reference?
    a. $A$1
    b. #A$1
    c. &A1$
    d. #A1#
34. Getting data from a cell located in a different sheet is called
    a. Accessing
    b. referencing
    c. Updating
    d. Functioning
35. The number of rows in a worksheet of Excel 2003 is
    a. 36500
    b. 65536
    c. 64536
    d. None of above
36. Multiple Calculations can be made in a single formula using:
    a. Standard Formula
    b. Complex Formula
    c. Array Formula
    d. Smart Formula
37. …. is used to select multiple non-adjacent cell in a worksheet
    a. CTRL key
    b. Shift key
    c. Alt key
    d. Tab key
38. Conditional count can be performed using
    a. countif
    b. ifcount
    c. countiff
    d. iffcount
39. Charts in worksheet itself is known as
    a. Embedded chart
    b. Inserted chart
    c. Implied chart
    d. Overlapping chart
40. Invalid Formula category in EXCEL is
    a. Conditional
    b. Statistical
    c. Graphical
    d. Financial
41. What is the output of the text function =MID(“regression”, 3,2)?
    a. gre
    b. egr
    c. re
    d. gr
42. The technique which defines a set of values acceptable for the field is known as
    a. verification
    b. acceptance
    c. validation
    d. setting
43. Which of the following is the property of Primary key?
    a. Duplicate
    b. Unique
    c. Pictorial
    d. Limited
44. Technique of displaying only those records that meet the defined criteria is known as
    a. Selecting
    b. Filtering
    c. Separating
    d. Differentiating
45. Data Definition Language (DDL) includes
    a. Creating Table
    b. Select Query
    c. Data Insert
    d. All of above
46. A data manipulation command that combines the records from one or more table is called
    a. SELECT
    b. PRODUCT
    c. JOIN
    d. PROJECT
47. What is the maximum number of slides that can be printed in a handouts
    a. 4
    b. 6
    c. 9
    d. 12
48. What is the shortcut key to add a new slide in a presentation
    a. Crl+N
    b. Ctrl + P
    c. Ctrl + M
    d. Ctrl + O
49. The arrangement of elements such as Title and subtitle Text, pictures, tables etc. is called
    a. layout
    b. Presentation
    c. Design
    d. Scheme
50. What function key is used for slide show
    a. F3
    b. F6
    c. F4
    d. F5

Note: Answer are based on source of different web site.

The End

Read More

HTML Basic Note Book

 

for documents on the World Wide Web since 1989. HTML documents are text HTML files that contain two parts: content that can be seen on a computer screen and markup or tags  (encoded information) that is generally hidden from the user.
HTML defines the structure and layout of a Web document by  using a variety of tags and attributes.
The correct structure for an HTML document starts with
<HTML>
<HEAD> (enter here what document is about & scripting language)</HEAD>
<BODY> and ends with </BODY>
</HTML>.
All the information you'd like to include in your Web page fits in between the <BODY> and </BODY>   tags. There are hundreds of other tags used to format and layout the information in a Web page. Tags are also used to specify hypertext links. These allow Web developers to direct users to other Web pages with only a click of the mouse on either an image or word(s).

HTML (Hyper Text Markup Language):-

Before Starting HTML we should know Hypertext Markup Language (HTML), in computer science, the standard text formatting language

SOME BASIC CONCEPTS

Internet:-

The internet is a new communication technology that influences us on large scale. The internet also called the Net, is the world’s largest network. It is not a single network but global interconnected network of networks providing free exchange of information. We can share data, ideas, files, without any discretion of age and country. Internet is also a source of software. We can download software within a few minutes.
Advanced Research Project Administration Net (ARPA Net) is the ancestor of the internet. The project was an experience in reliable networking and to link defense and military research contractors in Later when Tim Bereners Lee has developed www in 1990, then everyone can be able to use internet since 1992. From 1994, Nepal is also connected within a internet.

World Wild Web (WWW):-

World Wide Web, which is a part of the net, is a collection of web pages. It contains information that can be a combination of text, pictures and hyperlinks. In another it is a web server.

Webpage:-

Web page is a resource of information that suitable for World Wide Web and can be accessed through a web browser. This information is usually in HTML or XHTML format and may provide navigation to other through/ via hyperlink. It is a document, connected to the World Wide Web and view able by anyone  connected to the internet who has a web browser is known as web page.

Web Site:-

Web site is a very common terminology in WWW. A site refers to a particular location on the web and the collection of web is known as web site.

URL (Uniform Resource Locator):-

In short URL is a address of website. In another word URL is a global address of document and other  resources on the World Wide Web. The first part of the address is called a protocol identifier and it indicates what protocol to use. The second part is called a resources name and it specifies the IP address or domain name where the resources are located. The protocol identifier and resource name are separated by colon and two backward slashes.
For example:-
http://www.yahoo.com                            ftp://kaspersky.com/vob3.dat

Web Browser:-

The software that allows user to navigate the web and view HTML encoded document is known as web  browser. For example Internet Explorer, Opera, Firefox, Google Chrome etc.

Protocol:-

A set of rules and convention (principle) for sending information over a network is called protocol.

HTTP (Hyper Text Transfer Protocol):-

Http is a standard set of rules for processing hypertext links, exchanging files (like text, graphic, images, sound, video and multimedia) on the World Wide Web. It is used to transfer hypertext request and  information between server and clients through web browser.

Work of HTTP

• To create connection between server and client
• To send request To receive request/Reply
• To terminate/ close connection

How to create HTML Files:-

• Click on Start Menu and click on “Run” Option.
• Type “Notepad” in the text box of the run dialog box and click on ok
• Then save the file with extension “.html”(extension must be defined)
• At last click on “save” button.

How to open HTML Files:-

• Just double Click on the html file

How to Edit HTML Files:-

• Open html file.
• Then click on “View” menu, click on “Source” option.
• Edit your document in notepad application.

How to define HTML tags in notepad:-

<html>

<head>

<title>

----------   Write title of the webpage here.

</title>

----------

-----------    Enter here what document is about & scripting language.

</head>

<body>

----------   All the information you'd like to include in your Web write here.

-----------

</body>

</html>

For more detail Please Download HTML Basic Note Book        Download

Read More

Computer Operator Exam 2072

Public Service Commission

Computer Operator Exam  2072

Competitive Written Exam Held on 2072-03-05

Time: 45 minutes

FM: 50

Key: B

Objective Questions (50 x 1 = 50 marks)

Correct Answers are Marked as Bold

1. Which function will calculate the number of worksays between 6/9/2004 and 8/12/2004 ?
      a. Workday      b. Date                 c. Networkdays                 d. All of the above
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
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
4. Which of the following is an example of relative cell address?
     a. B9    b. D$9                   c. $F5                     d. $M$2
5. …….. is a collection of data stored in a standardized format, designed to be shared by multiple users.
      a. Database        b. Record             c. Database Management System            d. Relation
6. The Column of a table is referred to as the …….
       a. Tuple       b. Attribute                        c. Entity                                d. Degree
7. A Field or group of fields that uniquely identifies every roe of a table is…….
       a. Primary Key       b. Foreign Key                   c. Hot Key                            d. Access key
8. Which is the best file (copied from subodhghimire.com.np) organization when data is frequently added or deleted from a file?
         a. Sequential          b. Direct                               c. Index sequential          d. None of Above
9. …….. Operator is used to compare a value to a list of literals values that have been specified.
       a. Like                  b. Compare                        c. Between                         d. In
10. What is the default extension of PowerPoint Presentation?
         a. Prn                     b. doc                    c. Docx                  d. Ppt
11. Which key is used to view slide show?
          a. F1                b.F2                      c. F5                       d. F1o
12. Which file format can be added to a powerpoint show?
        a. .jpg              b. .gif                     c. .wav                  d. All of the above
13. Full form of HTML is …..
        a. Hypertext Markup Language        b. HoTMail          c. Hyoertext Mail Language         d. All of the Above
14. ….. is a standalone tag (i.e. doesnot have closing tag).
           a. <font>               b. <hr>                 c. <b>                    d. <table>
15. To set the Background color we use:
           a. <Body text=”Color”>         b. <Body=”color”>           c. <Body bgcolor=”color”>         d. All of the above
16. Numbers are stored and transmitted inside a computer in …..
        a. Binary form      b.  ASCII Code form          c. Decimal form                 d. Alphanumeric form
17. Each IP packet must contain
         a. Only source address        b. Only destination address         c. Source and destination address    d. Source or destination address
18. How many bits are there in the Ethernet address?
         a. 64 bits          b. 48 bits              c. 32 bits                               d. 16 bits
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
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
21. The least significant bit of the binary (copied from subodhghimire.com.np)number, which is equivalent to any odd decimal number is:
           a. 0           b. 1         c. 1 or 0                 d. 3
22. Laptop computers use:
           a. CRT Display                b. LCD display    c. SSGA displays                                d. None of the previous
23. A hard copy would be prepared on a
            a. Line printer        b. dot matrix printer       c. Typewriter terminal   d. All of the above
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
25. Reading data is performed in magnetic disk by
         a.Read/write heads        b. Sectors            c. Track                 d. Lower surface
26. Which of the following is not a type of software?
           a. System software          b. Application Software       c. Utility Software      d. Entertainment software
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
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
29. The personal computer industry was started by
          a. IBM         b. Apple               c. Compaq           d. HCL
30. Which is the operating system program?
           a. Windows             b. Ms-word        c. MS-excel         d. Ms-PowerPoint
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.
32. Function of operating system
          a. Memory Management     b. Document preparation             c. web page designing   d. All of above
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
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
35. Page formatting which is used frequently in future is saved as ….
         a. Master document        b. Theme             c. Cross-reference           d. Template
36. Shortcut key for manual (subodhghimire.com.np) column break in ms word.
          a. Ctrl + Enter           b. Shift + spacebar           c. Ctrl + Shift+ Enter       d. Alt + Enter
37. Ctrl + Shift + D
           a. Double Paragraph Spacing         b. Delete Current word     c. Dotted Underline        d. Double Underline
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.
39. ….. increases the readability of text
            a. Save           b. Bullet and numbering                              c. Thesaurus       d. Help
40. Which is not the type of indent available in ms-word?
             a. Right Indent           b.  Left Indent    c. Center Indent                               d. Hanging indent
41. Page numbering is inserted as……
              a. Footnote          b.  Endnote          c. Footer              d. none of above
42. Leader character is associated with
              a. Bullet & numbering           b.  Gutter             C. Indent             d. Tab
43. Pressing F8 key for three times selects
           a. A word          b.  A sentence                    c. A Paragraph                   d. Entire document.
44. Which of the following is graphics solution for word processors?
            a. Clipart                 b. WordArt         c. Drop Cap                         d. All of the above
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
46. The minimum and maximum (subodhghimire.com.np) 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 1o minutes
47. Formatting a cell in Currency, you can specify
             a. Decimal places          b. Currency Symbol         c. Both of above                               d. None of above
48. What term refers to a specific set of values saved with the workbook?
              a. Range         b. Scenario         c. Trend line       d. What-if-analysis
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
50. You can add an image to a template by clicking the insert picture from file button on the…….. toolbar
           a. Standard          b. Formatting                     c. Drawing           d. Picture

------ Best of Luck------

Read More

Question Paper of Assistant Computer Operator of Public Service Commission (Bibidh Sewa) 2071

Public Service Commission

Assistant Computer Operator 2071

Competitive Written Exam Held on 2071-03-17

Time: 45 minutes

FM: 50

Key: C

Objective Questions (50 x 1 = 50 marks)

Correct Answers are Marked as Bold

       1.      Which of the following function key activates the Thesaurus?

    a) F5                        b) F7
    c) Shift+F7              d) F9

2.      Mail Merge is used to

     a) Combine two mails and create a word document                      
     b) Combine static information in one document with variable information in another document
    c) Combine mail in outlook express with word document

    d) Combine static contents of two documents

3.      Ctrl+ Shift + D is used for?
    a) Double Underline                          b) Wave underline
    c) Dotted Underline                             d) Dash Underline

4.      AutoCorrect was originally designed to replace_______ words as you type.
    a) Short, repetitive                               b) Grammatically incorrect
    c) Misspelled                                    d) None of the above

5.      A character that is raised and smaller above the baseline is known as?
   a) Outlined                                            b) Raised
   c) Superscript                                      d) Subscript

6.      What is the smallest and largest font size available in Font Size tool on formatting toolbar?
    a) 8 and 72                                            b) 8 and 64
    c) 12 and 72                                          d) none of above

7.      What is the shortcut key used for paste a content in windows word
      a) Ctrl + L                                             b) Ctrl + P
      c) Ctrl + V                                             d) Ctrl + O

8.      Which feature is commonly used for creating newspaper like format?
     a) Newspaper                                        b) Row
     c) Column                                             d) Format as newspaper

9.      Workbook is a collection of?
     a) cells                                                    b) worksheet
     c) Workspaces                                        d) Projects

10.  Short-cut key to bring format cells dialog box is :
a) Ctrl + F                                                                                                   b) Ctrl + E
c) Ctrl + 1                                                                                                   d) Ctrl + D

11.  The cell reference $A$5 is a………..?
a) Relative cell reference                                                                    b) Absolute cell reference
c) Mixed cell reference                                                                       d) None of above

12.  Function to get sum of the contents of the cells A1, A2, B1, B2 is ……?
a) =SUM(A1+A2+B1+B2)                                                                    b) =SUM(A1:B2)
c) =TOTAL(A1..B2)                                                                                 d) =SUM(A1,B2)

13.  To edit the contents of cell ……?
a) Press F2                                                                                                b) Double click on cell
c) Click on formula bar                                                                         d) All the above

14.  Graphical representation of worksheet data
a) Pivot Table                                                                                           b) Goal Seek
c) Graph                                                                                                     d) Scenario

15.  Filter option is used to ……..?
a) Arrange data in alphabetical order                                            b) Arrange data in numeric order
c) Arrange data chronological order                                               d) Extract the records that meet given criteria

16.  The formula =IF(A1>B1, A1-B1, B1-A1) gives
a) Larger one from cell A1 and B1                                                    b) Positive difference of A1 and B1
c) Contents of A1                                                                                   d) Contents of B1

17.  What is the short cut key to select entire row in Excel sheet?
a) Ctrl+ Spacebar                                                                                    b) Alt + Spacebar
c) Shift+ Spacebar                                                                                 d) Ctrl + Shift + Spacebar

18.  In Excel worksheet the Name Box:
a) Appears to the right of the menu bar                                      b) Appears to the bottom of the menu bar
c)Appears to the left of the formula bar                                     d) Appears with status bar

19.  Short-cut key Ctrl + Shift+; inserts ….. at the current cell.
a) Current Date                                                                                       b) Current Time
c) =TOTAL(A1..B2)                                                                                 d) =SUM(A1,B2)

20.  A box that identifies the patterns or colors that are assigned to the data series or categories in a chart
a) Data label                                                                                             b) Title
c) Data series                                                                                           d) Legend

21.  What are the different views to display a table :
a) Datasheet View                                                                                 b) Design View
c) Pivot Table & Pivot Chart View                                                    d) All of above

22.  Which of the field has width 8 bytes?
a) Memo                                                                                                   b) Number
c)Date and time                                                                                     d) Hyperlink

23.  Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship command?
a) File Menu                                                                                             b) View Menu
c) Database Menu                                                                                 d) Tools Menu

24.  Which Key combination is used to save slides?
a) Ctrl + R                                                                                                   b) Ctrl + X
c) Ctrl + S                                                                                                   d) Ctrl + W

25.  A file which contains readymade styles that can be used for a presentation is called
a) Auto Style                                                                                            b) Template
c) Wizard                                                                                                   d) Pre formatting

26.  Which of the following devices can be used to directly image printed text?
a) OCR                                                                                                        b) OMR
c) MICR                                                                                                      d) All of above

27.  The ALU of a computer responds to the commands coming from ……….
a) Primary Memory                                                                               b) Control section
c) External Memory                                                                              d) Cache Memory

28.  Memory address are represented by:
a) Character code                                                                                  b) Binary Codes
c) Binary word                                                                                         d) Parity bit

29.  Programs designed to perform specific task is known as
a) System software                                                                               b) Application Software
c) Utility programs                                                                                 d) Operating system

30.  Time during which a job is processed by the computer is.
a) Delay Times                                                                                         b) Real Time
c) Execution time                                                                                  d) Down Time

31.  The term gigabyte refers to
a) 1024 bytes                                                                                           b) 1024 kilobytes
c) 1024 megabytes                                                                                d) 1024 gigabyte

32.  To produce high quality graphic (hardcopy) in color, you would want to use a/n
a) RGB monitor                                                                                       b) Plotter
c) Ink-jet printer                                                                                     d) Laser printer

33.  In the IBM PC-AT, what do the words AT stand for
a) Additional Terminals                                                                        b) Advance technology
c) Applied technology                                                                          d) Advanced terminology

34.  An error in computer data is called
a) Chip                                                                                                        b) Bug
c)CPU                                                                                                          d) Storage device

35.  IBM 1401 is
a) First Generation Computer                                                          b) Second Generation Computer
c) Third Generation Computer                                                         d) Fourth Generation Computer

36.  UNIVAC is
a) Universal Automatic Computer                                                 b) Universal Array Computer
c) Unique Automatic Computer                                                       d) Unvalued Automatic Computer

37.  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

38.  Which of the following is first generation of computer?
a) EDSAC                                                                                                    b) IBM-1401
c) CDC-1604                                                                                              d) ICL-2900

39.  Which of the following memories has the shortest access times?
a) Cache Memory                                                                                  b) Magnetic Bubble Memory
c) Magnetic Core Memory                                                                 d) RAM

40.  In windows, to check disk for error and to repair, one can use
a) Disk Defragmenter                                                                           b) Format
c) Scandisk                                                                                                d) Antivirus

41.  The procedure to close the computer is called
a) Close                                                                                                      b) Exit
c) Go                                                                                                           d) Shutdown

42.  In MS Window to cycle through programs currently running, one can use
a) Shift + Tab                                                                                            b) Ctrl + Tab
c) Alt + Tab                                                                                               d) Tab

43.  To set local time and day-light saving in MS Window one has to open_____ in control panel
a) Fonts                                                                                                      b) Add Remove Program
c) Display                                                                                                   d) Regional Setting

44.  Operating system is also known as:
a) Database                                                                                              b) System software
c) Hardware                                                                                             d) Printer

45.  In MS-Word, format painter is used to:
a) Paint the background of text                                                       b) Paint the fore-ground of text
c) To copy the formatting and content                                        
d) To copy the formatting of one segment to other segment

46.  Which of the following is not a menu
a) Window                                                                                                b) Help
c) Tools bar                                                                                               d) Insert

47.  Which key should be pressed to start a new paragraph in MS Word?
a) Down cursor Key                                                                               b) Enter key
c) Shift + Enter                                                                                        d) Ctrl + Enter

48.  Which of the following bar is not available in MS-Word
a) Toolbar                                                                                                  b) Formula Bar
c) Status Bar                                                                                             d) Menu Bar

49.  Pressing F8 key for three times selects
a) A word                                                                                                  b) A sentence
c) A paragraph                                                                                         d) Entire document

50.  The Keystrokes Ctrl + I is used to
a) Increase font size                                                                             b) Inserts a line break
c) Indicate the text should be bold                                                 d) Applies italic format to selected text

J   BEST OF LUCK   J

Read More