Computer Operator (Local Level)2078/11/14

 



Province Public Service Commission

Gandaki Province

Computer Operator (Local Level)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 add 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 Tab

 

8. The command used to hide a 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 cloud computing system?

A. Back end

B. Management

C. Infrastructure

D. Front end

 

13. The languages 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 Symbol

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 in another cell using Ctrl+V. The content of pasted cell is a:

A. Formula

B. Value

C. Empty value

D. Location

 

21. Real-time meetings can be performed using Google Meet. Similar meetings can be conducted using:

A. Microsoft Outlook

B. Microsoft Teams

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. All +Delete

B. Ctrl + Delete

C. Shift + Delete

D. Windows + Delete

 

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

A. System software

B. Application software

C. Device driver

D. All of the above

 

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

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, Total Credits) in this query which attribute form the primary key?

A. Name

B. Department Name

C. ID

D. Total Credits

 

33. Which of the following items can be inserted into Header or 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. Anroid

C. iOS

D. Java

 

36. Which of them is a Cloud Storage Service?

A. Google Meet

B. Outlook

C. Google Driver

D. Teams

 

37. Ethernet cards are used for:

A. Scanning

B. Graphic Design

C. Internet Connection.

D. Printing

 

38. MS-Excel is an example of:

A. Database Management software

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 & 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 from one slide to the next slide but not how objects move onto and around a slide:

A. Animation

B. Transition

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 & B

 

 

46. A computer operator 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 Settings

B. Line Breaks

C. Page Breaks

D. Section Breaks.

 

 

47. A page needs a watermark. We can create watermarks 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. Geometrical 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

 The End

 


Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2