Gandaki Province, Local Level Computer Operator 2078/11/14

 

Province Public Service Commission

Gandaki Province, Computer Operator(Local)

2078/11/14

The key of the question paper must be mentioned in the answer sheet. Failure to do so will result in cancellation of the answer sheet. Also, electronic devices like Calculator and Mobile will not be used in the exam.

1. How do you display current date and time in MS Excel?

a. =today( )

b. =now( )

c. =date( )

d. =time( )

2. The statistical analysis and visualization in Google Spreadsheet is

a. Richer than MS Excel

b. Limited than MS Excel

c. Not available

d. Powerful than MS Excel

3. Which of the following tag is used to and rows in the table?

a. <td> and </td>

b. <th> and </th>

c. <tr> and </tr>

d. <row> and </row>

4. The shortcut key to start presentation from the current slide is

a. F5

b. Shift + F5

c. Ctrl + F7

d. F7

5. In which method we don't need to specify the field type and size while creating a new table in MS Access?

a. Design view

b. While using wizard

c. Create table by entering data

d. All of the above

6. Which allows us to send same letter to different persons?

a. Macros

b. Mail merge

c. Template

d. None of the above

7. Bullet and numbering are in

a. Home tab

b. Insert tab

c. View tab

d. Page layout view

8. The command used to hide file "hello.txt" from existing explorer's view is

a. Attrib + h hello.txt

b. Attrib + a hello.txt

c. Attrib + r hello.txt

d. Attrib + s hello.txt

9. The number of wires used in CAT5 cable are

a. 5

b. 8

c. 6

d. 4

10. The set by ICT Policy 2072 to achieve digital literacy of Nepal was__percent by year 2020.

a. 68

b. 75

c. 60

d. 50

11. H5 in a spreadsheet means

a. Row 5 and column H

b. In row H, 5 is written

c. Row H, column 5

d. In column 5, 'H' is written

12. Which of the following refers to the user's part of the could computing system?

a. Back end

b. Managment

c. Infrastructure

d. Front end

13. The language that instructs the browser on how pictures to display the hypertext, and adds pictures to the document is

a. C

b. COBOL

c. HTML

d. BASIC

14. In the normal view, F11 can be used to__in MS PowerPoint.

a. Open navigator

b. Open content menu

c. Access setup options

d. Open the styles and formatting window

15. Which is the structure of the database

a. Relation

b. Table

c. Schema

d. None of the above

16. Which of the following is not essential function of word processor software?

a. Saving

b. Editing

c. Indexing

d. Formatting

17. Formatting a cell in number format you cannot set

a. Decimal places

b. Negative numbers

c. Currency symbols

d. Use 1000 separator

18. While working in a computer the screen was rotated by 90 degrees clockwise. What is the correct keyboard shortcut to restore screen?

a. Ctrl + Alt + I

b. Ctrl + Shift + I

c. Windows + Shift + I

d. Alt + Shift + I

19. The file extension for movie is not

a. MOV

b. MPEG-4

c. WEBM

d. MP3

20. A user copies a cell that contains the formula and pastes it another cell using Ctrl + V. The content of paste cell is a

a. Formula

b. Value

c. Empty value

d. Location

21. Rea-time meeting can be performed using Google Meet. Similar meetings can be conducted using

a. Microsoft outlook

b. Microsoft team

c. Microsoft one note

d. All of the above

22. The binary equivalent of decimal number 10 is

a. 1010

b. 0101

c. 0011

d. 1111

23. Function MS Excel worksheet represents the total number(s) of entries in the cell(s):

a. SUM

b. AVG

c. COUNT

d. TOTAL

24. The equivalent terminal command of "dir" in window to that of Linux terminal is

a. /dir

b. ds

c. /s

d. /d

25. A system to reduce data redundancy dependence, inconsistency and unauthorized access is

a. Records

b. DBMS

c. Passwords

d. Information security

26. Portrait and landscape are

a. Page orientation

b. Paper size

c. Page layout

d. Page margin

27. What is the shortcut key to delete a file permanently from computer without sending it to the Recycle bin?

a. Alt + Delete

b. Ctrl + Delete

c. Shift + Delete

d. Windows + Delete

28. Which program is used to provide software interface to hardware device?

a. System software

b. Application software

c. Device driver

d. All of the above

29. Which of the following IP address can be used as(a) loop-back address?

a. 0.0.0.0

b. 127.0.0.1

c. 192.168.1.0

d. 255.255.255.255

30. Which symbol must all the formula in MS Excel begin with?

a. @

b. =

c. +

d. -

31. Which attribute is used to identify the values of variables?

a. Text

b. Http

c. Content

d. Name

32. Student(ID), Name, Department Name, Tool(Credits) in this query which attribute from the primary key?

a. Name

b. Department name

c. ID

d. Total credits

33. Which of the following items can be inserted into Header and Footer of a document?

a. Page numbers

b. Picture, shapes

c. Tables

d. All of the above

34. What is the shortcut key for spelling check in word document?

a. Shift + F7

b. Ctrl + F7

c. Alt + F7

d. F7

35. Which of these is not an operating system?

a. Linux

b. Android

c. iOS

d. Java

36. Which of them is a cloud storage services?

a. Google meet

b. Outlook

c. Google driver

d. Teams

37. Ethernet card are used for?

a. Sanning

b. Graphics design

c. Internet connection

d. Printing

38. MS Excel is an example of:

a. Database Management System

b. Presentation Software Spreadsheet Software

c. Workbook Software

d. Spreadsheet Software

39. Which of the following is not a web browser?

a. Google

b. Safari

c. Opera

d. Firefox

40. Trojan Virus is a malware that:

a. Affects the operating system

b. Makes a computer slow

c. Creates network traffic

d. Encrypts the data

41. How can you merge the selected cells in the same row in MS Excel?

a. Select cell->Merge cells

b. Select cell->Merge and center

c. Select cell Merge Across

d. Select cell->Unmerged

42. There are a maximum of rows in MS Excel 2021?

a. 16,364

b. 1,048,576

c. Unlimited

d. Can be increased by user

43. ___is a software which is freely available on Internet and open for further improvement, distribution.

a. Open source software

b. Unlicensed software

c. Proprietary software

d. Free software

44. The concept in PowerPoint which controls how presentation moves form one slide to the next slide but now how objects move onto and around a slide.

a. Animation

b. Transaction

c. Effect

d. All of the above

45. Deleting a table from a database can be done using Structured Query Language with the help of:

a. DROP Table Statement

b. DELETE Statement

c. UPDATE Statement

d. Both a and b

46. A computer program wants to create a different numbering style based on chapters of a book typed in MS Word. He may achieve so by using:

a. Footer Setting

b. Line Breaks

c. Page Breaks

d. Section Breaks

47. A page needs a watermark. We can create watermark by setting

a. Page layout

b. Ruler

c. Format painter

d. Section break

48. Full form of GUI is

a. Graphical User Integration

b. Graphical User Interface

c. Graphical User Identification

d. Geometric User Integration

49. A three-layer switch is a kind of:

a. Repeater

b. Bridge

c. Router

d. None of the above

50. Which is used to copy the content of a cell or to create series?

a. Column fill

b. Automatic fill

c. Range fill

d. Series fill