Explain the diligence and versatility features of computer.
How do you define the term computer software? Explain types of computer software.
"Operating system works as user interface." Justify this statement with a suitable example.
What is a data warehouse? Explain advantages and disadvantages of a data warehouse.
Define computer network. Why do organizations need a computer network?
What is computer protocol? Explain two different e-mail protocols.
What is hypermedia? Write down the applications of augmented reality.
Attempt any TWO questions
[2x10=20]a) Consider the following Excel Sheet and write down the correct formula based on conditions:
| XYZ COMPANY KATHMANDU | ||||||
|---|---|---|---|---|---|---|
| TAX | ||||||
| SN | Name | Salary | Service Tax | Income Tax | Total | Net Salary |
| 1 | Bishnu KC | 10,000 | ? | ? | ? | ? |
| 2 | Ram Gurung | 20,000 | ? | ? | ? | ? |
| 3 | Nikita Nepal | 35,000 | ? | ? | ? | ? |
| 4 | Gita Karki | 40,000 | ? | ? | ? | ? |
i. Service tax will be 5% for employees with a yearly salary greater than 1,50,000; otherwise, 1%.
ii. Income tax will be:
- 0% for yearly salary up to 1,00,000
- 10% for yearly salary less than 2,00,000
- 15% otherwise
iii. Total = Service Tax + Income Tax
iv. Net Salary = Salary - Total Tax
b) Explain the following DOS Commands with suitable examples:
ATTRIB
XCOPY
MKDIR
MOVE
DEL
a) Explain the major functions available in the Layout tab of a Word document.
b) What is the use of a layer in Photoshop? How do you organize layers in Adobe Photoshop?
What are hardcopy devices? Explain the working mechanism of dot-matrix, laser, and ink-jet printers.