1. What would be result if you type=A1=B1 in cell C1
a. Yes or No
b. True of False (It should be True or False instead of True of False)
c. Invalid Value
d. Value of B1
2. In Ms Excel, concatenation of text can be done using.
a. Apostrophe
b. Exclamation
c. Hash(#)
d. Ampersand(&)
3. In Ms Excel, getting data from a cell located in a different sheet is called
a. Accessing
b. Updating
c. Referencing
d. Functioning
4. Which of the following is not a valid data type in excel?
a. Number
b. Character
c. Label
d. Date/Time
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
6. In MS Access, technique to speed up data retrieval is
a. Indexing
b. Referencing
c. Speeding
d. Listing
7. The technique which define a set of values acceptable for the field is known as
a. Verification
b. Acceptance
c. Validation
d. Setting
8. DDL stands for
a. Data Definition Language
b. Data Deletion Language
c. Data Duplication Language
d. Dual Deduction Language
9. … is a tool to automate tasks and add functionality to your forms, reports and controls
a. List
b. Validation
c. Automation
d. Macros
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
11. … Refers to the way things are arranged on a slide.
a. Slide design
b. Slide layout
c. Slide transition
d. Rehearse timing
12. 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
13. Which of the following HTML tag has an attribute called Frame?
a. <input>
b. <form>
c. <frameset>
d. <table>
14. How can you make a bulleted list?
a. <list>
b. <nl>
c. <ul>
d. <ol>
15. How long is an IPV6 address?
a. 32 bits
b. 128 bytes ( It should be 128 bit instead of 128 bytes)
c. 64 bits
d. 256 bits
16. Total number of bits in KB is
a. 1024
b. 4096
c. 8192
d. 1048576
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
18. Text within <EM>… </EM> tag displays text in … format.
a. Bold
b. Italic
c. List
d. Indented
19. CAD stands for
a. Computer Aided Design
b. Calculator Aided Diagram
c. Customized At Design
d. Computer Aided Diagram
20. The memory which is programmed only at the time of manufacture is
a. ROM
b. RAM
c. PROM
d. EPROM
21. A Computer program that converts program into machine language all at once
a. Interpreter
b. Compiler
c. Simulator
d. Converter
22. The ratio of the horizontal length to the vertical length in monitor is called
a. Aspect Ratio
b. Scale
c. DPI
d. Resolution
23. Number of bits in Nepali Unicode character is
a. 8
b. 64
c. 128
d. 32
24. Location where the 1st Computer instruction available on boot up is
a. BIOS
b. CPU
c. boot.ini
d. CONFIG.SYS
25. In NIC, specification 10/100/1000 refers to
a. Protocol Speed
b. a fiber speed
c. Megabits Per Second
d. Minimum and Maximum server speed
26. In Electronic Transaction Act of Nepal, the method od digital signature is
a. Private-Private key
b. Private-Public key
c. Symmetric Public key
d. All of the above
27. Maximmum number of hosts a local subnet that uses 255.255.255.254 subnet mask is …
a. 14
b. 15
c. 16
d. 30
28. RS-232 is a standard that applies to:
a. parrallel ports
b. Game ports
c. Networks
d. Serial ports
29. Hexadecimal value 20 is equavalent to decimal number
a. 16
b. 20
c. 32
d. 64
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
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
32. … tool helps to reduce file access time from disk
a. Scandisk
b. Disk Defragment
c. Backup
d. Format
33. Which is not true for operating system?
a. Helps to execute applications
b. Performs memory management
c. Solves user’s actual problems
d. Control all the operation of computer
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
35. What is the keyboard shortcut to create a copyright symbol © in MS-Word
a. Alt+C
b. Ctrl+C
c. ALT+Ctrl+C
d. Ctrl+Shift+C
36. In MS-Word, ‘Cover Page’ option is available in tab
a. Home
b. Insert
c. Design
d. Page Layout
37.Keyboard shortcut key to insert an equation in MS-Word
a. Alt + =
b. Ctrl + =
c. Shift + =
d. Ctrl + +
38. Not an option in printed watermark of MS Word
a. No Watermark
b. picture Watermark
c. Text Watermark
d. Logo Watermark
39. Shortcut key to open the open dialog box in MS-Word is
a. F12
b. Shift F12
c. Alt + F12
d. Ctrl + F12
40. What is the maximum number of lines you can set for a drop Cap?
a. 3
b. 5
c. 10
d. 20
41. Bold, Italic, Regular are known as
a. Word art
b. Font effect
c. Font styles
d. Text effect
42. Keyboard shortcut to inserts a column break and start a new column immediately?
a. Psress Alt + Shift + Enter
b. press Alt + Enter
c. Press Ctrl + Enter
d. Press Ctrl + Shift + Enter
43. … combination of keys are used for paste the text.
a. Shift + Insert
b. Shift + Copy
c. Ctrl + Paste
d. None of the above
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
45. In excel, which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #A#1
d. A1
46. What function displays row data in a column or column data in a row?
a. Hyperlink
b. Index
c. Transpose
d. Rows
47. In MS Excel, a function inside another function is fcalled a… fumction.
a. Nested
b. Round
c. Sum
d. Text
48. Which of the following method cannot be used to enter data in a cell?
a. pressing the Esc key
b. Pressing the arrow key
c. Pressing the tab key
d. Clicking the enter button to the formula bar
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
50. In excel, by default numeric values papers in
a. Right aligned
b. Left aligned
c. Center aligned
d. Justify aligned
No comments:
Post a Comment