Computer Operator Solved Questions | Loksewa 078

1. Shortcut key for printing document is?

a. ALT+P

b. Ctrl+M

c. Ctrl+P

d. Ctrl+I

Correct Answer: Ctrl+P

Explanation: Ctrl+P is the shortcut key for windows and almost all application to print..

2. .Paste Special allows some operation where you paste to new cell. Which of the following operation is valid?

a. Square

b. Percentage

c. Goal Seek

d. Divide

Correct Answer: Divide

Explanation: Excel lets you divide the selected cells with the copied cells when pasting using Paste Special Function. Please see the figure..

3. What is the quickest way to select entire worksheet?

a. Choose edit, select all from the menu

b. Click on the first column, press Ctrl, and then click on the last column

c. Click on first column, press Shift, and then click on the last column

d. Click on the rectangle box on the upper left corner where column headings and row headings meet

Correct Answer: Click on the rectangle box on the upper left corner where column headings and row headings meet

Explanation: The quick way to select entire column is to click on column heading; entire row by clicking row heading and entire worksheet by clicking on the box on intersection of row and column heading.

4. A numeric value can be treated as label value if …… precedes it.

a. Apostrophe (‘)

b. Exclamation (!)

c. Hash (#)

d. Tilte (~)

Correct Answer: Apostrophe (‘)

Explanation: Excel recognizes numbers and text and aligns numbers to the right and text to the left of cell. However, you can override this by placing an apostrophe at the beginning of number to enter it as text.

5. How to display updatable current date in MS Excel?

a. Date()

b. Today()

c. Now()

d. Ctl+;

Correct Answer: Today() 

6. A function inside another function is called….

a. Nested round function

b. Sum function

c. Sum function

d. Text function

Correct Answer: Nested Function.

7. If 10/2 entered in a cell without applying any formats, excel will treat this as

a. Fraction

b. Number

c. Date

d. Text

Correct Answer: Date

Explanation: If you enter 10/2 without any format, excel will consider it as 2nd of October and enter it as date value.

8. Which of the following shortcuts can be used to insert a new line in the same cell?

a. Enter

b. Alt+Enter

c. Ctrl+Enter

d. Shift+Enter

Correct Answer:Alt+Enter

Explanation: Alt+Enter works as hard line break when you are typing inside an Excel cell..

9. Chart type to visually compare values across a few categories is …?

a. Pie

b. Column

c. Line

d. Area

Correct Answer: Pie

10. Workbook is collection of?

a. Cells

b. Worksheets

c. Workspaces

d. Projects

Correct Answer: Worksheets

Explanation: A workbook.may contain worksheets, chart sheets, module sheets.

11. Microsoft Access is a

a. RDBMS

b. OODBMS

c. ORDBMS

d. Network Database Model

Correct Answer: RDBMS

Explanation: MS Access is Relational Database Management System.

12. Which of the following is not a type of Microsoft Access Database Object?

a. Table

b. Form

c. Worksheet

d. Module

Correct Answer: Worksheet

Explanation: Access database objects are: Tables, Queries, Forms, Reports, Macro, and Module.

13. In a relational schema, each tuple is divided into fields called

a. Relations

b. Domains

c. Queries

d. All of the above 

Correct Answer: Domains

Explanation: In relational terminology tables are called relations and fields are called attributes.

 14. Which of the following is not an option when printing handouts?

a. Six slides per page

b. Five slides per page

c. Three slides per page

d. Two slides per page

Correct Answer: Five slides per page

15. What is a motion path??

a. A type of animation entrance effect

b. A method of advancing slides

c. A method of moving items on a slide

d. All of the above

Correct Answer: A method of moving items on a slide

Explanation: Motion path is the custom animation effect not slide transition effect. Using motion path you can define how an object will move in a slide.

16. Communication channel is shared by all the machines on the network in

a. Broadcast network

b. Unicast network

c. Multicast network

d. None of above

Correct Answer: Broadcast network

Explanation: In broadcast network all the nodes share same communication channel.

17. Which one of the following extends a private network across public networks?

a. Local area network

b. Virtual private network

c. enterprise private network

d. storage area network

Correct Answer: Virtual Private Network

Explanation: Virtual Private Network or VPN are the private networks across the public network.

18. Which of the following memories needs refreshing?

a. SRAM

b. DRAM

c. ROM

d. All of above

Correct Answer: DRAM

Explanation: DRAM is dynamic RAM which is most volatile in nature. The data in DRAM is lost after a few milliseconds even while continuous power supply is given. Thus it needs to be refreshed periodically to retain data.

19. Which of the following have low failure rate?

a. Mechanical devices

b. Electronic devices

c. Electro-mechanical devices

d. None of above

Correct Answer: Electronic devices

Explanation: Among the given kinds, electronic devices have lower failure rate because it does not have mechanical parts to break down.

20. Any data or instruction entered into the memory of a computer is considered as

a. storage

b. output

c. input

d. information

Correct Answer: Input

Explanation: Any data or instruction that goes into the computer system (here memory) is known as input and comes out from system (computer system) is output. From memory to disk is storage and from disk to memory is loading.

21. Which of the following is not an application software package

a. Redhat Linux

b. Microsoft Office

c. Adobe PageMaker

d. Open Office

Correct Answer: Redhat Linux

Explanation: Redhat Linux is operating system based on linux kernel. It is system software and not application.

22. What is compiler

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

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

c. A compiler is a general purpose language providing very efficient execution

d. None of above

Correct Answer: A compiler converts the whole of higher level program code into machine code in one step

Explanation: The first option indicates interpreter. Option C is invalid. Thus Option B is the correct answer.

23. ASCII stands for

a. American Stable Code for International Interchange

b. American Standard Case for Institutional Interchange

c. American Standard Code for Information Interchange

d. American Standard Code for Interchange Information

Correct Answer: American Standard Code for Information Interchange

24. Computer Virus is a

a. Hardware

b. Software

c. Bacteria

d. Freeware

Correct Answer: Software

Explanation:  Computer viruses are computer software developed with mal-intention.

25. The device primarily used to provide hardcopy is the

a. CRT

b. Computer Console

c. Printer

d. Card Reader

Correct Answer: Printer

26. …… allows us to organize our files so we can more easily find them

a. Navigation

b. Folder

c. Desktop

d. None of above

Correct Answer: Folder

27. The … folder is the default place that most applications want to store data files in

a. Start menu

b. Recycle bin

c. Program files

d. My documents

Correct Answer: My Documents

Explanation:  Among the given options Start menu is the list of available applications and options; Recycle bin is the location to store deleted files; Program files is the folder that store executable files of applications and My documents is the folder for use files.

28. …. Tool helps to reduce the access time from disk

a. Scandisk

b. Disk defragmenter

c. Backup

d. Format

Correct Answer: Disk defragmenter

Explanation; Disk defragmenter arranges the clusters of single file contiguously so that the reading from file is quicker. Thus it reduces the access time from disk.

29. Which is not true for operating system?

a. helps to execute applications

b. performs memory management

c. solves users actual problems

d. controls all the operations of computer

Correct Answer: solves users actual problems.

Explanation: Solving uses actual problems is the job of application software.

30. In computing what is the process by which a running computer system is restarted without the need to interrupt the power?

a. Hibernate

b. Warm boot

c. Cold boot

d. Restart

Correct Answer: Warm boot

31. Which file starts MS Word?

a. winword.exe

b. word.exe

c. msword.exe

d. word2003.exe

Correct Answer: winword.exe

Explanation: winword.exe is the starter file of MS Word. You can type winword.exe in Run dialog box and start the application without accessing menu.

32. Which of the following is not a valid list tag?

a. <al>

b. <li>

c. <ol>

d. <ul>

Correct Answer: <al>

Explanation: We don’t have any tag called <al>

33. Portrait and Landscape are

a. Page orientation

b. Paper size

c. Page layout

d. All of the above

Correct Answer: Page Orientation

34. How can you remove tab stop markers from ruler?

a. Double click on the tab marker and choose clear all

b. Drag the tab stop marker out of the ruler

c. Right click the tab stop marker and choose remove

d. All of above

Correct Answer: Drag the tab stop marker out of the ruler

Explanation: Option A is to clear all the markers and option C does not work. So option B is the correct answer. 

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

Correct Answer: Center indent

Explanation:  There is nothing like center indentation

46. To autofit the width of column

a. Double click the left border of column

b. Double click the right border of column

c. Double click the column header

d. All of above

Correct Answer: Double click the right border of column

37. Which one is the correct HTML tag for the largest heading?

a. head

b. h1

c. h6

d. header

Correct Answer: H1

Explanation:  H1 is the highest level of heading and it is the largest one.

48. Where can you change the vertical alignment

a. Paragraph dialog box

b. Formatting toolbar

c. Page Setup dialog box

d. Standard toolbar

Correct Answer: Page Setup Dialog Box

Explanation:  You can find vertical alignment in Layout tab of PageSetup dialog box.

39. Which of the following is not the merge process

a. soft the data source records

b. merge the two files to print or create a new document

c. edit data source

d. format main document

Correct Answer: Format main document

Explanation: Formatting main document is done while document designing but it is not merge process.  You may need to sort, edit data source and merge them with main document.

40. Automatically placed drop cap in the line

a. 2 lines

b. 3 lines

c. 5 lines

d. 8 lines

Correct Answer: 3 lines

Explanation:  3 lines is the default behavior for drop cap. 

Loksewa computer operation 2074 exams Solution

These are the questions asked by LokSewa Aayog in 2074.There are chances that these questions will repeat.  

1. FAT stands for:

A. File Accomodation Table
B. File Access Tape
C. File Allocation Table
D. File Activity Table

2. Which command will be used to display a file within the specified directory of pathname?
A. dir\pathname
B. dir\pathname\pathname
C. dir\ch
D. dir\pathname\filename

3. Which command is used to delete the directory that is empty?
A. Del *.*
B. RD
C. Erase
D. MD

4. If you need to duplicate the entire disk, which command will you use?
A. Copy
B. Diskcopy
C. Chkdsk
D. Format

5. Portrait and landscape are
A. Page orientation
B. Paper size
C. Page layout
D. All of the above

6. Which of the following is not a font style?
A. Bold
B. Italics
C. Regular
D. Superscript (explanation: Superscript is effect)

7. Which of the following task is accomplished by using bookmarks?
A. To add anchors 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 web page

8. Thesaurus tool in Ms word is used for
A. Spelling suggestions
B. Grammar options
C. Synonyms and antonyms words
D. All of the above

9. In word, the mailing list is known as the …………
A. Data sheet
B.Source
C. Data source
D. sheet

10. Which of the following line spacing is invalid?
A. Single
B. Double
C. Triple
D. Multiple

11. Ctrl+J is used for ……
A. Align Justify
B. Insert hyperlink
C. Search
D. Print

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

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

14. ….. is the ghosted test behind the content on the page
A. Earmark
B. Watermark
C. inkmark
D. Ghostmark

15. What is a portion of a document in which you set different page formatting options than reset of the document?
A. page
B. document
C. section
D. page setup

16. The shortcut key for the format painter is
A. Ctrl+Shift+c
B. Alt+Ctrl+c
C. Alt+shift+c
D. none of the above

17. Which of the following is not a type of page margin?
A. Left
B. Right
 C. Center
D. Top

18. The dimension of A4 size paper is
A. 8.17’’X11.69’’
B. 8.27’’X11.96’’
 C. 8.27’’X11.69’’
D. 8.5’’X11.69’’

19. When you copy a formula in excel, excel
A. erase the original copy of the formula
 B. adjusts cell references in the newly copied formula
C. adjust absolute cell references
D. does out adjust relative cell references

20. NOT, AND, OR and XOR are
 A. Logical Operators
B. Arithmetic Operators
C. Relational Operators
D. Binary Operator

21. Formating a cell in number format you cannot set
A. Decimal place
B. Use 1000 separator
c . Negative numbers
 D. Currency symbol

22. Which shortcut key is used to hide entire column in Excel?
A. Ctrl+?
 B. Ctrl +0(zero)
C. Ctrl+H
D. Ctrl +C

23. The shortcut key is used to switch between sheets
A. Ctrl+Pageup
B. Ctrl+ Page down
C. Alt+ page up
 D. Both A and B

24. The result of 3^2-2*4+1 is
A. 29
 B. 2
C. 35
D. 0

25. The shortcut key for filter in ms excel
A. alt+ctrl+L
 B. ctrl+shift+L
C. alt+ctrl+f
D. ctrl+shift+f

26. The formula ” =T(value) ” is used to check whether a value is …
 A. Text
B. Number
C. Tax
D. Ture

27. Which chart is better represents the progress of stock market on daily basis
A. Pie Chart
B. Row chart
 C. Line chart
D. Column chart

28. Which formula is used to display current date and time in MS Excel?
A. =date()
B. =today()
 C. =now()
D. =time()

29. How are data organized in a spreadsheet?
A. Lines and spaces
B. Layers and plane
 C. Rows and columns
D. Height and width

30. A function inside another function is called a …… function
 A. Nested
B. Round
C. Sum
D. Text

31. In a datasheet, what does each row represents
 A. Record
B. Field
C. Database
D. Table

32. In ms access, “Hyperlink” data type can store…
A. web address
B. email address
C. path of a file
 D. all of the above

33. What do you call a primary key field included in another table?
 A. foreign key
B. parent key
C. child key
D. index

34. In MS Powerpoint, file with readymade styles that can be used for a presentation is called
A. Auto Style
 B. Template
C. Wizard
D. Pre formatting

35. Which view in powerpoint can be used to enter speaker comments?
A. Normal
B. Slide show
C. Slide sorter
 D. Notes page views

36. What is full form of SMPS?
 A. Switch Mode Power Supply
B. Simple Mode Power Supply
C. Storage Mode Power Supply
D. Storage Mode Power Shortage

37. The Section of the CUP that selects, Interprets and see to the execution of program instructions
A. Memory
B. Register Unit
 C. Control Unit
D. ALU

38. Firmware is contained in
A. SRAM
B. DRAM
 C. ROM
D. Cache

39. What invention enabled developers to create microcomputer
 A.integrated circuit
B.transistor
C.vacuum tube
D.magnetic disk

40. Choose the Odd one:
A. Mouse
 B. Plotter
C. Touch Panel
D. Scanner

41. Computer cannot do anything without a
A. chip
B. memory
C. output device
 D. program

42. What is the ASCII code for capital “C” ?
 A. 67
B. 76
C. 99
D. 43

43. ……… enables computer to communicative via telephone line
 A. Modem
B. Motherboard
C. NIC
D. ISP

44. EBCDIC stand 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

45. Before a disk drive can access any sector record, a computer program has to provide the record’s disk address. What information does this address specify?
A. Track number
B. sector number
C. surface number
 D. all of the above

46. The secondary storage devices can only store data but they cannot perform
A. Arithmetic Operation
B. Logic Operation
C. Fetch operation
 D. All of the above

47. A Computer program that converts assembly language to machine language is
A. Compiler
B. Interpreter
 C. Assembler
D. Comparator

48. The communication mode that supports two-way traffic but only one direction at a time is
A. Simplex
B. Half Duplex
C. Duplex
D. Multiplex

49. An error is also known as:
 A. bug
B. debug
C. cursor
D. icon

50. Restore command is used to
 A. Restore file from disks made using the BACKUP command
B. Restore file which are deleted
C. Restore files from recycle bin
D. Restore files which are deleted recently

51. What is the short cut key to open the thesaurus window?
A) Shift+F7
B) Ctrl+F7
C) F7
D) Alt+F7

