2074-05-23 Question Answer
Key :B 2074-05-23 Full Marks: 50
Time:45
Objective Question Answer 50*1=50
1. What would be result if you type =A1=B1 in cell C1
A) Indexing B) Referencing C) Speeding D) Listing
Ans: A
7. The technique which define a set of values acceptable for the field is known as
A) Verification B) Acceptance C) Validation D) Setting
Ans: C
8. DDL stands for
A) Data Definition Language B) Data Deletion Language
C) Data Duplication Language D) Dual Deduction Language
Ans: A
9........... is a tool to automate tasks and add functionality to your forms, reports and controls
A) List B) Validation C) Automation D) Macros
Ans: D
10. 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
Ans: B
11. ........... Refers to the way things are arranged on a slide.
A) Slide design B)Slide layout C) Slide transition D) Rehearse timing
Ans: B
12. What is a motion path?
A) A type of animation entrance effect B) A method advancing slides
C) A method of moving items on a slide D) All of the above
Ans: C
13. Which of the following HTML tag has an attribute called frame?
A) <input> B) <form> C) <frameset> D) <table>
Ans: C
14. How can you make a bulleted list?
A) <list> B) <nl> C) <ul> D) <ol>
Ans: C
15. How long is an IPv6 address?
A) 32 bits B) 128bytes C) 64bits D) 256bits
Ans: B
16. Total number of bits in 1KB is
A) 1024 B) 4096 C) 8192 D) 1048576
Ans: A
17. What is the size of source and destination IP address in IP header?
A) 4 bits B) 8 bits C) 12 bits D) 32 bits
Ans:D
18. Text within <EM>.......</EM> tag displays text in ....... format.
A) Bold B) Italic C) List D) Indented
Ans: B
19. CAD stands for
A) Computer Aided Design B) Calculator Aided Diagram
C) Customized At design D) Computer Aided Diagram
Ans: A
20 The memory which is programmed only at the time of manufacture is
A) ROM B) RAM C) PROM D) FPROM
Ans: A
21. A computer program that converts program into machine language all at once
A) interpreter B) Compiler C) Simulator D) Converter
Ans: B
22. The ration of the horizontal length to the vertical length in monitor is called
A) Aspect Ration B) Scale C) DPI D) Resolution
Ans: A
23. Number of bits in Nepali Unicode character is
A) 8 B) 64 C) 128 D) 32
Ans: B
24. Location where the 1st computer instructions available on boot up is
A) BIOS B) CPU C) boot.ini D)CONFIG.SYS
Ans: A
25. In NIC specification 10/ 100// 1000 refers to
A) Protocol speed B) a fiber speed
C) Megabits per seconds D) Minimum and Maximum server speed
Ans: C
26. In Electronic Transaction Act of Nepal, the method of digital signature is
A) Private-Private key B) Private-public key C) Symmetric Public key D) All of the above
Ans: B
27. Maximum number of hosts on a local subnet that uses 255.255.255.224 subnet mask is.....
A) 14 B) 15 C) 16 D) 30
Ans:
28. RS-232 is a standard that applies to :
A) parallel ports B) Game ports C) Networks D) Serial ports
Ans:D
29. Hexadecimal value 20 is equivalent to decimal number
A) 16 B) 20 C) 32 D) 64
Ans: C
30. In computing, what is the process by which running computer system is restarted without the need to interrupt the power?
A) Hibernate B) Warm Boot C) Cold Boot D) Restart
Ans: C
31. The ..... folder is the default place that most application want to store data files in.
A) Start menu B) Recycle Bin C) Program Files D) My Documents
Ans: D
32. ..... tools helps to reduce file access time from disk.
A) Scandisk B) Disk derangement C) Backup D) Format
Ans: B
33. Which is not true for operating system ?
A) Helps to execute applications B) Performs memory management
C) Solves users' actual problems D) Control all the operations of computer
Ans: C
34....... allow(s) us to organize our files so we can more easily find them.
A)Navigation B) Folders C) Desktop D) None of the above
Ans: B
35. What is the keyboard shortcut to create a copyright symbol c in MS-Word?
A) Alt +C B) Ctrl+ C C) Alt + Ctrl + C D) Ctrl+ Shift+ C
Ans: C
36. In Ms-Word, 'Cover Page' option is available in tab
A) Home B) Insert C) Design D) Page Layout
Ans: B
37. Keyboard Shortcut to insert an equation in MS-Word
A) Alt += B) Ctrl + = C) Shift += D) Ctrl ++
Ans: A
38. Note an option in printed watermark of MS Word
A) No watermark B) Picture Watermark C) Text Watermark D) Logo Watermark
Ans: D
39. Shortcut key to open the open dialog box in MS-Word is
A) F12 B) Shift F12 C) Alt +F12 D) Ctrl+ F12
Ans: D
40. What is the maximum number of lines you can set for a drop cap ?
A) 3 B) 5 C) 10 D) 20
Ans: C
41. Bold,Italic, Regular are known as
A) Word art B) Font effects C) Font Styles D) Text effects
Ans: C
42. Keyboard shortcuts to inserts a column break and start a new column immediately ?
A) Press Alt+ Shift+Enter B) Press Alt+Enter C) Press Ctrl+ Enter D)Press Ctrl+ Shift+Enter
Ans:D
43...... Combination of keys are used for paste the text.
A) Shift+ Insert B) Shift+ Copy C) Ctrl+ Paste D) None of the Above
Ans: A
44. The A4 paper width/ height is .......
A)8.27"/11.69" B) 8.5"/11.7" C) 8.77"/11.9" D)None of the above
Ans:A
45. In Excel, which of the following is an absolute cell reference ?
A) !A!1 B) $A$1 C) #a#1 D) A1
Ans: B
46. What function displays row data in a column data in a row ?
A) Hyperlink B) Index C) Transpose D) Rows
Ans: C
47. In Ms Excel, a function inside another function is called a ................. function.
A) Nested B) Round C) Sum D) Text
Ans: A
48. Which of the following methods cannot be used to enter data in a cell ?
A) Pressing the Esc key B) Pressing an arrow key
C) Pressing the tan key D) Clicking the enter button to the formula bar
Ans: A
49. Which options allows you to bold all the negative values within the selected cell range
A) Zero formatting B) Conditional formatting C) Compare formatting D) Negative formatting
Ans: B
50. In excel, by default numeric values appears in
A) Right aligned B) Left aligned C) Center aligned D) Justify aligned
Time:45
Objective Question Answer 50*1=50
1. What would be result if you type =A1=B1 in cell C1
A)Yes or No B) True of False C) Invalid value D) Value of B1
Ans:B
2.In Ms Excel, Concatenation of text can be done using.
A) Apostrophe (') B) Exclamation (!) C) Hash (#) D) Ampersand(&)
Ans: D
3. In Ms Excel, getting data from a cell located in a different sheet is called
A) Accessing B) Updating C) Referencing D) Functioning
Ans: C
4. Which of the following is not a valid date type in excel ?
A) Number B) Character C) Label D) Functioning
Ans:B
5. Which of the following is the correct order of keywords for SQL SELECT statements ?
A) SELECT, WHERE, FROM B) FROM, WHERE, SELECT
C) WHERE, FROM, SELECT D) SELECT, FROM , WHERE
Ans: D
6. In MS ACCESS, technique to speed up data retrieval is
6. In MS ACCESS, technique to speed up data retrieval is
A) Indexing B) Referencing C) Speeding D) Listing
Ans: A
7. The technique which define a set of values acceptable for the field is known as
A) Verification B) Acceptance C) Validation D) Setting
Ans: C
8. DDL stands for
A) Data Definition Language B) Data Deletion Language
C) Data Duplication Language D) Dual Deduction Language
Ans: A
9........... is a tool to automate tasks and add functionality to your forms, reports and controls
A) List B) Validation C) Automation D) Macros
Ans: D
10. 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
Ans: B
11. ........... Refers to the way things are arranged on a slide.
A) Slide design B)Slide layout C) Slide transition D) Rehearse timing
Ans: B
12. What is a motion path?
A) A type of animation entrance effect B) A method advancing slides
C) A method of moving items on a slide D) All of the above
Ans: C
13. Which of the following HTML tag has an attribute called frame?
A) <input> B) <form> C) <frameset> D) <table>
Ans: C
14. How can you make a bulleted list?
A) <list> B) <nl> C) <ul> D) <ol>
Ans: C
15. How long is an IPv6 address?
A) 32 bits B) 128bytes C) 64bits D) 256bits
Ans: B
16. Total number of bits in 1KB is
A) 1024 B) 4096 C) 8192 D) 1048576
Ans: A
17. What is the size of source and destination IP address in IP header?
A) 4 bits B) 8 bits C) 12 bits D) 32 bits
Ans:D
18. Text within <EM>.......</EM> tag displays text in ....... format.
A) Bold B) Italic C) List D) Indented
Ans: B
19. CAD stands for
A) Computer Aided Design B) Calculator Aided Diagram
C) Customized At design D) Computer Aided Diagram
Ans: A
20 The memory which is programmed only at the time of manufacture is
A) ROM B) RAM C) PROM D) FPROM
Ans: A
21. A computer program that converts program into machine language all at once
A) interpreter B) Compiler C) Simulator D) Converter
Ans: B
22. The ration of the horizontal length to the vertical length in monitor is called
A) Aspect Ration B) Scale C) DPI D) Resolution
Ans: A
23. Number of bits in Nepali Unicode character is
A) 8 B) 64 C) 128 D) 32
Ans: B
24. Location where the 1st computer instructions available on boot up is
A) BIOS B) CPU C) boot.ini D)CONFIG.SYS
Ans: A
25. In NIC specification 10/ 100// 1000 refers to
A) Protocol speed B) a fiber speed
C) Megabits per seconds D) Minimum and Maximum server speed
Ans: C
26. In Electronic Transaction Act of Nepal, the method of digital signature is
A) Private-Private key B) Private-public key C) Symmetric Public key D) All of the above
Ans: B
27. Maximum number of hosts on a local subnet that uses 255.255.255.224 subnet mask is.....
A) 14 B) 15 C) 16 D) 30
Ans:
28. RS-232 is a standard that applies to :
A) parallel ports B) Game ports C) Networks D) Serial ports
Ans:D
29. Hexadecimal value 20 is equivalent to decimal number
A) 16 B) 20 C) 32 D) 64
Ans: C
30. In computing, what is the process by which running computer system is restarted without the need to interrupt the power?
A) Hibernate B) Warm Boot C) Cold Boot D) Restart
Ans: C
31. The ..... folder is the default place that most application want to store data files in.
A) Start menu B) Recycle Bin C) Program Files D) My Documents
Ans: D
32. ..... tools helps to reduce file access time from disk.
A) Scandisk B) Disk derangement C) Backup D) Format
Ans: B
33. Which is not true for operating system ?
A) Helps to execute applications B) Performs memory management
C) Solves users' actual problems D) Control all the operations of computer
Ans: C
34....... allow(s) us to organize our files so we can more easily find them.
A)Navigation B) Folders C) Desktop D) None of the above
Ans: B
35. What is the keyboard shortcut to create a copyright symbol c in MS-Word?
A) Alt +C B) Ctrl+ C C) Alt + Ctrl + C D) Ctrl+ Shift+ C
Ans: C
36. In Ms-Word, 'Cover Page' option is available in tab
A) Home B) Insert C) Design D) Page Layout
Ans: B
37. Keyboard Shortcut to insert an equation in MS-Word
A) Alt += B) Ctrl + = C) Shift += D) Ctrl ++
Ans: A
38. Note an option in printed watermark of MS Word
A) No watermark B) Picture Watermark C) Text Watermark D) Logo Watermark
Ans: D
39. Shortcut key to open the open dialog box in MS-Word is
A) F12 B) Shift F12 C) Alt +F12 D) Ctrl+ F12
Ans: D
40. What is the maximum number of lines you can set for a drop cap ?
A) 3 B) 5 C) 10 D) 20
Ans: C
41. Bold,Italic, Regular are known as
A) Word art B) Font effects C) Font Styles D) Text effects
Ans: C
42. Keyboard shortcuts to inserts a column break and start a new column immediately ?
A) Press Alt+ Shift+Enter B) Press Alt+Enter C) Press Ctrl+ Enter D)Press Ctrl+ Shift+Enter
Ans:D
43...... Combination of keys are used for paste the text.
A) Shift+ Insert B) Shift+ Copy C) Ctrl+ Paste D) None of the Above
Ans: A
44. The A4 paper width/ height is .......
A)8.27"/11.69" B) 8.5"/11.7" C) 8.77"/11.9" D)None of the above
Ans:A
45. In Excel, which of the following is an absolute cell reference ?
A) !A!1 B) $A$1 C) #a#1 D) A1
Ans: B
46. What function displays row data in a column data in a row ?
A) Hyperlink B) Index C) Transpose D) Rows
Ans: C
47. In Ms Excel, a function inside another function is called a ................. function.
A) Nested B) Round C) Sum D) Text
Ans: A
48. Which of the following methods cannot be used to enter data in a cell ?
A) Pressing the Esc key B) Pressing an arrow key
C) Pressing the tan key D) Clicking the enter button to the formula bar
Ans: A
49. Which options allows you to bold all the negative values within the selected cell range
A) Zero formatting B) Conditional formatting C) Compare formatting D) Negative formatting
Ans: B
50. In excel, by default numeric values appears in
A) Right aligned B) Left aligned C) Center aligned D) Justify aligned
"The End"