PSC Old Question Collection

Lok Sewa Aayog Computer Operaror Examination 2074
PSC Old Question Collection

1. The function is used to replace existing text with new text

Replace

Substitute

Substring

String

2. Tab scrolling button

Allow you to view a different worksheet

Allow you to view a additional worksheet rows down

Allow you to view additional worksheet columns to the right

Allow you to view additional sheets tabs

3. The function extract data stored in a pivot table

Getpivotdata

Getdata

Pivotdata value

Datavalue

4. In maximum, how many sheets can be set as default while creating new workbook?

254

255

256

No limit

5. The result of data processing is

Database

Information

Knowledge

Records

6. To remove a relation from an SQL database, we use the command

Delete

Purge

Remove

Drop table

7. How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data?

Query wizard

Look up wizard

Form wizard

Report wizard

8. A field can be called as in relation context

Random file

Direct file

Attribute

Tuple

9. Every table in relational database contain a field or combination of field that can uniquely identify each records, it is called

Foreign key

Native key

Composite key

Primary key

10. The option is used to save Power Point Presentation in PDF with 4-slides per page

Slides

Handouts

Note pages

Outlines view

11. Which view shows all slides in one screen?

Slide master

Slide sortor

Slide layout

Slide show

12. To insert a new slide in the current presentation, we can choose

Ctrl + M

Ctrl + N

Ctrl + 0

Ctrl + F

13. A webpage displays a picture. What tag was used to display that picture?

Picture

Image

Img

Src

14. Using only HTML, we can create

Dynamic web pages

Static web pages

Both

None

15. What is the correct HTML, for creating a hyperlink?

<a href=https://nepalitechs.com> Nepali Techs </a>

<a url=”https://nepalitechs.com”> Nepali Techs</a>

<a> https://nepalitechs.com </a>

<a name=https://nepalitechs.com> Nepali Techs </a>

16. Which of the following have low failure rate?

Mechanical devices

Electronic devices

Electro-Mechanical devices

None

17. The main function of the ALU is to

Perform arithmetic and logical operation

Store data and information for future use

Control computer output, such as printing

Monitor all computer activities

18. What is light pen?

A mechanical input device

optical input device

Electronic input device

Optical output device

19. Which of the following is suitable after you install new drivers?

Shut down

Restart

Sleep

Hibernate

20. CD-ROM stands for

Compactable Read Only Memory

Compact Data Read Only Memory

Compact Disk Read Only Memory

Compactable Disk Read Only Memory

21. Which is a compiler?

A compiler does a conversion line by line as the program is run

A compiler converts the whole of a higher level program code into machine code in one step

A compiler is a general purpose language providing very efficient execution

None of the above]

22. What is the most common tool used to restrict access to a computer system?

User logins

Passwords

Computer key

Access-control software

23. As compared to the secondary memory, the primary memory of a computer is

Large

Cheap

Fast

Slow

24. Junk e-mail is also called

Spam

Spoof

Sniffer

Worm

25. Network congestion occurs

In case if traffic overloading

When a system terminates

When connection two nodes terminates

None of the above

26. What type of resources is most likely to be shard common resource in a computer?

Printer

Speaker

Keyboard

Floppy disk drive

27. Man is a

Cost

Company

Network

Country

28. Communication channel is shared by all the machines on the network is

Broadcast network

Unicast network

Multicast network

None of the above

29. In internet terminology IP means

Internet provider

Internet protocol

Internet procedure

Internet processor

30. A Microsoft Windows is

Operating system

Graphic program

Database program

31. When you turn on your computer, it will check on which of the following control files?

Command.com, io.sys

Command.com, date.com, dir.com

Command.com, io.sys, msdos.sys

Chkdsk.exe

32. The … program compresses large files into a smaller files.

WinShrink

WinZip

WinStyle

None of the above

33. The main function of the command interpreter is

To get and execute the next user-specified command

To provide the interface between the API and application program

To handle the files in operating system

None of the above

34. Only filename and extensions are to be displayed in wide format, which command you’ll use?

Dir/w

Dir a:

Dir/s

Dir/b

35. Which of the following is not valid version of MS Office?

Office XP

Office vista

Office 2007

None of the above

36. Background color or effects applied on a document is not visible in

Web layout view

Print layout view

Reading view

Print preview

37. What is gutter margin?

Margin that is added to the left margin when printing

Margin that is added to the right margin when printing

Margin that is added to the binding side of page when printing

Margin that is added to the outside of the page when printing

38. What is the shortcut key to open Open Dialog Box?

F12

Shift + F12

Alt + F12

Ctrl + F12

39. Which of the following is not a type of page margin?

Left

Right

Center

Top

40. Which of the following statement is false?

You can set different header and footer for last page of a section

You can set different head footer for even and odd pages

You can set different page number formats for different functions

You can set different header footer for fist page of section

41. The space at the end of a page is called

Footer

Margin

Bottom

Endnote

42. In which view header and footer are visible?

Normal view

Page layout view

Print layout view

Draft view

43. Which of the following is not of the merge process?

Sort the data source records

Merge the two files to print or create a new document

Edit a data source

Format a main document

44. Which of the following is not a font style?

Bold

Italics

Regular

Superscript

45. The intersection of a column and a row on a worksheet is called

Workbook

Worksheet

Cell

Address

46. Which function is used to calculate depreciation, rates of return, future value and loan payment amount?

Logical

Financial

Statistical

Math and trigonometry

47. Which language is used to create macros in excel?

Visual Basic

C

Java

Visual C++

48. In Excel, which one denotes a range from B1 through E5?

B1-E5

B1:E5

B1 to E5

B1$E5

49. Which tool is used to join some cells and place the content at the middle opened cell?

Wrap text

Center alignment

Merge and center

Shrink to fit

50. In the formula, which symbol specifies the fixed columns or rows?

$

*

%

&

1 thought on “PSC Old Question Collection”

Leave a Comment