52. Which shortcut key do you use to double space a paragraph?
A) Ctrl+F2
B) Ctrl+1
C) Ctrl+2
D) Alt+F2

53. Which feature do you use to create newspaper?
A) tables
B) tabs
C) columns
D) bullets and numbering

54. MS word allows creatiion of ……… type of documents by default.
A) .dot
B) .doc
C) .wpf
D) .txt

Day 2: html practice

 <!DOCTYPE html>

<html>

<body>

<h1 style="background-color:Tomato;">Tomato</h1>

<h1 style="background-color:Orange;">Orange</h1>

<h1 style="background-color:DodgerBlue;">DodgerBlue</h1>

<h1 style="background-color:MediumSeaGreen;">MediumSeaGreen</h1>

<h1 style="background-color:Gray;">Gray</h1>

<h1 style="background-color:SlateBlue;">SlateBlue</h1>

<h1 style="background-color:Violet;">Violet</h1>

<h1 style="background-color:LightGray;">LightGray</h1>

</body>

</html

output:

Lets learn mysql from beginner: codewithme

 day1:

lets learn mysql queries to create table and database;

lets take one table sample from that we will write queries later we will learn to create the table and data base

photo from w3school 

once we create the above table and to display all the details as above we need to write the query as:

SELECT SYNATX: SELECT column1,column2.... FROM  tablename

here for us we use * to select all columns and table name is Customer.

SELECT * FROM Customer;

it will display all the details 

To display a particular row we can retrieve using customerID as it is a primary key.

Example:

SELECT * FROM Customer where CustomerID=2;

2 Ana Trujillo Emparedados y helados  Ana Trujillo  Avda. de la Constitución 2222  México D.F. 05021 Mexico

TO select ANY COLUMN from customers then we can use any column name.

example: SELECT City FROM Customers;

it will display all the cities.

To display different values of a particular column we can use keyword "DISTINCT"

example: SELECT DISTINCT Country FROM Customers;

only countries that are different wil be displayed. if any country is repeated many times it will be displayed only once.

WHERE clause: it used to filter the records more  to get more specific data

Syntax: SELECT col1,col2,col3 FROM table_name WHERE= condition;

 

HTML basics: Learn with me

 In this article we will be learning the basic html tags. HTML is an scripting language. It is the skeleton of any websites. HTML is widely used for web development along with css and javascript. 

Lets dive into HTML

DAY 1

<!DOCTYPE html>

<html>

<head><title></title>

<body>

</body>

</html>

This is the  basic structure of the html

Following shows the inline styling :

<body style="background-color:powderblue">

<p style="background-color:tomato">I am normal</p>

<p style="color:red;">I am red</p>

<p style="color:blue;">I am blue</p>

<p style="font-size:50px;">I am big</p>

<p style="text-align:center;">this is centered text</p>

<p style="font-family:courier;">hello mr. subash neupane</p>

<p style="font-size:300%;">hi im alex  </p>

different styles in html:

<p><b>this text is bold</b></p>

<p><i>this text is italic</i></p>

<p>this is _subscript and this is ^superscript</p>

<p><strong>This text is strong</strong></p>

<p><em>This text is emphasized similar to italic</em></p>

<p><del>This text is deleted</del></p>

<p><ins>This text is inserted</ins></p>

<p><small>This text is small</small></p>

<p><big>This text is big</big></p>

<p>Do not forget to buy <mark>milk</mark> today.</p>

<p>My favorite color is <del>blue</del> <ins>red</ins>.</p>

<p>Hello <q> im alex </q></p>

for citation, quotes and blockquote:

<blockquote cite="http://www.worldwildlife.org/who/index.html">

For 50 years, WWF has been protecting the future of nature.

The world's leading conservation organization.

</blockquote>

<p>the <abbr title="world health organization">who</abbr> was founded in 1948</p>

<p> my address is :</p>

<address>shree krishna gandaki 09<br> 

mirmee syagja<br>

gandaki state neppal</address>

<p>hi <q>who_is_subash</q></p>

<!--cite tag-->

<p><cite> Dracula_alex</cite> nick name to alex</p>

<!--bidirectional override of the text-->

<p><bdo dir="rtl">this will be printed from right to left in browser</bdo></p>

<p> for commenting in html tag is [<!--<br>#-->]

<!--for html colors-->

<h1 style="background-color:Tomato;">tomato</h1>

<h2 style="background-color:Silver;">silver</h2>

<h2 style="background-color:LightGray;">lightgray</h2>

<h2 style="background-color:Violet;">voilet</h2>

<h2 style="background-color:Gold;">gold</h2>

<h2 style="background-color:SlateBlue;">slateblue</h2>

<h2 style="background-color:MediumSeaGreen;">mediumseagreen</h2>

<h1 style="background-color:DodgerBlue;">Hello World</h1>

<p style="color:green;">text is green in color</p>

Border:

<h1 style="border: 2px solid red;">border is set for this text with red color </p><br>

for rgba color:

<h1 style="background-color:rgba(99,100,200,0.7);">im alex</h1>

<h1 style="background-color:hsla(120,50%,30%,0.9);">im  alex</h1>

if you want to add saturation ,hue and lightness:

<!--hue saturation light alpha-->

<h1 style="color:hsla(120,50%,30%,0.9);">im alex</h1>

<!--hue saturation light alpha-->

We will learn further in Day 2. Stay safe <^^>